Quick Tip: Migrating a SQL Server Mirroring Witness server.
If you’re like me, you might be thinking “I want some more things to think about when I migrate between...
2014-03-27
668 reads
Two IDs, One database and a Magic Number (and maybe even an empty string)
TweetG’day,
I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least...
2014-03-26
1,350 reads
SQL Scripts Manager
We have Down Tools Week multiple times per year at Red Gate. This allows various employees to spend a week...
2014-03-26
4,179 reads
Zap Business Intelligence Installation
This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the...
2014-03-26
965 reads
Speaking at OPASS – April 2014
If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a...
2014-03-26
627 reads
SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA
We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an...
2014-03-26
615 reads
The Unusable User–Question Of The Day
My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for...
2014-03-26
693 reads
Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-26
513 reads
Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-04-02 (first published: 2014-03-26)
1,743 reads
Getting an INDEX SEEK to Speed up LIKE “%string%” Searches
In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow...
2014-03-26
20,700 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers