Extreme situations require extreme commands
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
383 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...
2017-03-13
18 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...
2017-03-13
1,520 reads
Using tSQLt to Find Min/Max Times
I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since...
2017-03-13
1,148 reads
Using Virtual Desktops for Presentations
Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...
2017-03-13
511 reads
Why You Should Change the Cost Threshold for Parallelism
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...
2017-03-23 (first published: 2017-03-13)
3,119 reads
2016/2017 Whitepaper Updates
One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...
2017-03-13
537 reads
T-SQL Programming for Developers Course
Are you a software developer?
Did you ever get to develop a software that works with a Microsoft SQL Server database?
...
2017-03-13
806 reads
SQL Server Query Store
Query Store was, probably without doubt, the most anticipated and talked out new feature in SQL 2016. Certainly by the...
2017-03-29 (first published: 2017-03-13)
6,379 reads
Cumulative Update #11 for SQL Server 2014 SP1
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...
2017-03-13
500 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