SQL Server Blogs

Voices from the UK SQL Server Community

Search

Page 1 of 3 (25 items) 1 2 3 Next >
  • Calculating estimated data loss with Always on

    Ever wondered how calculate estimated data loss (time) for always on. The metric in the always on dashboard shows the metric quite nicely but there does seem to be a lack of documentation about where the metrics ---come from. Heres a script that calculates the data loss ( lag ) so you can set up alerts based on your DR ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Tue, Dec 18 2012
  • 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 will just point you towards the list which I will keep up to ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Thu, Dec 30 2010
  • Connecting to named Instances Using Port Number

    I came across an interesting situation where a developer was trying to connect to a named instance using a DNS alias without specifying the instance name. Coincidently though he remembered to include the port number and miraculously it worked. So it appears that sql server accepts connections to a specific instance based on its port number. While ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Thu, Dec 16 2010
  • Transferring aliases from Sql Server Configuration manager between machines

    Ever since I have been working with Named Sql Instances using static ports, it has been a pain.  Connection strings need to be recoded to include the port syntax: <ServerName>[\InstanceName],<Port> <IP Address>[\InstanceName],<Port> This can be a bit of a drag when you have multiple config ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Thu, Nov 4 2010
  • T-SQL Tuesday #12 – Why are DBA skills necessary?

    I  was recently invited to a client site where I hadn't been in a couple of months. I could smell the neglect as soon as I examined the server: Error logs ripe with deadlock events Horrific sql in stored procedures Agent jobs failing Database ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Mon, Nov 1 2010
  • Memory Impact of file copy on Windows Server 2008

    While figuring out a consolidation strategy for Sql Server, I was concearned that the memory issues (http://blog.mischel.com/2008/10/14/copying-large-files-on-windows/)  affecting large file copies would also effect Sql server backups to a cifs location. The reason I wanted to do this was to consolidate the existing backup server ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Tue, Oct 26 2010
  • 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 1222 or explain to them how to enable profiler to capture specific deadlock graphs. ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Sat, Oct 23 2010
  • Sql Server Consolidation and Configuration Part 2 Network

    An often neglected part of Consolidation is the network configuration of a server. If you have mirroring set up this is particuarly important because the network throughput can be in the same magnitude of the transaction log throughput. Generally if I am limited to four NIC's available I will team two and make them available for ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Thu, Aug 26 2010
  • To Hyperthread or Not To Hyperthread

    Following on from my comments about CPU configuration I have decided to restate my position to "it depends....".  Having performed some investigation in the Sql community, Glenn Berry ( Twitter | Blog )  suggested that Hyper Threading should be enabled for the new Xeon 55xx, 56xx, 65xx, and ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Wed, Aug 4 2010
  • 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 Blog. This particular blog will be devoted to CPU configuration. CPU affinity One of ...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Thu, Jul 29 2010
Page 1 of 3 (25 items) 1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems