How does Query Store capture cross database queries?
When I was writing my post Capture the most expensive queries across your SQL Server using Query Store a question crossed...
2017-11-16
646 reads
Matthew McGiffen DBA
SQL Puzzle 4: The Beale Papers
I’ve not done a SQL puzzle for a while so thought it was getting overdue…
I set this one for my...
2017-11-24 (first published: 2017-11-08)
1,494 reads
Capture the most expensive queries across your SQL Server using Query Store
I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2017-11-13 (first published: 2017-11-01)
5,176 reads
Avoiding confusion with SQLCMD variables
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
10,496 reads
Implementing Temporal Tables Where You Have Existing Data
In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for...
2017-11-06 (first published: 2017-10-24)
4,815 reads
Bug with STATISTICS TIME?
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
512 reads
Avoid “Constants” in T-SQL
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2017-10-19 (first published: 2017-10-10)
3,675 reads
Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
17,635 reads
Auditing Data Access in SQL Server for GDPR Compliance
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2017-10-05 (first published: 2017-09-26)
5,809 reads
When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
701 reads
Blogs
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers