sys.sql_modules vs. INFORMATION_SCHEMA.Routines

Consider the following two queries meant to search for a keyword in SQL programmability objects.
select s.name +'.' + o.name, o.type_desc, m.definition

from sys.sql_modules...

Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008

Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:
1. Microsoft Certified Solutions Associate...

Visualize Wait stats with Microsoft Excel

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...

SQL Server 2012: Certification Upgrade Info

As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server...

Custom TDS Endpoints: Listening on multiple ports

Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...

SQL Injection Tools

I wouldn’t recommend you use any of the tools in this article for attacking anyone, but they could help you...

Professional Productivity Books

Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...

PASS Data Arch VC presents Mike Fal: Eating the Elephant: SQL Server Table Partitioning

Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...

Listing SQL Instances on a machine (or list of machines)

TweetG’day,
Recently I was updating some of my Powershell scripts for managing SQL SERVER instances.
Generally, when writing a Powershell script to...

Backup Database Object

I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...