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
2,917 reads
Perry Whittle
2015-10-08 (first published: 2015-07-02)
1,067 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)
19,885 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,026 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
3,795 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,537 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,660 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,150 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,241 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,434 reads
Blogs
SQL on-demand in Azure Synapse Analytics
By James-Serra
The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics...
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took...
Fixing Broken Pip
By Steve Jones
I’ve got Python 3.8 on my machine, and recently I got a note that...
Forums
Using Begin Tran for a select statement?
Hello All I have an overly complex SELECT statement that I am married to...
Exclude square bracket and text from start or end of string
Hi, I want to remove square brackets and text from either start of string...
MCSA Certifications - SQL2016
Dear all - Firstly apologies if my post isn't specifically for this particular forum...
Ask SSC