New Blog

There areso many DBA in HK but I cannot find any good SQL server related blog or forum, so target...

SQL Rally Wrap Up

Another SQL Rally has wrapped up in Dallas, TX and it was great event.  My favorite part about these larger...

One Way To Insert Many Rows Very Fast From Your .NET Application

This is my attempt to explain something that I have wanted to figure out for a long time.  I have...

SQLRally 2012–Thursday

Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...

Tech Days 2012 in Kosovo

Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...

SQL Saturday #119 – One week to go

One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...

Denali — Day 11: SSMS enhancement

Denali — Day 11: SSMS enhancement

SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...

RedGate SQLSearch & SQL Treeo friendship

Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...

Command line to configure windows firewall for SQL server access

I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...

The Difference Between Change Tracking and Change Data Capture

Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems...