András Belokosztolszki Altering CLR assemblies in SQL Server 2005 Category: SQL Server development SQL Server versions: 2005 Level: Advanced SQL Server 2005 introduced support for .Net in SQL Server.... 10 May 2006 4 min read
András Belokosztolszki A reason to avoid sp_rename Category: SQL Server developmentSQL Server versions: 7, 2000, 2005Level: Intermediate Naming stored procedures consistently is part of many organizational policies,... 10 May 2006 2 min read
Phil Factor The Pub Lunch and Programming. “Werry good poer o’ suction, Sammy,” said Mr Weller the elder, looking into the pot, when his first-born had set... 04 May 2006 4 min read
Phil Factor Getting data to the browser Slowly, all the necessary components are slotting into place to allow the developer to bypass the requirement to write traditional... 20 April 2006 4 min read
Phil Factor Selling Oneself Short A long time ago, I was transformed from resolute geek into a salesman. I’d written an application, commissioned by an... 13 April 2006 3 min read
Richard Mitchell What is SQL? OK now to most of you reading this blog, well all 3 of you at least this would seem like... 07 April 2006 2 min read
Richard Mitchell Telekinisis doesn’t exist Me and a few friends went bowling last night which is all well and good but it got me to... 29 March 2006 2 min read
Phil Factor Avoiding the TSQL ‘Convert’ styles. A recent blog was extolling the advantages of being able to use the CLR routines in SQL Server 2005 to... 26 March 2006 2 min read
Phil Factor The Incident of ‘The Two Johns’ -an IT Manager confesses. …in which Phil Factor takes advantage of the cloak of anonymity to confess to an embarassing mistake As an IT... 20 March 2006 5 min read
Helen Joyce SQL Backup 4.0 and beyond Phew…with SQL Backup 4.1 released attention has now turned to supporting 64 bit versions of SQL Server. There is no let... 15 March 2006 1 min read
Phil Factor Spoofing Popularity-A warning to Webmasters In which Phil tries to warn you of the dangers of over-valuing Website-traffic Stats. A friend who runs a local... 13 March 2006 5 min read
Phil Factor Palindromic Transact SQL Palindromes are words or phrases that read the same backwards and forwards. By the same token, Palindromic SQL executes just... 01 March 2006 2 min read
Dan Archer Wheels within wheels I hate to depart from my usual ranting and raving and actually post some useful code, but the below is... 28 February 2006 6 min read
Phil Factor I could do it in my sleep Like many other programmers, I have adapted to a rather cat-like lifestyle of intense activity followed by relative languor. This... 23 February 2006 4 min read
Dominick Reed S.P.L.I.N.K. OK.. this has nothing to do with SQL, and for that I apologise. But it does have some relevance to... 13 February 2006 2 min read
Phil Factor Sir! My dog ate my database. In asking various colleagues about the disasters or near disasters they have had with databases, I find to my astonishment... 09 February 2006 3 min read
Dan Archer Trivial Persuits Once again I find myself penning a missive on trivia, rather than matters of import. Still, now we’re here… Regular... 07 February 2006 7 min read
Dominick Reed It all went wrong Things weren’t going swimmingly. In fact, you could say it was an unmitigated disaster. That might sound overly dramatic though,... 04 February 2006 6 min read
David Connell Performance and Multiple Assigment in C# I was recently thinking if I really liked to use the Multiple assignment in ‘C#’ or if it was less... 25 January 2006 2 min read
