A SQL Experiment – Mentoring

News Flash The SQL Community is about to get stronger.  Why?  There is a great new initiative that was recently launched.  Steve Jones and Andy Warren are teaming up...

A SQL Server Hardware Nugget A Day – Day 26

For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a...

Daily Denali Delight – Day 4

Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...

MS Certs Exam price is rising ...

Today Marlon Ribunal twittes come with new info about MS Certifications exams are rising...

This is not a good news, so...

Powershell Day 26

Day 26 Generate script Generate script for sql server objects is very simple, there are different ways we can generate...

Replication Monitor – Friendly Names

You may have noticed when you setup a merge pull subscription using the
New Subscription Wizard in SSMS that you...

Search Stored Procedure Text

There will come a day, if it has not already come and gone, when you will want to search through...

SQL Azure Diagnostic Tool

One of the CSS Engineers from Microsoft has released a diagnostic tool for SQL Azure. It’s worth a look. It’s...

SQL University: Who has access to my SQL Server?

Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...

Transforming SSIS' sysssislog Entries Into Something More Readable

The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion.  It isn't perfect...