2016-04-05
9 reads
2016-04-05
11 reads
2016-04-05
11 reads
SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...
2016-04-05
11 reads
SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...
2016-04-05
505 reads
Power BI Embedded is here
The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...
2016-04-05
576 reads
Scaling Azure VM’s
There are so many benefits to the cloud, but one of the major features is the ease of use in...
2016-04-05
668 reads
MongoDB -Calculating Collection Size
Calculating Collection Size
We can get the size of a collections by using the shell’s functions
db.collection.dataSize(): Returns data size in bytes...
2016-04-05
678 reads
Views and Simplification
I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...
2016-04-05
560 reads
SQL Server Service Broker – Conversation Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-04-05
685 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