Using CROSS APPLY instead of a calculated variable

Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...

View computed columns in database

Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...

We’re speaking at PASS Summit 2013!

PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back...

Wildcards and Indexes

I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...

Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations

A little more than a year ago while working at Idera, I was consulted on reports from a few clients...

Consulting company: Perm/Salaried vs 1099/W2

One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company...

CREATE SCHEMA can do what?!?!?

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...

Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller

Development and demo environments can be hard to come by. Over the course of this series you will learn how...

Digby’s Top 10 reasons you need a DBA

Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.

They can handle unexpected database growth...

Get synonym definitions for all databases in server

If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...