SQL Puzzle 5: Prime Magic
Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...
2018-01-05 (first published: 2017-12-19)
1,684 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
Understanding Keys and Certificates with Transparent Data Encryption (TDE)
I’ve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that I’ve...
2017-12-28 (first published: 2017-12-12)
3,272 reads
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...
2017-12-14 (first published: 2017-12-05)
4,262 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...
2017-11-24 (first published: 2017-11-08)
1,512 reads
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
656 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,274 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,903 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,643 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,688 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
527 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers