Sarasota SQL Server User Group Presentation
I presented a one-hour session at the Sarasota SQL Server User Group entitled “Powershell vs T-SQL”. The session Description:
“Automating database tasks traditionally has meant creating Transact-SQL code or an SSIS package. While the introduction of Powershell provides another option, DBAs who are already familiar with Transact-SQL and SSIS, question how Powershell fits into SQL Server Managementability. This session will provide a general overview of Powershell, the SQL Server 2008 Powershell host, and demonstrate use cases where Powershell provides an easier solution than T-SQL or SSIS. Likewise, use cases will be highlighted where T-SQL provides a superior solution over Powershell..”
The presentation and supporting material is available here
Please comment or contact me with any questions.
Previous post: Using Powershell to Import Excel file into SQL Server