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)
25,106 reads
Perry Whittle
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,683 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,344 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,434 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,435 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,462 reads
Repairing a Broken Log Shipping Plan From a Differential Backup
This article details how to reinitialise a Log Shipping scenario from a primary differential backup
2013-12-20 (first published: 2012-09-27)
3,893 reads
Moving Database Files in SQL Server
A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.
2013-02-11
8,417 reads
Combining AlwaysOn Groups With Failover Cluster Instances
This article discusses failover cluster instances and AlwaysOn groups
2012-09-04
10,952 reads
AlwaysOn Availability Groups in SQL Server 2012
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
2012-08-28
9,082 reads
Blogs
Daily Coping 10 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
T-SQL Tuesday 153: The conference that changed everything
This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call...
T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...
Forums
CASE statement with multiple conditions (trimming & detecting spaces in between)
Hello everyone, I am trying to create CASE statement that will do three different...
Retrieve username for report?
We have a "report" that executes a stored procedure to perform updates. For these...
Transactional Replication to Azure getting "too many arguments" error on MSins
I'm running a 2019 (15.0.4102.2) Server with Transactional Replication out to a SQL Azure...
Ask SSC