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...

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...

Setting the Standard with Personal Appearance

Cross-posted from the Goal Keeping DBA blog:
Personal appearance matters. We all know this. Yet a lot of times we don’t...

Importing and Exporting SSIS Packages Using PowerShell

SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...

Is the new 4k sector hard drives a blessing or is it going to be the next best thing after Internet?

I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...