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,038 reads
Learn how you can execute a PowerShell script via the SSIS execute process task.
2018-04-06 (first published: 2015-12-03)
29,038 reads
This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.
2015-12-09
4,510 reads
This article details how to create a corrupt SQL Server database for testing purposes
2014-08-08 (first published: 2012-05-04)
20,727 reads
This article details encrypted backups and how they are implemented in SQL Server 2014.
2014-05-15
4,882 reads
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,595 reads
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
2013-12-23 (first published: 2011-01-19)
18,498 reads
This article details how to reinitialise a Log Shipping scenario from a primary differential backup
2013-12-20 (first published: 2012-09-27)
3,977 reads
A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.
2013-02-11
8,515 reads
This article discusses failover cluster instances and AlwaysOn groups
2012-09-04
11,872 reads
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
2012-08-28
9,672 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers