About Me
Me and my DottyLou
I am a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server.
I have experience managing enterprise-wide data needs in both transactional and data warehouse environments. I also hold certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V).
I help run the PowerShell Virtual Chapter of PASS, volunteer for the local PASS Chapter AtlantaMDF, help run the Atlanta PowerShell User Group, and help organize SQL Saturday in Atlanta.
-
I’m started out thinking I was just going to blog about SQL Server and then I downloaded SQLPSX. The rest as they say…
-
I’m not an accidental DBA. I’m a Second Generation DBA.
-
If you’re trying to get ahold of me just give me a shout on twitter or figure out my ultra-secret email address that is my first name at this domain dotcom.
6 Comments
Hi Aaron,
At SQLSaturday #111, you gave a tip on how to easily script out data for an Insert statement from a populated table. For the life of me, I can’t find that feature in SSMS. Was than an SSMS feature or was it from one of the add-ins that you spoke of or was it a PowerShell script?
Thanks!
Angela,
That was from SSMS Tools Pack: www.ssmstoolspack.com/
I have a question on your example to deploy a SQL Script to multiple machines with just 4 lines of PowerShell solution. I am trying to build something similar in Powershell. However, I can’t figure out how to capture the error from SQL Server if there is one when using invoke-sqlcmd . For example, if I am deploying a stored procedure and the stored procedure already exists in that database, I want to see the erorr “There is already an object named in the database.” in the results window. Can I do that?
Thanks,
Laura
Hello @SQLVariant,
This is @supercyberal, we met and talked about PowerShell in this last SQLSaturday in Tampa (SQLSaturday 62). I have a question, I’m in great need of implementing DB versioning at our company. Would happen to know any solution/approach for that? I know that the web is full of tips about that, but I’d like to know from someone that already went through that (if this is your case) or know any article.
In the mean time, thanks for your time and help.
Alvaro Costa
Twitter: @supercyberal
Aaron,
Could you please send or upload somewhere ps scripts, that you showed on Pass Summit
Thank you
Yep, I actually uploaded them before the session. You can find them here:
sqlvariant.com/wordpress/index.php/2010/11/speaking-at-the-pass-summit-today/