Louis Davidson Some date math fun Note: This concept presented is pretty simple and I am not claiming that I am the first to do this…... 09 February 2011 7 min read
Jonathan Allen My wife has left me . . . LiveJournal Tags: Leaving,Colleagues She announced it before Christmas, in a letter, giving the exact day she intended to leave and... 31 January 2011 2 min read
Louis Davidson Chapter One – Concepts/Requirements (The Fundamentals) So here we are, the starting chapter with the obligatory introductory material that I hope people will read, digest, memorize... 28 January 2011 3 min read
Simon Cooper Subterranean IL: Compiling C# exception handlers An exception handler in C# combines the IL catch and finally exception handling clauses into a single try statement: How... 25 January 2011 4 min read
Louis Davidson What Counts for a DBA: Passion One of my first questions, when interviewing for a DBA/Programmer position, is always: “Why do you want this job?” The... 20 January 2011 3 min read
Robbie Th'ng What’s on Azure right now? If you speak to Microsoft, they’ll give you a number of active accounts, but what are those accounts actually running?... 18 January 2011 2 min read
Damon Armstrong Obscure SPUtility.SendMail Behavior When Manually Passing in Mail Headers There are two ways to send mail in SharePoint: you can either use the mail components from the System.Net namespace,... 17 January 2011 2 min read
Laila Lotfi Automated Error Reporting = More Robust Software I would like to tell you how to revolutionize your software development process </marketing hyperbole> On a more serious note,... 17 January 2011 4 min read
Simon Cooper Subterranean IL: Exception handling control flow Control flow in and around exception handlers is tightly controlled, due to the various ways the handler blocks can be... 17 January 2011 3 min read
Jonathan Allen Resolving IIS7 HTTP Error 500.19 – Internal Server Error LiveJournal Tags: RedGate Tools,SQL Server,Tips and Tricks How To The requested page cannot be accessed because the related configuration data... 17 January 2011 2 min read
Robert Chipperfield Accessing SQL Server data from iOS apps Almost all mobile apps need access to external data to be valuable. With a huge amount of existing business data... 14 January 2011 3 min read
Simon Cooper Subterranean IL: Exception handling Today, I’ll be starting a look at the Structured Exception Handling mechanism within the CLR. Exception handling is quite a... 13 January 2011 3 min read
Phil Factor IsNumeric() Broken? Only up to a point. In SQL Server, probably the best-known ‘broken’ function is poor ISNUMERIC() . The documentation says ‘ISNUMERIC returns 1 when the... 13 January 2011 4 min read
Tony Davis Head in the Clouds We’re just past the second anniversary of the launch of Windows Azure. A couple of years’ experience with Azure in... 07 January 2011 3 min read
Jonathan Allen Getting the right results with bcp and DTS with multiple versions of SQL Server installed. I was using SSIS for the first time on an instance the other day and came across this error when... 04 January 2011 2 min read
Roger Hart Tron: Legacy, 3D goggles, and embedded UA The 3D edition of Tron: Legacy opens with embedded user assistance. The film starts with an iconic white-on-black command-prompt message... 21 December 2010 3 min read
Jonathan Allen Getting baseline and performance stats – the easy way. OK, pretty much any DBA worth their salt has read Brent Ozar’s (Blog | Twitter) blog about getting a baseline... 20 December 2010 5 min read
Brian Donahue Anatomy of a serialization killer As I had mentioned last month, I have been working on a project to create an easy-to-use managed debugger. It’s... 19 December 2010 3 min read
Damon Armstrong Resolving an App-Relative URL without a Page Object Reference If you’ve worked with ASP.NET before then you’ve almost certainly seen an application-relative URL like ~/SomeFolder/SomePage.aspx. The tilde at the... 19 December 2010 1 min read
Louis Davidson Design Book–Fourth(last) Section (Physical Abstraction Optimization) In this last section of the book, we will shift focus to the physical abstraction layer optimization. By this I... 15 December 2010 3 min read
