Monday, June 25, 2012

SQL Azure: Development Tools

›
There are number of tools available to build your SQL Azure database. In this post I will describe three of them including SSMS (SQL Server ...
Wednesday, June 20, 2012

SQL Azure: Building your first Microsoft database in the cloud

›
We’ve all been hearing about the cloud for a while and if you’re exposed to Microsoft at all that means Azure. If you’re a database person...
Tuesday, June 19, 2012

SSIS Transactions Including Oracle Data Sources

›
Microsoft SQL Server Integration Services has the out-of-the box capability to handle transactions. I won't get into the details of how...
9 comments:
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 ...