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

Storing the Sun's Energy - Solar Power

I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a...

MVP book is available for preorder

Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going...