geek sync i the essential powershell tools for the database administrator
TRANSCRIPT
The Essential PowerShell Tools for the DBA Administrator
June 1, 2016
Visual Studio Communuty
Some Tools for DBA’sIdera’s PowerShell Plus
PowerShell SSIS IntegrationQuestions
3
12
4
1
5
Some Tools for the DBA’s
Download SQL Server Data Tools Preview in Visual Studio 2015https://msdn.microsoft.com/en-us/mt429383
Download SQL Server Data Tools Preview in Visual Studio 2013https://www.microsoft.com/en-us/download/details.aspx?id=42313
IDERA PowerShellPlus Toolhttps://www.idera.com/productssolutions/freetools/powershellplus
2
Some Tools for the DBA’s
Download SQL Server Data Tools (SSDT)https://msdn.microsoft.com/en-us/library/mt204009.aspx
Previous releases of SQL Server Data Tools (SSDT and SSDT-BI) for Visual Studio 2013https://msdn.microsoft.com/en-us/library/mt674919.aspx
Convert VB to C# Online Toolhttp://www.developerfusion.com/tools/convert/csharp-to-vb/
3
Visual Studio Community (free)
Integrating your tools• PowerShell Tools for VS 2013( or 2015)• Idera’s PowerShellPlus (and others)• Source Control availability: TFS, GitHub (not
covered)
4
Visual Studio Community (free)
DEMO
5
PowerShell VS SSIS Integration
Using SQL Server Tools for Business Intelligence• DOS batch
– Understanding Exit Codes• .NET VSTA scripting
– Debug in Visual Studio
6
PowerShell VS SSIS Integration
DOS Batch file• Return Exit Code
• Echo %ErrorLevel% (other than 0 = Error)• PowerShell $LastExitCode
• You assign any value > 0• Sample DOS batch to Execute PowerShell file.
7
PowerShell VS SSIS Integration
.NET VSTA scripting• SSIS Script Task Component
• Pick .NET language: C# or VB.NET• Add Reference: System.Management.Automation• Add Namespace (when needed)• Add Code to execute PowerShell script• Use Debug bookmarks (when needed)
8
PowerShell VS SSIS Integration
DEMO
9
Don’t forget to check out the
previously recorded Geek Sync
webcasts to learn more about
PowerShell and SQL Server.
Thank You!
https://www.idera.com/events/geeksync
Head over to IDERA.com to
download any of our product trials
free for 14-days.
Free Trials