Browse by Tags

All Tags » Sql Server (RSS)
30 December 2010 23:13

SELECT * FROM Sql tweeters WHERE location = ‘UK’

Alright this is actually a follow up post from Gethyn Ellis post SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’ . Where he composed a list of UK bloggers so I thought id summarize a list of Sql folk that tweet, but rather than make the list static I...
Posted by blakmk | 1 comment(s)
Filed under: , ,
23 October 2010 17:54

Retrieving Historical Deadlock Graphs

When I visit a client site to troubleshoot deadlocks, it is always a cause of annoyance when I cannot go through historical deadlock events to determine the frequency and causes of these deadlocks. I either have to talk them through enabling trace flag...
Posted by blakmk
Filed under: , , ,
29 July 2010 14:00

Sql Server Consolidation and Configuration Part 1 CPU

So i only seem to get inspired when im totally immersing myself in a project. Having been busy for a while with a few projects requiring me to either consolidate or upgrade servers to 2008 and 2008 R2, I finally decided to put my resistance aside and...
Posted by blakmk | 4 comment(s)
Filed under: , , ,
01 July 2010 18:36

Consolidation, capacity planning and the art of asking questions

I was recently asked to investigate a performance issue with a Sql server that had gradually started to die. Performance was dire and connectivity had become sporadic and services were reguarly stopping and needed to be restarted. The event log was littered...
Posted by blakmk | 2 comment(s)
Filed under: , ,
30 April 2010 12:12

Optimising Database Mirroring over WAN

I recently got asked by our network guys about botlenecks in the WAN that used for mirroring to our DR I site. They asked me to turn off encryption of Database Mirroring so that the riverbed software they were using could optimise the packets sent over...
Posted by blakmk | 2 comment(s)
Filed under: , , , ,
30 April 2010 11:53

Code formatter for SSMS

I was searching recently for a code formatter for T-Sql and I came accross this nice little utility that I wanted to share: http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl I've been dealing with a lot of legacy code latley and there...
Posted by blakmk
Filed under: , ,
15 January 2010 10:12

Discoveries With Sql Server on Windows 2008 Server

Discoveries With Sql Server on Windows 2008 Server Ever since i’ve started using Windows Server 2008, I’ve been constantly amazed by how many things have changed since Server 2003. It is often a case of wasting time tracking down why things don’t work...
Posted by blakmk | 2 comment(s)
Filed under: , ,
17 December 2009 16:39

SSAS 2008: Internal error: An unexpected exception occurred

I have spent the best part of a day removing named sets from SSAS cube definition. It appears that by creating a certain date set to work out sets relative today, my existing reports using date hierarchies started throwing this error. Seems like a bug...
Posted by blakmk | 2 comment(s)
Filed under: ,
05 June 2008 12:45

AMD vs Intel

I was asked recently to spec out a new super server which will be deployed in a years time. Part of the analysis was to determine whether to use AMD or Intel Xeon Quad core chips. When I look at it, AMD have recently been winning the race on performance...
Posted by blakmk
Filed under: , ,
23 May 2008 15:05

Fragmentation and the impact on Sql Server

Whenever I’m called into a client site to review performance issues, one of the first things I always check is the filesystem fragmentation levels. Fragmentation is something that degrades performance on all databases to verying degrees. Heavily fragmented...
Posted by blakmk
Filed under: ,