Did you know…you can’t do arithmetic operations with datetime2 like with datetime?
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...
2018-04-11 (first published: 2018-04-06)
2,660 reads
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...
2018-04-11 (first published: 2018-04-06)
2,660 reads
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
503 reads
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
861 reads
In two weeks from now, on 23rd of February, I will be speaking at SQLBits 2018! It’s my first time on the largest SQL Server conference in Europe for...
2018-02-09
8 reads
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...
2018-01-23
738 reads
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...
2017-12-15 (first published: 2017-12-05)
2,485 reads
Last night, I received Adam Machanic’s (b | t) newsletter “Announcing sp_whoisactive v11.20: Live Query Plans”.
For those who don’t know about it, sp_WhoIsActive is a stored procedure that provides...
2017-12-05
11 reads
Today I will write just a short blog post to do a quick reminder!
I still hear a lot of people suggesting CTEs because they think it works like a...
2017-11-30
7 reads
Today I will write just a short blog post to do a quick reminder! I still hear a lot of...
2017-11-30
706 reads
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
3 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