SQL Server 2008 SP1 Too Old for Replication?

SQL Server 2008 SP1 To Old for Replication?
We are in the middle of a platform upgrade project at work, and...

SCSUG PowerShell ETL Presentation

My thanks to everyone at the Space Coast SQL Server User Group for inviting me to speak. Feel free to post questions...

The Value of Blogging – Today on SQLServerCentral

I wrote the value of blogging hoping to highlight the less often discussed value of practicing writing. Too often we...

Transferring Logins to a Database Mirror

Transferring Logins to a Database Mirror
I recently discovered that my book (Pro SQL Server 2008 Mirroring) has an older version...

Tip: Change Multiple Field Formats in SSRS

One of the things about SSRS that irritates me is that in the graphical editor, you have to set the...

Reducing My Email Workload

I get a fair amount of email in a week; stuff about work, stuff for oPASS, stuff for PASS, stuff...

Travel Day - SQL Saturday #28 Baton Rouge

On my way to New Orleans today where I’ll pick up a car and then drive to Baton Rouge for...

Restart SQL Server Default Trace

One of my test servers, due to the unexpected growth of a user db, the local drive is used up,...

TSQL Tuesday 009 Roundup

T-SQL Tuesday #009: Beach Time

I hope you enjoyed your time in the sun with your toes in the sand.  We...

SQL Server Reporting Services (CRM usage, et al.): Role Assignments and Permissions

 
While supporting Microsoft Dynamics for CRM, I was recently quite surprised to have to associate role membership permissions within Reporting...