Category Archives: Development

Executing SQL Statements using PowerShell

February 1, 2014 11:24 am / Leave a Comment /

Executing SQL Statements using PowerShell

The SQL Server SMO client API can be used query and alter settings and objects within your SQL Server instances. In case you want to query your user database; you will run into some limitations. The client API isn’t aware of your data objects and, therefore, not exposing a typed scheme. Fortunately, it’s pretty easy to accomplish when using the SQL Server PowerShell Module (SQLPS)

Read More →

Scripting SQL Server installations

January 10, 2014 11:48 pm / Leave a Comment /

Scripting SQL Server installations

I was addressing performance issues onsite just a couple of weeks ago. While waiting for the right authorizations, access tokens, and whatever you need nowadays just to run some scripts…, one of the developers approached me. They asked for some insights on how to Scripting SQL Server installations.

Read More →