Rebecca Amos Thank you to all entrants! Finalist announcement coming soon… We had a fantastic response to this year’s Exceptional DBA Awards. A big thank you to everyone who took the... 01 July 2011 1 min read
Laila Lotfi Turnkey with LightSwitch Microsoft has long wanted to find a replacement for Microsoft Access. The best attempt yet, which is due out in,... 30 June 2011 2 min read
Rebecca Amos Last chance to enter! Exceptional DBA Awards 2011 Only 1 day left to enter the Exceptional DBA Awards! Get started on your entry today, and you could be... 29 June 2011 1 min read
Grant Fritchey SQLIO Writes SQLIO is a fantastic utility for testing the abilities of the disks in your system. It has a very unfortunate... 28 June 2011 4 min read
Simon Cooper Inside Red Gate – Be Reasonable! As I discussed in my previous posts, divisions and project teams within Red Gate are allowed a lot of autonomy... 24 June 2011 4 min read
Phil Factor How to develop TSQL Code The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored... 24 June 2011 15 min read
Rebecca Amos 4 Top Tips from the Exceptional DBA Award judges There’s still time to celebrate your achievements as a DBA – or those of a DBA you know – by... 23 June 2011 2 min read
Richard Mitchell SQL Azure Down – how I got labs.red-gate.com back up 11:06am – Currently SQL Azure in western europe is down How do I know this? Well on labs.red-gate.com (my Azure... 23 June 2011 3 min read
Fabiano Amorim Questions about SQL Server Distribution Statistics Fabiano was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current... 23 June 2011 20 min read
Bahadir Arslan Hosted Team Foundation Server 2010 Review Team Foundation Server (TFS) has expanded its remit to support the whole software development process, but is is not designed... 23 June 2011 22 min read
Robert Sheldon Table Value Constructors in SQL Server 2008 Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. This... 22 June 2011 11 min read
Alex Kuznetsov Yet Another SQL Strategy for Versioned Data There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is... 22 June 2011 11 min read
Louis Davidson Chapter 7–Enforced Data Protection As the book progresses, I find myself veering from the original stated outline quite a bit, because as I teach... 21 June 2011 4 min read
Grant Fritchey SQL Excursions Not everyone likes boats. Some people like hanging out, on dry land, maybe sipping a good wine. Interested in doing... 20 June 2011 1 min read
Louis Davidson Speaking at PASS (and a plug for two other conferences) So I was notified a few days ago that one of my sessions was selected, and one is an alternate.... 17 June 2011 6 min read
Rebecca Amos 5 ways the Exceptional DBA Award could boost your career Winning the Exceptional DBA Award won’t just get you full conference registration for the PASS Summit – it could also... 17 June 2011 2 min read
Richard Mitchell 5 Reasons why I hate WPF I decided to use writing a new tool as a way to learn WPF and MVVM and I thought I’d... 16 June 2011 4 min read
Simon Cooper Inside Red Gate – The Office The vast majority of Red Gate is on the first and second floors (the second and third floors in US... 15 June 2011 3 min read
David Njoku Readying your Oracle Database for Your First Apex Application APEX can be a great way to create an application rapidly on an Oracle Database. Although it is generally straightforward,... 14 June 2011 9 min read
Rebecca Amos Do your good deed for the day: nominate an exceptional DBA Do you know an exceptional DBA? Think they deserve recognition at the world’s largest technical SQL Server conference? Nominate them... 10 June 2011 1 min read