Stairway to Always On Level 7: Combining FCIs with Availability Groups
In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.
2024-07-23 (first published: 2015-07-01)
7,202 reads
Perry Whittle
Stairway to Always On Level 8: Segregate Mirror Traffic in AlwaysOn
this article details how to segregate the mirror traffic in an Always On group configuration
2024-07-23 (first published: 2016-03-09)
5,540 reads
Truncate tables where Referential Integrity exists
This script can be useful in test and dev environments to quickly clear tables via the truncate command where referential integrity exists.
2024-05-15 (first published: 2024-05-02)
627 reads
2018-10-12 (first published: 2018-10-04)
1,118 reads
How to execute a Powershell script via SSIS
Learn how you can execute a PowerShell script via the SSIS execute process task.
2018-04-06 (first published: 2015-12-03)
29,892 reads
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
4,762 reads
2015-10-08 (first published: 2015-07-02)
1,092 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,845 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
5,003 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,631 reads
Blogs
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Forums
The Pervasive Nature of Open Source
Comments posted to this topic are about the item The Pervasive Nature of Open...
Migrating from SSRS 2008 (SP Integrated) to 2022 (Native)
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers