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
Damon Armstrong SPUtility.SendMail and the 2048 Character Limit We were in the middle of testing a web part responsible for gathering information from visitors to our Client’s website... 14 December 2010 2 min read
Tony Davis Emoti-phrases Surely the next radical step in the development of User-interface design is for applications to react appropriately to the rising... 09 December 2010 3 min read
Louis Davidson Design Book– Third Section (Implementing the Database) The third section is the primary section that a person who has some decent knowledge and experience doing design will... 07 December 2010 5 min read
Louis Davidson Design Book–Dimensional or No Dimensional, that is..the question So, it is right there in the title of the book “Relational Database Design” etc (the title is kinda long... 30 November 2010 2 min read
Simon Cooper Subterranean IL: Pseudo custom attributes Custom attributes were designed to make the .NET framework extensible; if a .NET language needs to store additional metadata on... 30 November 2010 4 min read
Louis Davidson Design Book – Second Section (Logical/Conceptual Modeling/Case Studies) In the first section of the book, we established the skills that are required to do data modeling/design (well, at... 28 November 2010 3 min read
Simon Cooper Subterranean IL: Custom modifiers In IL, volatile is an instruction prefix used to set a memory barrier at that instruction. However, in C#, volatile... 26 November 2010 3 min read
Brian Donahue Updating the managed debugging API for .NET v4 In any successful investigation, the right tools play a big part in collecting evidence about the state of the “crime scene”... 24 November 2010 5 min read
Louis Davidson Un-SQL–Thanksgiving So here it is the night of Thanksgiving Eve here in the United states, and some time tomorrow I will... 24 November 2010 4 min read
Richard Mitchell SQL Monitor and "The Cloud" So, how can we demo this thing? In the beginning there was a product, and it was a good product... 23 November 2010 3 min read
Louis Davidson Design Book– First Section (Skills) One of the main things that I haven’t always loved about the previous books is that it wasn’t a perfect... 22 November 2010 5 min read
The .NET Team Alan Turing Needs Your Help Well. sort of. Clearly, you are using a computer. If you are on this site, you are probably quite familiar... 22 November 2010 2 min read
Phil Factor Listing common SQL Code Smells. Once you’ve done a number of SQL Code-reviews, you’ll know those signs in the code that all might not be... 22 November 2010 7 min read
Louis Davidson One Domain Table or Many? Early in 2007, I wrote an article for Simple-Talk called Ten Common Database Design Mistakes, and it has been... 20 November 2010 6 min read
