Microsoft releases SQL Server 2014 CTP2

Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...

PowerShell – Disk Space GUI Tool

PowerShell – Disk Space GUI Tool - Sharing a useful PowerShell GUI script to check disk drive usage along with a graph.
Copy and...

SQL #51 – Timeout when updating a big table

A co-worker recently asked me why she would get timeout when updating a column in a big table. This column...

SQL #52 – set statistics xml on

When tuning SQL queries, I find that I use the following three SET options quite often. 

set showplan_xml on
When showplan_xml...

SQL Query Formatting – Putting Lipstick On A Pig

“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...

SQL Server Inetrview FAQ 3

1.       How to find the maximum no of connection allowed in SQL Server?
 Select@@MAX_Connections
2.       How to select top 2 rows without...

A Rickety Stairway to SQL Server Data Mining, Part 14.4: Node Navigation

By Steve Bolton
…………The pinnacle of difficulty in this series of amateur self-tutorials on SQL Server Data Mining (SSDM) was surmounted...

Get list of dates using recursive Common Table Expression (CTE)

Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...

Memory Optimization Advisor – SQL Server 2014 CTP2

SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal...

PASS Summit 2014-Networking Dinner & After Hours

Yes, it is early, but I’ve set up the invitation for the fifth annual Monday Night Networking Dinner at the...