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...

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...

Shredding a simple xml structure to a single row flat table

I was helping out a user on the forums the other day where they were asking questions about shredding an...

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...

Dell 12th Generation Server Cheat Sheet

Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use...

SQL Rally 2012 Recap and Session Files

SQL Rally 2012 Recap and Session Files
Dallas Convention Center

SQL Rally 2012 was hosted by the North Texas SQL Server User...

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...

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...

SQLRally Dallas Slides

I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. ...