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
Richard Mitchell Remoting and common classes I’ve been playing a bit lately with .NET Remoting and I must say that so far I’m deeply un-impressed. The... 12 February 2008 6 min read
Phil Factor The Technically minded subclass, and the fog of misperception. I spent several years in a team that advised a large international manufacturing company on their software-purchasing strategy. It always... 06 February 2008 4 min read
Dan Archer Step up to Red Alert! “Step up to Red Alert!”“Sir, are you absolutely sure? It does mean changing the bulb…” — Red Dwarf Computers are... 05 February 2008 7 min read
Jason Crease Using the Exception Hunter Command Line to find All Methods that throw a given Exception Red-Gate’s new .NET tool – Exception Hunter – shows you the exceptions that can be thrown by a .NET method.... 31 January 2008 1 min read
