Jack Corbett Now Co-President of oPASS

I’m late announcing this here, but I’m pleased to announce my friend Jack Corbett is joining me in leading oPASS...

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

More on the MVP SQL Server book

If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout....

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

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

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

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

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

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