Name the schema when you create an object (or else)
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
694 reads
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
694 reads
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
475 reads
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t...
2016-04-01
501 reads
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
794 reads
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
506 reads
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...
2016-03-25 (first published: 2016-03-21)
4,629 reads
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....
2016-03-23
477 reads
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
478 reads
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,323 reads
This is one of those things that I found very interesting but figured I’d probably never really use. Of course...
2016-03-14
497 reads
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers