Click here to monitor SSC

2013 December


Tribal SQL Awards


This is likely to be my last blog for 2013 and it is one that is going to give you something to do. Yep, you actually HAVE to click a link and do some thinking. Don’t Panic though, it will take maybe 1 minute and a load of people that have given waaaay more than […]

23 December 2013 8:23 am by
Bart Read

New Features in Node Tools for Visual Studio’s December Dev Build


Download the latest Node Tools for Visual Studio dev build from: It’s only been a month since the first alpha, but a lot has happened since with fixes and improvements to intellisense, various areas of the user interface, solution explorer, build, the REPL, along with the npm support that Red Gate has been working […]

20 December 2013 3:09 pm by
Ben Emmett

Killing memory usage with dynamically generated assemblies


There’s a nasty memory leak which the .NET Framework can suffer from when using certain classes. Let’s say you instantiate a new XmlSerializer(Type). Behind the scenes, the framework will dynamically generate an assembly to serialize or deserialize this Type. The Framework does some cleverness which means this assembly will be reused next time you instantiate […]

20 December 2013 11:28 am by
Melanie Townsend

Recognizing Community Leaders – Tribal Awards Finalists

1 comment

The time has come, voting is now open for the Tribal Awards finalists. Let’s recognize the people who go over and above for the technical community in the following 11 categories. Article that saved my bacon in 2013 Break large delete operations into chunks by Aaron Bertrand: Transaction Log VLFs – too many or […]

19 December 2013 7:27 pm by
Phil Factor

IT Aphorisms


An aphorism is a concise or laconic statement that expresses an element of truth, and maybe a sting in the tail. such as ‘I’m an atheist, thank God’, or ‘The bearing of a child takes nine months, no matter how many women are assigned.’ An aphorism that is too often repeated becomes a cliché. The […]

19 December 2013 9:58 am by
Nigel Rivett

Split csv entries from a column in a table


This is all in a single query without having to create a function. The separator is in a cte so doesn’t need to be declared separately. For longer separators include the length in this cte and use it for the length adjustments in the query. create table #a (rowid int, csvstring varchar(100)) insert #a select […]

13 December 2013 12:26 pm by

I Thought Everyone Did It Like That – SSMS Templates

1 comment

One of an occasional series of blogs about things that I do that perhaps others don’t. SSMS – the default TSQL code editor that comes with SQL Server has many faults and my Twitter stream is often the scene of DBAs and developers venting their frustrations at it’s foibles but it does have some quite […]

12 December 2013 7:00 am by
Melanie Townsend

State of the Tribal Awards


The Tribal Awards are underway! I wanted to give everyone a quick update on the progress of the awards and some of the nominations we’ve received. If you haven’t done so already, get your choices in at Article that saved my bacon in 2013 Nominations are thin on the ground for this one! We’re […]

11 December 2013 2:40 pm by
Louis Davidson

What Counts for a DBA: Deduction

1 comment

“You see, Watson,” he explained in the early hours of the morning as we sat over a cup of tea in Baker Street, “it was perfectly obvious from the first that the explanation for this query’s sudden poor performance was elementary”. “But how could you guess what the cause was?“ “Firstly, we see that the […]

11 December 2013 4:53 am by

If you could give an aspiring DBA just one piece of advice what would it be?


This post is part of a collection of content masterminded by John Sansom, please see the reference section at the end for the details of how to get all the other thoughts and contributions   Prioritise, and Socialise. I have been working in an IT department for almost 15 years now and even before that […]

10 December 2013 9:00 am by
Older posts

Blog archive