2018-05-29
8,479 reads
2018-05-29
8,479 reads
Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance overhead of 2-4%. That doesn’t sound like very...
2018-05-23
1,193 reads
After blogging about SQL Server for just over a year, at some in the last month I went over 100,000...
2018-05-16
461 reads
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
I’d...
2018-04-10
1,135 reads
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
The...
2018-04-10
328 reads
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,128 reads
In the centenary edition of the monthly blogging party that is T-SQL Tuesday, Adam Machanic asks us to look forward...
2018-03-13
312 reads
If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.
We...
2018-02-21
2,938 reads
When encrypting a database with Transparent Data Encryption(TDE), a vital consideration is to make sure we are prepared for the...
2018-02-14
504 reads
As mentioned previously, the process of setting up TDE (Setting up Transparent Data Encryption (TDE)) is the same whether you’ve...
2018-01-26
1,148 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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; GOSee possible answers