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)
31,158 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
5,063 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,978 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,111 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,677 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,555 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)
4,028 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,666 reads
Combining AlwaysOn Groups With Failover Cluster Instances
This article discusses failover cluster instances and AlwaysOn groups
2012-09-04
12,395 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,937 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers