MS Days 2011 in Albania, Tirana

I would like to write about the tech events in my country and our brother-neighbor Albania, that everyday we are...

Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug

Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator. ...

Data Loading Performance Guide

Bulk loading with large amounts of data  requires strategy.  The Data Loading Performance Guide for SQL Server 2008 and SQL...

Adelaide SQL Server User Group Slides and Scripts

You can find the slides and scripts from Monday’s Extended Events session for the Adelaide SQL Server User Group in the...

Re-blog – November 18 – November 24

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer...

Destroying a Windows Cluster

I haven’t posted for a while but thought I’d dust off the blog and get a post out. I have...

SQL Server 2012 licensing details

AdvertisementsMicrosoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx.
 

1.      What is new in SQL...

MS DTC and sys.dm_tran_active_transactions

A  sql reindex command was being blocked by two active transactions in MS DTC.   Use
sys.dm_tran_active_transactions to report more detail on...

Speaking at Spring 2012 SQL Server Connections in Las Vegas

I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas,...

Running a TPC-C workload on SQL Server

I have a lot of customers with some impressive SQL Server workloads, those databases
are several hundred GB large, with several...