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
688 reads
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
688 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
469 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
499 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
786 reads
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
505 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,620 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
468 reads
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
475 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,320 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
488 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers