Bart Read What’s up with ‘using’? Let me lay my cards on the table right from the start: I don’t like using, and I don’t use... 28 April 2008 6 min read
András Belokosztolszki SQL Server 2008: New languages and older operating systems SQL Server 2008 introduces a few new languages like Welsh, Tibetan and Norwegian. While these new languages map to the... 21 April 2008 3 min read
Tony Davis The best and worst ways to optimize your code I was chatting to Phil Factor the other day about the slow start-up of some CLR applications. He started telling... 16 April 2008 3 min read
Phil Factor TSQL Spam-killer It’s very refreshing to take a break from a tedious bit of routine code to try out something unusual or... 11 April 2008 2 min read
Phil Factor The Glittering Concrete I called in to Red-Gate the other day to see Andrew Clarke, the Simple-Talk subeditor. As I arrived, he was... 02 April 2008 6 min read
Tony Davis That ain’t a database, it’s a spreadsheet! “That ain’t a database, it’s a spreadsheet!” From the Sayings of Phil Factor There is a world of difference between... 01 April 2008 3 min read
Brian Donahue Po man’s patchworkin’ If you had come of age before Component Object Model as I have, the concept of COM registration seemed rather... 27 March 2008 6 min read
Louis Davidson Sequence Table Tricks Ok, so I am writing about the kinds of things you can do with a sequence table, and I have... 23 March 2008 4 min read
Nigel Morse Anonymous delegates rock I’m finding I really like C#’s anonymous delegates. I’ve used them several times now in various ways. Normal delegates are... 18 March 2008 3 min read
Dan Archer If you see SID, tell him As a small addendum to my previous blog on the subject of authenticating users, and checking for administrator privileges, under... 17 March 2008 8 min read
Dan Archer SID. Vicious? Some activities on any operating system fall into that category of “should be extraordinarily simple, and yet is full of... 17 March 2008 19 min read
David Connell How to add to the list of available SQL Servers Have you ever wanted to add to the list of SQL Servers found in Red Gate’s SQL Compare, SQL Data... 10 March 2008 1 min read
Louis Davidson 2008: Error List in 2008 Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of... 05 March 2008 2 min read
András Belokosztolszki SQL Server 2008 CTP6 takes a day off SQL Server 2008 CTP6 does not work on February 29th. Period. On one hand, it is really nice that Microsoft... 29 February 2008 2 min read
András Belokosztolszki Type less in SQL Server 2008 (variable initialization and multiple row inserts) Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use... 28 February 2008 2 min read
Tony Davis How should you layout code? It is strange to see the heat generated over arguments about how code should be formatted. With Visual Studio, of... 27 February 2008 4 min read
Louis Davidson 2008: Rebuilding a Heap In 2005, rebuilding a table that was a heap (no clustered index) wasn’t easy. You could copy it to a... 26 February 2008 3 min read
András Belokosztolszki Can I redeclare a variable in T-SQL? Teaser for SQL Bits Variables in T-SQL behave differently from what people may be used to in languages like C or C#. The scope... 15 February 2008 3 min read
Bart Read The world is once again as it should be Weeeeell… okay, so a cursory glance at today’s news headlines would suggest that to be a rather bold claim, however... 12 February 2008 1 min read
Tony Davis SQL Server Diagnostics SQL Server diagnostics are a mess. To monitor the well-being of a server, you need to be able to inspect... 12 February 2008 3 min read
