Quick tip: sp_configure and sys.configurations

In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...

Suggestion: “USE” keyword with Linked Servers

Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic.

For...

Upgrading Packages to SSIS 2012

Many of you may now or in the future have the need to upgrade your SSIS packages to the new...

Ad hoc query optimization in SQL Server

When ad hoc queries are executed in sql server, if it is executed without parameters, and it is simple,  SQL...

Another Way To Insert Many Rows Very Fast From Your .NET Application

There was a great deal of feedback to my previous post One Way To Insert Many Rows Very Fast From...

Backup compression using IBM TDP for SQL Server

If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in...

Denali – Day 15: Support for Windows Server Core

Denali – Day 15: Support for Windows Server Core

Windows Server Core: Microsoft Server has so many features which is not required...

One Way To Insert Many Rows Very Fast From Your .NET Application

This is my attempt to explain something that I have wanted to figure out for a long time.  I have...

Session Files from SQL Saturday #107 Houston

Session Files from SQL Saturday #107 Houston
Houston Skyline

SQL Saturday Houston was a great event hosted by the Houston Area SQL...

Setting up transactional replication using T-SQL

Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....