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

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

This is an answer to a forum question on www.bidn.com
Running SSIS on a 64-bit machine has several caveat that developers...

Orlando Tiki Hut Roadshow Silverlight Edition

Assuming no major problems at work, I’m heading to the South side of town the afternoon of Dec 14, 2009...

Reporting Services Carriage Return

Often when designing a report you may find a need to concatenate values in an expression.  For example, you want...