Phil Factor Getting normally-distributed random numbers in TSQL When you are creating test data, you will, at some stage, hit the problem of simulating a distribution. There are... 07 February 2014 3 min read
Jonathan Allen Learning by doing (or not) I have spent a lot of today repeating steps that I followed months ago and it is hopefully through writing... 06 February 2014 2 min read
Phil Factor Converting Roman Numerals: More TSQL Program Chrestomathy. As part of my series on TSQL Program Chrestomathy, this is a couple of TSQL routines that convert between integers... 03 February 2014 4 min read
Phil Factor The Joy of Program Chrestomathy After days spent wrestling with an intractable mess of code, with the winter rain beating on the windows, I sometimes... 31 January 2014 5 min read
Jonathan Allen Quick Tip: Windows directory file list In a previous version of Windows (circa Windows95 or older) there was a button in the toolbar of it’s equivalent... 30 January 2014 2 min read
Damon Armstrong Finding the IP Address of a Specific Network Adapter in Windows (and a rant about Hyper-V) We just recently made the switch from VMWare over to Hyper-V and I have found two things a bit surprising:... 29 January 2014 2 min read
Andrew Hunter The Synchronisation Trap The original generation of PDAs, the ancestors of today’s mobile devices, were notably limited in their connectivity. They relied on... 23 January 2014 7 min read
Tony Davis Should IT Managers Code? In one of his first ever Simple-talk articles, Phil Factor tells the story of a freelance Sybase programmer who created... 17 January 2014 3 min read
Jonathan Allen Backup to the right location, by default. How do you configure where your database backups are created? Do you have problems updating all of your backup jobs... 13 January 2014 8 min read
Simple Talk Editorial Team Victors of the Tribal Awards Throughout December, Simple-Talk and SQL Server Central hosted the Tribal Awards. With these awards, we let the technical community choose... 06 January 2014 2 min read
Louis Davidson What Counts for a DBA: Hats It was not long ago that the hats that people wore at work signified their roles in society. Two people... 06 January 2014 5 min read
Simon Cooper C# via Java: Arrays The one primitive type that hasn’t been covered is the array. An array contains a fixed number of items, and... 03 January 2014 5 min read
Jonathan Allen Tribal SQL Awards This is likely to be my last blog for 2013 and it is one that is going to give you... 23 December 2013 2 min read
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: https://nodejstools.codeplex.com/releases/view/116275 It’s only been a month since the first... 20 December 2013 3 min read
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... 20 December 2013 4 min read
Melanie Townsend Recognizing Community Leaders – Tribal Awards Finalists The time has come, voting is now open for the Tribal Awards finalists. Let’s recognize the people who go over... 19 December 2013 2 min read
Phil Factor IT Aphorisms An aphorism is a concise or laconic statement that expresses an element of truth, and maybe a sting in the... 19 December 2013 5 min read
Pop 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... 13 December 2013 1 min read
Jonathan Allen I Thought Everyone Did It Like That – SSMS Templates One of an occasional series of blogs about things that I do that perhaps others don’t. SSMS – the default... 12 December 2013 10 min read
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... 11 December 2013 6 min read
