Alabama Code Camp 8 on Jan 23, 2010

My friend Ryan Duclos just sent me a reminder about the upcoming Alabama Code Camp on January 23, 2010, in...

Tips on SQL Server Fixed Roles

Both of my tips are up on MSSQLTips.com on fixed roles. You can find them here:
 
Understanding SQL Server Fixed Database...

Where Should I Go From Here?

I’m closing in on vacation – finally – and one of the things I’ll have in the back of my head while...

oPASS Meeting Notes for December 2009

We started off our end of year meeting with our standard networking meet and greet. It’s going smoother, people are...

Energy Update - Wind Power Picking Up

It must be picking up again, despite the lack of a sharp rise in energy prices, I am seeing more...

Locking Scripts

Thanks to everyone who attended my TechNet Thrive! and Nashville SQL Server User Group presentations this week! I hope it...

Some SQL Server 2005/2008 Monitoring Stored Procedures

Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL...

SQL Lunch # 5 – Looping Logic in SSIS

SQL Lunch # 5 – Looping Logic in SSIS

Speaker:Tim Mitchell

Topic:Looping Logic in SSIS

Meeting URL:JOIN MEETING

ADD TO OUTLOOK CALENDAR

Description:
Software developers have long taken...

Using a SSRS Report to run SQL Agent Jobs part 2

In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by...

Running SSIS 32-bit drivers or tasks on a 64 bit machine

Running SSIS on a 64-bit machine has several caveat that developers need to be aware of.  Tasks like the ActiveX...