With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the covers or that sqlps is PowerShell V2 because it returns $psversiontable information. Although, technically, sqlps neither PowerShell V1 nor V2, the answer to this question is a little more complicated… Read more

If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a busy server with many SQL jobs scheduled to run throughout the day at various times finding clashing job schedules and long running jobs is hard to do using the native… Read more

In case you’re wondering about the title T-SQL Tuesday, it’s a monthly collection of SQL Server related content where a bunch of bloggers contribute posts related a specific topic. This month’s topic hosted by Michael Coles is Large Object data types or also know as Blobs. In this blog… Read more