Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read...

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...

Decks & Demos Live

Hello Dear Reader!  Just a quick update.  I've been traveling a lot and I'm behind in posting some Decks & Demos....

ERROR OPENING SSRS REPORT MANAGER IN INTERNET EXPLORER

Writing this post only for internet explorer as not aware of the settings of other browsers such as chrome/mozilla.

To be...

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas...

Speaking at Connections

I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:
Continuous Integration for DatabasesMaintaining High Performance When...

SQL #53 – Keyboard shortcut Alt + F1 works now in SSMS 2012

Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...

Webinar – Easy SQL Server Benchmarking

On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”.
Abstract: Do you have a new piece of...

Back to Work

After surgery Fri am, I’ve been mostly taking it easy, but now it’s back to work. Got kids to school...

Building the SQLSaturday Orlando Marketing Plan–Part 2

Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....