Click here to monitor SSC

2011 October

Damon Armstrong

SharePoint 2010 HierarchicalConfig Caching Problem


We’ve started using the Application Foundations for SharePoint 2010 in some of our projects at work, and I came across a nasty issue with the hierarchical configuration settings.  I have some settings that I am storing at the Farm level, and as I was testing my code it seemed like the settings were not being […]

29 October 2011 4:58 am by
Tony Davis

A temporary disagreement


Last month, Phil Factor caused a furore amongst some MVPs with an article that attempted to offer simple advice to developers regarding the use of table variables, versus local and global temporary tables, in their code. Phil makes clear that the table variables do come with some fairly major distribution statistics, no parallel query […]

28 October 2011 10:54 am by
Phil Factor

Table Variables: an empirical approach.


It isn’t entirely a pleasant experience to publish an article only to have it described on Twitter as ‘Horrible’, and to have it criticized on the MVP forum. When this happened to me in the aftermath of publishing my article on Temporary tables recently, I was taken aback, because these critics were experts whose views […]

27 October 2011 9:06 pm by

What job is most similar to being a DBA?


As long as I have worked with computers, and that’s a length of time that may be easier on the eye when converted to dog-years, computers have been compared with cars. I guess the car was the most complicated thing in our lives until the PC arrived. We had plenty of time to get used […]

24 October 2011 3:00 am by
Simon Cooper

Some non-generic collections


Although the collections classes introduced in .NET 2, 3.5 and 4 cover most scenarios, there are still some .NET 1 collections that don’t have generic counterparts. In this post, I’ll be examining what they do, why you might use them, and some things you’ll need to bear in mind when doing so. BitArray System.Collections.BitArray is […]

21 October 2011 11:03 am by

Jobs – are your SQL Agent jobs talking to you enough?


Most DBAs will have at least a couple of servers that have SQL Agent jobs that are scheduled to do various things on a regular basis. There is a whole host of supporting configuration settings for these jobs but some of the most important are notifications. Notification settings are there to keep you up to […]

20 October 2011 3:00 am by
Grant Fritchey

Sharing My Thoughts on Space Flight


This went out in the DBA newsletter from Red Gate, but I enjoyed writing it so much, I thought I’d share it to a wider audience: I grew up watching the US space program. I watched men walk on the moon for the first time in 1969, when I was only six years old. From […]

18 October 2011 1:03 pm by
Laila Lotfi

Finding bugs is difficult, right?


Something I hear developers tell us all the time is that they take pride in being a developer.and that bugs are a dent in that pride. Someone once told me “I know I have found bugs years later, and it’s the worst feeling in the world.” So how can you avoid that sinking feeling when […]

17 October 2011 2:02 pm by
Brian Donahue

Event-Driven Debugging


Most application troubleshooting involves getting an error, analyzing the error message, and at worst, attaching a debugger to work out the real cause. What is not really covered is how to troubleshoot an applicaiton that is not errant, but is having a performance issue, and more than likely, in the middle of the night when […]

15 October 2011 2:53 pm by

62 miles up

1 comment

RedGate are known for being a software company with a big personality and having a huge presence in the SQL Community. They run the annual Exceptional DBA competition, having held a party at the PASS summit last night to celebrate this years winner – Jeff Moden. They have also got a great attitude towards their […]

12 October 2011 10:10 am by
Older posts

Blog archive