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
716 reads
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
716 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
487 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
516 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
797 reads
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
511 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,638 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
479 reads
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
483 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,327 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
506 reads
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Palantir is an American software platform that brings together business data from different sources...
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Packing and Decoding Device Status...
Comments posted to this topic are about the item SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers