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,301 reads
Perry Whittle
2015-10-08 (first published: 2015-07-02)
1,072 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,139 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,080 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,154 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,558 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,722 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,267 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,304 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,447 reads
Blogs
Daily Coping 24 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DDL Trigger to log database level security commands.
In my last post I talked about reasons why your permissions might go missing....
Azure SQL Managed Instance Versions
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
Forums
Cannot log in to new SQL server
Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....
Single Query Instead of a Cursor
Is it possible to rewrite this routine to be a single query, instead of...
Report with 2 tables per page grouped on same data
hi all looking some advice on the best approach on designing a report in...
Ask SSC