Category Archives: SQLServerPedia Syndication
-
Why my primary test environment is case sensitive.
1April 20, 2016 by Kenneth Fisher
Me: I think I’m going create a new playground instance. Myself: Make sure you use a case sensitive (CS) collation …
Continue reading -
How do I rename a column?
2April 18, 2016 by Kenneth Fisher
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to …
Continue reading -
Modulo!
7April 14, 2016 by Kenneth Fisher
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even …
Continue reading -
The risks of Delayed Durability
3April 12, 2016 by Kenneth Fisher
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about …
Continue reading -
Name the schema when you create an object (or else)
1April 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?
2March 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 *
2March 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
SQL Studies 