TDE and backup compression – still not working?
Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.
In 2016 Microsoft changed this, but...
2019-04-26 (first published: 2018-02-16)
2,386 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
There’s Still a Place for SQL Server Profiler
Follow a few of the SQL Family on Twitter and you’ll mostly see one view regards SQL Profiler, and it’s...
2019-04-26 (first published: 2018-07-25)
2,250 reads
Think twice before using table variables
T-SQL Tuesday
For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way:
http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/
My...
2019-04-26 (first published: 2017-07-11)
7,669 reads
T-SQL Tuesday 107 – Viral Demo
For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by...
2019-04-26 (first published: 2018-10-09)
1,861 reads
Understanding Keys and Certificates with Always Encrypted
Always Encrypted on SQL 2016 is pretty easy to set up. There’s even a single wizard to guide you through...
2019-04-26 (first published: 2017-05-30)
7,743 reads
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...
2019-04-26 (first published: 2017-12-12)
2,387 reads
Using the built-in System Health session
When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...
2019-04-26 (first published: 2018-08-01)
4,762 reads
Using the Sequence Object to Generate Reference Numbers
The SEQUENCE object was added to T-SQL in SQL Server 2012. It’s reasonably well known to DBAs, but less so...
2019-04-26 (first published: 2019-02-20)
3,068 reads
What is Transparent Data Encryption?
Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to...
2019-04-26 (first published: 2018-01-26)
2,142 reads
Attending a climate protest for the first time
This is a blog devoted to databases, but for once I’m going to go off topic and talk about something I did at the weekend that I’ve never done...
2019-04-25
12 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers