SQLSaturday #158 Event Update & Hotels - Where are you staying?

 Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...

SQL SERVER : SQL Server Scheduler

While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....

SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...

Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax

After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...

Many speaking engagements!

I have several speaking events coming up, and I would love to see you there!

First of all, I'll be...

Microsoft PivotViewer

Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....

SQL Hide ‘n Seek

When was the last time you had to find something within your database?  Did it feel more like a child’s game or an arduous task? What would you say...

SQL Hide ‘n Seek

When was the last time you had to find something within your database?  Did it feel more like a child’s...

Columbia Enterprise Developers Guild meeting tonight

If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...

Quick tip: configure SQL Server authentication mode using T-SQL

SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands...