Vote for Mr. LaRock

It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...

Off-Hours Work: A Guide For Managers

If you work in software development or IT long enough eventually you're going to find yourself in a situation where...

Reporting Services resources

Thanks to everyone who attended my SQL Server Reporting Services class in Nashville over the last couple of weeks. As...

SQL Server MVP Deep Dives

I’ve been reading through this book and it really does have something for everyone at any level.
I think it...

Midlands PASS Chapter October Meeting

Next Meeting - October 6, 2009

 Speaker - SQL Server MVP Brian Kelley

Trigger Happy Database Security
In this presentation we'll look at the use...

Space Sensitivity in SSIS Lookups

It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...

Temp tables and scope

create table MyTable (id int)
go
Create Table #Test (id int)
go
create proc MyProc
@id int
as
insert MyTable select @id
insert #test select...

Sales vs Operations

It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production....

Don't Tick Me Off...CPU Ticks

OK, there was something that Microsoft did to tick me off.  SQL Server 2005 introduced us to so many exciting...

Adding a folder to the SSIS Package Store

The SSIS Package Store is a nice option available for storing SSIS packages.  The Package Store lists packages stored on...