Simple Tips To Speed Up Your SSIS Data Flow

There are a few design choices that can make your SSIS packages run super fast when loading data from table...

Speaking In April #SQLSat111 and #SQLSat107

All Quite on the Western Front
It is going to get noisy soon though! I”m speaking at SQLSaturday #111 in Atlanta...

PASS DBA Virtual Chapter: Replication with Hilary Cotter

I’m pleased to announce that this Wednesday April 11th 2012 Hilary Cotter will be presenting for the PASS DBA Virtual...

SQLCLR: Good? Or Evil? #MemeMonday

Is SQLCLR good or evil?  Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...

SQL Database roles and members

Q. How can I obtain the members of a role within a database?
A.  One method is to use sp_helprolemember
 
EXEC mydatabase.dbo.sp_helprolemember

--returns...

Why I can not connect sql server ???

       Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...

April #Meme15 Assignment

Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...

SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task

There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...

Enabling Contained Databases in SQL Server 2012

One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...

Onward and Upward!

As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...