(David Browne) I’d like to demonstrate a technique for storing compressed rowsets in SQL Server using CLR integration.

(SQLDenis) SQL Server 2012 has added WITH RESULT SETS to the EXCECUTE command. You can now override the data types and names that the resultset is returning.

(Dallas Snider) In my 18-plus years of T-SQL experience, the MERGE statement has got to be one of the most difficult statements I have had to implement. It is powerful and multifunctional, yet it can be hard to master.

(Rohatash Kumar) In this article, I would like to show how to create a SQL Server Backup file in C#. You can create a SQL Server database backup using SQL Server Management Studio and you can also use a Transact-SQL statement. We use a backup database and restore the database when our database becom

(Thomas Kejser, Lindsey Allen, Arvind Rao and Michael Thomassy) Recently, we performed a lab test that had a large OLTP workload in the Microsoft Enterprise Engineering Center. The purpose of this lab was to take an intensive Microsoft SQL Server workload and see what happened when we scaled it up f

(Marcin Policht) As we have demonstrated in the recent article published on this forum, you have the option of leveraging the capabilities and flexibility of PowerShell when automating management of SQL Server 2012 Integration Services.

In the current economy, many companies are investing in interns. This is a cost-effective way to temporarily solve their resource needs as well as get in an early bid on the upcoming talent. But what type of tasks and preparation is needed?

(Arshad Ali) An FTP (File Transfer Protocol) server is often used for data exchanges in many data integration scenarios. SSIS includes an FTP task to download and upload data files to and from an FTP location, but how does this work and how can we configure it for data file downloads and uploads?

(Kenneth Fisher) Templates are one of those really handy tools that most DBAs I know of have either never heard of or just don’t use much. I have to admit I fall into the second category myself.

(Vishal Gajjar) When you create a new database in SQL Server without explicitly specifying database file locations, SQL Server created files in default location. This default location is configured when installing SQL Server.