Category Archives: Microsoft SQL Server
-
Name the schema when you create an object (or else)
Leave a commentApril 6, 2016 by Kenneth Fisher
This is one of those frequently ignored best practices. When you create an object, specify the schema where it will …
Continue reading -
Complex/Conditional ORDER BYs
1April 4, 2016 by Kenneth Fisher
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed. …
Continue reading -
Hidden code in AdventureWorks
4April 1, 2016 by Kenneth Fisher
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t …
Continue reading -
When should I test?
1March 30, 2016 by Kenneth Fisher
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the …
Continue reading -
Why you shouldn’t use SELECT *
1March 28, 2016 by Kenneth Fisher
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?) …
Continue reading -
I’m presenting for the Pass Security Virtual Chapter!
1March 23, 2016 by Kenneth Fisher
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. …
Continue reading -
TOP 1 killed my performance; Rob Farley helped me resurrect it.
15March 21, 2016 by Kenneth Fisher
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if …
Continue reading -
What permissions do I need?
Leave a commentMarch 16, 2016 by Kenneth Fisher
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
Continue reading -
Pulling data from a non-clustered index
1March 14, 2016 by Kenneth Fisher
This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
Continue reading -
You don’t need to be a sysadmin
9March 10, 2016 by Kenneth Fisher
Hey, I need sysadmin access to ServerA. Ok. Why do you need sysadmin? Well I need to be able to …
Continue reading
