Wednesday, May 16, 2012

Script to Generate Foreign Key Column Indexes

›
While quality indexing often needs human intervention, not automated tools, there are some good baseline indexes that can be added to a data...

SSIS: Access Network Resources on a Server Not on the Same Domain

›
I recently ran into a situation where my SSIS server needed access to file shares that were not on the domain but were accessible over the...
20 comments:
Friday, January 27, 2012

CLR Stored Proc with Output Value Returning NULL

›
I'm a little embarrassed to be writing a post about this but I figured there might be someone else out there making the same obvious mis...
3 comments:
Wednesday, January 11, 2012

The specified program requires a newer version of Windows - SSDT Install

›
Look familiar? Unfortunately SSDT is not supported on Windows XP. The following Windows versions are supported. Windows Vista SP2 ...
Wednesday, December 21, 2011

TFS 2010 Can't Convert Branch to Folder

›
Branches can be removed from a TFS project by converting them back to a folder. This is usually done when a branch was created by accident a...
Thursday, December 15, 2011

SQL Server 2008 R2 Master Data Services: A Review

›
I recently had the opportunity to spend a couple of days working through a proof-of-concept using Microsoft's SQL Server 2008 R2 Maste...
1 comment:

Generate Insert Statements for SQL Server

›
Many times it is necessary to script the insert of rows into a SQL Server table as part of a release, bug fix, maintenance process, etc. I h...