Grant Fritchey Getting a Database into Source Control For any number of reasons, from simple auditing, to change tracking, to automated deployment, to integration with application development processes,... 17 September 2012 4 min read
Tony Davis Monitoring the Application alongside SQL Server Sometimes, on Simple-Talk, it takes a while to spot strange and unexpected patterns of user activity, or small bugs. For... 14 September 2012 3 min read
Michael Williamson Replacing “if”s with your own number system During our second code retreat at Red Gate, the restriction for one of the sessions was disallowing the use of... 14 September 2012 2 min read
Louis Davidson 24 Hours of PASS next week, pre-con preview style I will be doing my Characteristics of a Great Relational Database, which is a session that I haven’t done since... 13 September 2012 3 min read
Chris Lambrou SQL Monitor’s data repository: Alerts In my previous post, I introduced the SQL Monitor data repository, and described how the monitored objects are stored in... 11 September 2012 12 min read
Louis Davidson What Counts For a DBA: Ego Leaving aside, for a second, Freud’s psychoanalytical definitions, the term “ego” generally refers to a person’s sense of self, and... 11 September 2012 3 min read
Grant Fritchey Databases in Source Control I’ve been working as a database professional for quite a long time. But originally, I was a developer. And I... 10 September 2012 3 min read
The .NET Team Content Weighting and Sociology I’ve had loads of fantastic feedback on the concept and early curation wireframes I posted on the labs, and it’s... 06 September 2012 1 min read
Red Gate Software BI Tools Team New site – and a special offer SSAS Compare has a brand new website! The old page was thrown together in the way that most Red Gate... 06 September 2012 2 min read
Michael Williamson Lightning talk: Joachim Cassel – Making Stuff Shiny on the iPhone In one of last week’s lightning talks, Joachim spent five minutes telling us about graphics and animation on the iPhone,... 03 September 2012 1 min read
Louis Davidson Utility Queries–Structure of Tables with Identity Column Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function... 02 September 2012 17 min read
Grant Fritchey Introduction to Agile Development Even though my current job is a little weird, I still consider myself to be a DBA. I didn’t start... 31 August 2012 2 min read
Tony Davis Aptronyms: fitting the profession to the name Writing a recent piece on the pains of index fragmentation, I found myself wondering why, in SQL Server, you can’t... 31 August 2012 3 min read
Louis Davidson SQLPASS DB Design Precon Preview It is just a few months left before SQLPASS and I am pushing to get my precon prepped for you.... 30 August 2012 3 min read
The .NET Team Web.NET event coming in October If you’re a web developer in Europe (or would like an excuse to travel to Europe), you should definitely take... 30 August 2012 2 min read
Damon Armstrong Optionally Running SPSecurity.RunWithElevatedPrivileges with Delgates I was writing some SharePoint code today where I needed to give people the option of running some code with... 30 August 2012 2 min read
Grant Fritchey PowerShell & SQL Compare Just a quick blog post to share a couple of scripts for using PowerShell to call SQL Compare. This is... 24 August 2012 1 min read
Michael Williamson Lightning talk: Sam Blackburn – Coderetreat In the spirit of trying to encourage more deliberate practice amongst coders in Red Gate, Lauri Pesonen had the idea... 24 August 2012 8 min read
Chris Lambrou SQL Monitor’s data repository As one of the developers of SQL Monitor, I often get requests passed on by our support people from customers... 23 August 2012 7 min read
The .NET Team Some Early Considerations Following on from my previous post, I want to say “thank you” to everyone who has got in touch and... 22 August 2012 5 min read