Tag Archives: microsoft sql server
-
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 -
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 -
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 -
0 to Speaker
14March 23, 2015 by Kenneth Fisher
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I …
Continue reading -
Why not NOLOCK?
10March 18, 2015 by Kenneth Fisher
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
Continue reading -
There are #temp tables and then there are ##temp tables.
1March 16, 2015 by Kenneth Fisher
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
Continue reading -
Using Solutions in SSMS
16March 11, 2015 by Kenneth Fisher
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
Continue reading -
Who’s using that database?
1March 9, 2015 by Kenneth Fisher
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading -
I want to blog but …
2March 4, 2015 by Kenneth Fisher
I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally …
Continue reading
SQL Studies 