Writing Better Queries Presentation Materials

I delivered a webcast for the PASS DBA Virtual Chapter yesterday. It was called Tips & Tricks for Writing Better Queries....

“Apparently, you signed a software services agreement without fully understanding it.”

I am not a lawyer. Let me say that again, I am not a lawyer.

Todays Dilbert has prompted me...

Visualize Tech Skills

Is your area of responsibility starved for resources? Is it difficult to get a raise? If so, don't despair. You're...

Configuring Antivirus for SQL Servers

I've been on both sides of the debate with respect to whether or not to install antivirus software on a...

SQLskills Immersion Event on Internals and Performance – Day 3

Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...

How Can I Help You Go To SQLRally?

I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...

Emailing tempdb Query Results to Paul Randal with PowerShell

I was referred to someone on twitter today who wants to email query results without setting up database mail.  I explained this in Post 6 of PowerShell Week at...

Emailing tempdb Query Results to Paul Randal with PowerShell

I was referred to someone on twitter today who wants to email query results without setting up database mail.  I...

Fundamentals of Storage Systems, IO Latency and SQL Server

A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...

You Can’t Disable the CLR in SQL Server – MCM Prep

At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even...