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

Tip: Connect to dBASE files in SSIS

This has come up several times in the course of the last TWO jobs, so I’ll put it here for...

Different High Availability Solutions in SQL Server – By Abi Chapagai

Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...

Different High Availability Solutions in SQL Server

Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...

PASS Nominating Committee Interview

As my regular readers know I applied to be part of the PASS Board of Directors.  The process starts with...

Patrick and Thomas LeBlanc..did a great job Congrats!!!

Have you ever had 590 + people register for YOUR SQL Saturday.. well Patrick and Thomas did. These folks have put...

PASS Advice – Marketing Pre/Post Conference Seminars

Last week I attended the PASS Performance Virtual Chapter’s presentation by Adam Machanic on Parallelism and Performance. It looked interesting,...

Using DMV to identify members roles

Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using...