Using a Surrogate vs Natural Key
A common debate in table architecture is whether to use a natural or surrogate key. In this article, I discuss some of the advantages to each method.
2019-10-15
12,700 reads
Search results for "tde"
Your search for "tde" returned 100 results:
2021-05-26 (first published: 2021-04-30)
8,665 reads
In-Memory OLTP Table Checkpoint Processes Performance Comparison
The article demonstrates one of the major performance enhancements in checkpoint processes in "in memory tables"
2018-10-05 (first published: 2015-10-27)
3,913 reads
Running SQL Server Databases in the Amazon Cloud (Part 1 ...
Jun 16, 2014 ... ... (TDE). Despite any performance penalty for implementing TDE, this could be one requirement from your management team if you roll out a SQL ...
Using authenticators with SQL Server encryption - MSSQLTips.com
May 27, 2009 ... SQL Server TDE Initial Scan Suspend and Resume Options. September 7, 2022. Subscribe. Email(Required). Consent(Required). I agree by submitting ...
How to Kill a Company in One Step or Save it in Three - Simple Talk
Feb 7, 2012 ... We have automated backup mechanisms, clustered servers, and mirroring in place, but beware, if you get lazy about TDE maintenance, it might just ...
Database Properties Health Check - Simple Talk
Sep 13, 2011 ... ... (TDE) or not. If the Encryption Enabled property is set to False (off), then TDE is not enabled. If the property is set to True (on), the TDE ...
Getting a List of the Striped Backup Files
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
2,501 reads
Using Azure Resource Manager Templates To Provision Azure SQL ...
Feb 21, 2019 ... ... (TDE), or long-term retention. To identify the corresponding Azure Resource Manager resource types, refer to the aforementioned Microsoft.Sql ...
Encrypting SQL Server: Using an Encryption Hierarchy to Protect ...
Dec 13, 2016 ... In the articles to follow, I'll cover such features as Transparent Data Encryption (TDE), Always Encrypted, and Dynamic Data Masking. With ...
Blogs
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025
I’m excited to announce that on June 17 – 18, 2025, I’ll be running...
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
By Tim Radney
I have recently had the privilege of working with multiple clients who have been...
Forums
Third party backup softwares
Hi Team, Can you someone suggest a few good third part backup tools, with...
2022 SSIS PackageFormatVersion?
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
Meta AI by Facebook: A New Contender in the AI Battle
Comments posted to this topic are about the item Meta AI by Facebook: A...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers