SQL Homework – December 2018 – Configure SSMS
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
198 reads
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
198 reads
To help promote the seperation of duties one of the things my company has done is to divide our permissions...
2018-11-29 (first published: 2018-11-19)
2,385 reads
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,529 reads
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck....
2018-11-21
937 reads
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed...
2018-11-14 (first published: 2018-11-05)
1,939 reads
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...
2018-11-13
227 reads
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...
2018-11-12 (first published: 2018-10-31)
2,896 reads
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to...
2018-11-07
223 reads
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you...
2018-10-31 (first published: 2018-10-22)
2,624 reads
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...
2018-10-29
317 reads
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...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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