Click here to monitor SSC

2013 March

Rodney Landrum

Dear Microsoft Access: I Love You


Five weeks ago, I was on a phone call talking about problems our users were having with an MS Access application. Up until this point in my career, I had successfully fended off “database” questions or issues in MS Access because I was not an MS Access expert. Now though, on this call, put together […]

28 March 2013 10:55 am by
Phil Factor

SQL Server JSON to Table and Table to JSON


One of the surprises that I got from writing for Simple-Talk was the popularity of my article Consuming JSON Strings in SQL Server.  I hadn’t really expected it to be so appreciated; in fact I was nervous about posting it at all. It came from a real requirement I had at the time, but I […]

26 March 2013 4:50 pm by
Andrew Clarke

Towards Security as a Service?


There’s some fuss around the additional security risks of moving an existing service within a corporate data center, to a cloud-hosted virtual machine, with a shared infrastructure. I appreciate the caution, but I wonder if they aren’t overstated. Sure, there are new risks, intrinsic to the cloud. For example, the so-called Hyper-jack is a security […]

26 March 2013 10:34 am by
Louis Davidson

What Counts for a DBA: Laziness


On the face of it, laziness is not the first character trait to whip out before an interviewer when asked, “What can you bring to our company?” However, I’m willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined. Of […]

26 March 2013 3:54 am by

Speaking, Listening and Speaking again


It seems a very brief two weeks ago that I was in the middle of the team running SQL Saturday Exeter as that was right before my final week at my old job. I gave a session there on Event Notifications that was possibly the most action packed I have ever been involved in. To […]

25 March 2013 10:00 am by
Michaela Murray

50 Ways to Avoid, Find and Fix ASP.NET Performance Issues: The Next Generation


The super-short version 11,000 of you have already grabbed a copy of the first edition of 50 Ways to Avoid, Find and Fix ASP.NET Performance Issues, so we’re doing a second edition to include MVC 4, SignalR and WebAPI. That means another chance to submit your tips, get your name in a slick eBook, and […]

22 March 2013 3:18 pm by
Ben Rees

Continuous Integration for SQL Server using Red Gate Tools, Atlassian Bamboo and GitHub


Update 31st March 2015 This blog post is now out of date, as there have been some changes to the Redgate products for database lifecycle management (DLM) since the post was first published. In particular, we now have a new version of Redgate SQL CI, part of DLM Automation, which makes it easier to set up […]

21 March 2013 1:46 pm by
Phil Factor

A PowerShell RSS Reader using an OPML file


To celebrate the announcement of the planned  demise of Google Reader, I’ve done a PowerShell script that gives you the  items from the OPML collection of feeds that you import or export between your feed readers. Basically,  you create your own primitive feed reader. I’m afraid it isn’t as good as Google Reader. So what […]

18 March 2013 7:12 pm by
Tony Davis

Why use a hammer when you already have a rock?


Is it ethically “sound” to invite people to pay money for a tool when there is a documented, validated and free alternative? This debate came up on Red Gate’s private forums this week after one of the developers wrote, in a state of high enthusiasm, “How awesome is SQL Index Manager! It’s reduced my DB […]

15 March 2013 12:34 pm by
James Gilmore

Profiling PowerShell cmdlets with ANTS Performance Profiler

1 comment

Following the early lead of Exchange Server 2007, Citrix’s XenDesktop SDK (which I was fortunate enough to work on), and now the Azure platform, PowerShell is being used more and more to provide the scriptable interface to proprietary systems. At Red Gate I’m usually profiling cmdlets to test the profiler itself – PowerShell is a […]

13 March 2013 6:35 pm by
Older posts

Blog archive