Monthly Archives: April 2015
-
Running Powershell scripts remotely.
2April 29, 2015 by Kenneth Fisher
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of …
Continue reading -
What SQL version is my SSIS package?
28April 27, 2015 by Kenneth Fisher
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how …
Continue reading -
Backup before you restore
4April 22, 2015 by Kenneth Fisher
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back …
Continue reading -
The hidden security of msdb
3April 20, 2015 by Kenneth Fisher
To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions …
Continue reading -
Adding, altering or removing multiple columns from a table
2April 16, 2015 by Kenneth Fisher
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing …
Continue reading -
Remotely shutting down an instance
1April 14, 2015 by Kenneth Fisher
This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t) …
Continue reading -
Make sure you back up the Service Master Key
6April 8, 2015 by Kenneth Fisher
I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master …
Continue reading -
What is a CTE
3April 6, 2015 by Kenneth Fisher
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. …
Continue reading -
Microsoft buys the dictionary
3April 1, 2015 by Kenneth Fisher
It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as …
Continue reading
SQL Studies 