Click here to monitor SSC

2013 March


Rodney Landrum

Dear Microsoft Access: I Love You

21 comments

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

0 comments

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?

0 comments

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

0 comments

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
Fatherjack

Speaking, Listening and Speaking again

0 comments

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

0 comments

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

5 comments

This post explains how to install Red Gate’s Automation License for Continuous Integration on Atlassian’s Bamboo CI Server so that you can start running Continuous Integration builds for your SQL Server databases. This will allow you to automatically trigger unit tests and integration tests on your database whenever you check in changes to Red Gate’s […]

21 March 2013 1:46 pm by
Phil Factor

A PowerShell RSS Reader using an OPML file

3 comments

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?

16 comments

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