Source Control for the Reluctant DBA
This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I...
2016-07-13
917 reads
The Database Avenger
SQL Server and Continuous Integration
This is the 1st in a series of posts on SQL Server and Continuous Integration. Some of the tools I’ll be...
2016-07-07
753 reads
Selective Logging with the UPDATE() Function
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested...
2016-06-22 (first published: 2016-06-16)
2,370 reads
Deletes Ignore Check Constraints
I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in...
2016-06-03 (first published: 2016-05-30)
3,547 reads
Broken Update With Join
Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see...
2016-05-26 (first published: 2016-05-18)
1,787 reads
Minimum Memory Grant Query Hint
This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...
2016-05-19 (first published: 2016-05-10)
3,453 reads
Cumulative Updates Every 2 Months
The SQL Server team is implementing an Incremental Servicing Model (ISM) to deliver updates for SQL Server. This is basically a...
2016-04-25
596 reads
Broken Left Join
Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.
SELECT e.Name,...
2016-04-21
569 reads
Partition Switching #TSQL2SDAY #77
The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does...
2016-04-20 (first published: 2016-04-12)
4,148 reads
Certain DBs in an AG not Backing Up
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
978 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers