SQLBits in Space
It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to...
2016-03-29 (first published: 2016-03-22)
1,400 reads
ETL Auditing
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,294 reads
SQL Server Service Broker – Introduction
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced...
2016-03-30 (first published: 2016-03-22)
2,301 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after...
2016-03-21
13 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-21
205 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-28 (first published: 2016-03-21)
1,795 reads
SQL Data Generator –Specific Domains for a Column
I was mocking up some test data and wanted to limit my list of values to specific items. In this...
2016-03-25 (first published: 2016-03-21)
1,561 reads
Monday Morning SQL Break – March 21, 2016
Monday, Monday, Monday… let’s start with a wrap-up of last week’s blog and twitter activity. If you haven’t already, follow me...
2016-03-21
439 reads
Cross Database Query in Azure SQL Database
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...
2016-03-28 (first published: 2016-03-21)
3,137 reads
TOP 1 killed my performance; Rob Farley helped me resurrect it.
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...
2016-03-25 (first published: 2016-03-21)
4,629 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