Embrace The Missing Index DMVs - But Proceed with Caution!
One of the performance tools I use all of the time is the set of Missing Index DMVs: · sys.dm_db_missing_index_details– Detailed...
2017-03-22 (first published: 2017-03-09)
4,145 reads
Metadata Hygiene
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
421 reads
Create a DACPAC to Move Databases–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-08
948 reads
Identifying a row’s physical location
While you may not need to worry about the physical location of a row very often, every so often the...
2017-03-08
517 reads
Review of Azure Fundamentals class on Openedx
My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new...
2017-03-08
515 reads
SQL Browser, what is it good for? Absolutely something!
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-08
445 reads
Exporting Container Images
I’ve already covered how to push images to the Docker hub here but what if we only want to share...
2017-03-08
416 reads
Implementing Fuzzy Sets in SQL Server, Part 9: Measuring Nonspecificity with the Hartley Function
By Steve Bolton
…………Imagine how empowering it would be to quantify what you don’t know. Even an inaccurate measure might be...
2017-03-08
549 reads
SQL Server Continuous Deployment "In a Box"
What is this?
Well if you read the name aloud "SQL Server Continuous Deployment in a box" then, if I have...
2017-03-07
477 reads
SQL Server Continuous Deployment "In a Box"
What is this? Well if you read the name aloud “SQL Server Continuous Deployment in a box” then, if I have done my work correctly choosing the title for...
2017-03-07
15 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
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
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...
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