SQL University: Architecting SQL Server Security, the Big Picture

Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...

SQLSaturday #62–Tampa Recap

I had the privilege of attending and speaking at SQLSaturday #62 – Tampa the weekend of January 15th and this is my belated recap post of what I did...

SQLSaturday #62–Tampa Recap

I had the privilege of attending and speaking at SQLSaturday #62 – Tampa the weekend of January 15th and this is...

SSIS: Custom Folder in your Package Store

Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store.  I...

SSMS Tips and Tricks – ALTernative Highlighting

This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share...

Using PowerShell To Search The Event Log

The “30-minute DBA” was operating in a highly effective mode. He’d automated most everything that could be automated. The first...

How to get the SQL server critical errors via mail using native T-SQL Script

Advertisements 
T-SQL Tuesday #015: Automation:
 

I am very much interested to participate in the T-SQL Tuesday event party. I have seen the...

How to setup the Database mail in SQL server 2005

AdvertisementsHow to setup the DB mail using Gmail account
In this article I am going to show the database mail setup...

Five DMV Queries That Will Make You a Superhero in 2011!

Way back in January, 2008, I wrote a blog post called  “Five DMV Queries That Will Make You A Superhero!”...

January OPASS Meeting Recap

On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every Developer should know.  This was the first regular OPASS...