Category Archives: SQLServerPedia Syndication
-
Building a job to monitor other jobs
5May 4, 2015 by Kenneth Fisher
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows …
Continue reading -
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?
29April 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 -
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 -
Port numbers and SQL Server
Leave a commentMarch 30, 2015 by Kenneth Fisher
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
Continue reading -
Clean out all bad characters from a string.
10March 25, 2015 by Kenneth Fisher
I have a customer who is having a problem with a load. He is getting a fair number of bad …
Continue reading
SQL Studies 