Installing SQL Server 2012 RC0 from an iPhone

Short version – Installed SQL Server 2012 RC0 onto a Server 2008 SP2 VM using an RDP connection from my iPhone...

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...

Data Loading Performance Guide

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

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. ...

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...

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...

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...

ALTER INDEX permissions

Developers like to have some control over the development process. An example is index building.  Asking aDBA repeatedly for changes ...