Monthly Archives: April 2016
-
Certificates, Proxies and Jobs! Oh My!
3April 27, 2016 by Kenneth Fisher
Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
Continue reading -
Get your SQL Server MCSA without taking the BI exam.
2April 25, 2016 by Kenneth Fisher
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new …
Continue reading -
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
SQL Studies 