SMKs, DMKs, Certificates for TDE and Encrypted Backups
This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.
2015-12-09
3,482 reads
Perry Whittle
2015-10-08 (first published: 2015-07-02)
1,074 reads
How to Create a Corrupt SQL Server Database
This article details how to create a corrupt SQL Server database for testing purposes
2014-08-08 (first published: 2012-05-04)
20,247 reads
SQL Server 2012 AlwaysOn Groups and FCIs Part 4
This is Part 4 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.
2014-05-20
4,105 reads
Using Encrypted Backups in SQL Server 2014
This article details encrypted backups and how they are implemented in SQL Server 2014.
2014-05-15
4,300 reads
SQL Server 2012 AlwaysOn Groups and FCIs Part 3
Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.
2014-04-03
3,585 reads
SQL Server 2012 AlwaysOn Groups and FCIs Part 2
This is Part 2 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.
2014-03-06
4,747 reads
SQL Server 2012 AlwaysOn Groups and FCIs Part 1
Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an AlwaysOn availability group.
2014-02-10
8,336 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
2013-12-24 (first published: 2011-07-12)
9,374 reads
Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
2013-12-23 (first published: 2011-01-19)
18,454 reads
Blogs
Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)
By Jen McCown
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...
CosmosDB and Consistency
By Steve Jones
I was doing a little work with CosmosDB recently, and there were a few...
Daily Coping 17 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to reclaim space from a table
Hi All I have 1 TB database and i cant shrink it as it...
Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine
Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...
Ask SSC