Collective Intelligence

Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.

SubQuery Performance

Why would you do this?
select distinct(hostname),
(select count(*) as criticalCnt
from @temp where severity_guid='0168A833-1732-411E-8205-C2F6CD91737D'
and hostname=t.hostname
group by hostname),
(select count(*) as criticalCnt...

The Wiffle-Waffle, or Why I’m Running for the PASS Board of Directors

I’ll announce it here first, along with some reasons why I’m waffling from an earlier post:
I’m going to run...

SQL Audit

Scanning Without Wires - Epson Workforce 610

We are trying to buy another property here at the ranch. My wife had to leave town in the middle...

SQL Saturday Advice - Build a Foundation

I think this is a good idea, and I’ll give you some reasons, but every SQL Saturday ought to consider...

Core DBA Skill – Backing up the tail log

I’ve never had to do this in production, and I’ve only practiced it a few times, but I think this...

Video Test

One of the things I've been wanting for awhile is the ability to embed videos here on the blogs. It's...

The Private Cloud

Cloud computing is becoming more and more prevalent in technology. However most people think of a public cloud on the Internet. Steve Jones says a private cloud might be a better idea for many companies.

T-SQL Tuesday #008 - Learning

It’s time for another T-SQL Tuesday, the brainchild of Adam Machanic (Blog|@AdamMachanic) of SQLBlog.com. This time we have a SQLServerCentral...