Overview of Encryption Tools in SQL Server
More and more people are considering some level of encryption against their data stored in SQL Server. In many cases...
2019-04-26 (first published: 2017-12-05)
4,130 reads
Matthew McGiffen DBA
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
589 reads
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...
2019-04-26 (first published: 2017-11-08)
1,417 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...
2019-04-26 (first published: 2017-11-01)
3,978 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
5,817 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...
2019-04-26 (first published: 2017-10-24)
4,262 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
495 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...
2019-04-26 (first published: 2017-10-10)
3,648 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
7,854 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...
2019-04-26 (first published: 2017-09-26)
5,519 reads
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Significance of Historical waits report in SQL server Performance dashboard
I have the following historical wait report for my SQL server. I have noticed...
Has SQL Server Performance Improved?
Comments posted to this topic are about the item Has SQL Server Performance Improved?
Is TemporalTable SysStartTime available before performing an insert/Update?
I want to align a Date column (datetime2(7)) with the same full resolution date...
Ask SSC