Winding Down

I'm trying to finish up the last few things here at work before taking the weekend off. I scheduled off...

Impact of uninstall instance on replication.

Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...

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