Quick tip: WMI alerts and SQL Server Agent permissions.
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,594 reads
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,594 reads
SQL Server 2014 CTP is available for download and evaluation and it contains a couple of exciting performance enhancements. One...
2013-07-08
2,535 reads
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,622 reads
In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...
2013-04-11 (first published: 2013-04-03)
4,061 reads
I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...
2013-02-20 (first published: 2013-02-14)
7,083 reads
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
6,131 reads
There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...
2012-11-26 (first published: 2012-11-13)
4,368 reads
Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...
2012-11-02 (first published: 2012-10-31)
4,425 reads
Here are a couple of quick database and table level queries that I have found useful lately.
How many rows in...
2012-10-30
1,618 reads
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,386 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers