Click here to monitor SSC

2012 August


Grant Fritchey

Introduction to Agile Development

0 comments

Even though my current job is a little weird, I still consider myself to be a DBA. I didn’t start that way in IT. I came through support and into development. I loved development. There was a constant struggle to attempt to improve your code, your understanding, and, most importantly, the process of development itself. […]

31 August 2012 11:49 am by
Tony Davis

Aptronyms: fitting the profession to the name

24 comments

Writing a recent piece on the pains of index fragmentation, I found myself wondering why, in SQL Server, you can’t set the equivalent of a fill factor, on a heap table. I scratched my head…who might know? Phil Factor, of course! I approached him with a due sense of optimism only to find that not […]

31 August 2012 11:26 am by
Chris Massey

Web.NET event coming in October

0 comments

If you’re a web developer in Europe (or would like an excuse to travel to Europe), you should definitely take a look at the Web.NET event coming in October. It’s being organized by two Italian web maestros (Simone Chiaretta and Ugo Lattanzi) and the session list looks fantastic. The event site pretty much speaks for […]

30 August 2012 1:28 pm by
Damon Armstrong

Optionally Running SPSecurity.RunWithElevatedPrivileges with Delgates

0 comments

I was writing some SharePoint code today where I needed to give people the option of running some code with elevated permission.  When you run code in an elevated fashion it normally looks like this: SPSecurity.RunWithElevatedPrivileges(()=> {     //Code to run }); It wasn’t a lot of code so I was initially inclined to do […]

30 August 2012 2:05 am by
Red Gate Software BI Tools Team

SSAS Compare: an intern’s journey

1 comment

About a month ago, David mentioned an intern working in the BI Tools Team. That intern happens to be me! In five weeks’ time, I’ll start my second year of Computer Science at the University of Cambridge and be a full-time student again, but for the past eight weeks, I’ve been living a completely different […]

29 August 2012 10:43 am by
Fatherjack

Write TSQL, win a Kindle.

0 comments

So recently Red Gate launched sqlmonitormetrics.red-gate.com and showed the world how to embed your own scripts harmoniously in a third party tool to get the details that you want about your SQL Server performance. The site has a way to submit your own metrics and take a copy of the ones that other people have submitted to build […]

27 August 2012 8:00 am by
Grant Fritchey

PowerShell & SQL Compare

0 comments

Just a quick blog post to share a couple of scripts for using PowerShell to call SQL Compare. This is an example from my session at SQL in the City on setting up a sandbox development process. This just runs a compare between a set of scripts and a database and deploys it. set-Location “c:\Program […]

24 August 2012 12:08 pm by
Michael Williamson

Lightning talk: Sam Blackburn – Coderetreat

2 comments

In the spirit of trying to encourage more deliberate practice amongst coders in Red Gate, Lauri Pesonen had the idea of running a coderetreat in Red Gate. Lauri and I ran the first one a few weeks ago: given that neither of us hadn’t even been to a coderetreat before, let alone run one, I […]

24 August 2012 8:56 am by
Chris Lambrou

SQL Monitor’s data repository

7 comments

As one of the developers of SQL Monitor, I often get requests passed on by our support people from customers who are looking to dip into SQL Monitor’s own data repository, in order to pull out bits of information that they’re interested in. Since there’s clearly interest out there in playing around directly with the […]

23 August 2012 11:40 pm by
Chris Massey

Some Early Considerations

0 comments

Following on from my previous post, I want to say "thank you" to everyone who has got in touch and got involved – you are pioneers! An update on where we are right now: paper prototypes v1 To be more specific, we’ve picked two of the ideas that seem to have more pros than cons, […]

22 August 2012 5:39 pm by
Older posts