What do they want to hear?
I was helping my 16yo write his first college essay the other day. He’s always struggled a bit with writing ... Continue reading
2020-11-03 (first published: 2020-10-29)
321 reads
SQLStudies
How do I test if a linked server works using T-SQL?
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they ... Continue reading
2020-10-29 (first published: 2020-10-27)
843 reads
SQL Virtual Machines
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading
2020-10-22
177 reads
My 800th post!
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading
2020-10-20
6 reads
Permissions script for Azure Synapse
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading
2020-10-22 (first published: 2020-10-15)
266 reads
A table is like a library : T-SQL Tuesday #131
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like ... Continue reading
2020-10-20 (first published: 2020-10-13)
459 reads
All triggers have to be able to handle multiple row operations.
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading
2020-09-11 (first published: 2020-09-03)
468 reads
SQL Homework – September 2020 – More DML Triggers
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
98 reads
As a DBA, am I a gatekeeper?
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
183 reads
SQL Homework – August 2020 – More DML Triggers
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading
2020-08-13
85 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
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