Audit SQL Logins

Written by David Postlethwaite There are several ways that you can audit who has logged in to your SQL Server. The...

PowerPivot – Perspectives

PowerPivot – Perspectives
Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split...

Celebrating Mistakes-Part 2

I’ve been thinking about this a lot. It’s easy to say we want to take risks, much harder to set...

Two New TPC-E Submissions

Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three...

The Best Part of My New Job

The Best Part of My New Job
Come to the Dark Side, We have Nutter Butters

If you had told me a...

Celebrating Mistakes-Part 1

Most of us learn more from mistakes than successes. We talk about taking risks, but what is the average response...

MSSQLTips.com Kindle Contest

I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...

My SQLbits sessions

Since today its official, I'm presenting 2 sessions at the SQLbits conference in Liverpool
(http://www.sqlbits.com) from September 30 –
October 1. Here...

SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it

SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...

Presenting Hardware 301 at 24 Hours of PASS on September 7

PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version....