Endpoints Need Privileges Too

Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...

Survival Mode & Dodging Burn Out

One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience...

No Shrink-y Tempdb

I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal),...

SSRS Error: Unable to connect to remote server error

One fine day when I tried to connect to one of my staging report server I got the
“Unable to connect...

Random Ordering of Results using NEWID

A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I...

SSRS 2008 R2: How to dynamically size your INDICATORS

The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS...

Recovery Model for Every Database

One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...

devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19

This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011....

New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO

New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO

A colleague I work with on the PQO* Operations SQL V-Team, Jonathan...

Nominations are Open for the Fourth Annual Exceptional DBA Awards

SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the fourth annual Exceptional DBA Awards are...