Click here to monitor SSC

Grant Fritchey


Grant Fritchey

Advantages of SQL Backup Pro

1 comment

Getting backups of your databases in place is a fundamental issue for protection of the business. Yes, I said business, not data, not databases, but business. Because of a lack of good, tested, backups, companies have gone completely out of business or suffered traumatic financial loss. That’s just a simple fact (outlined with a few […]

29 July 2013 3:08 pm by
Grant Fritchey

Offsite Backup

3 comments

There was a recent weather event in the United States that seriously impacted our power grid and our physical well being. Lots of businesses found that they couldn’t get to their building or that their building was gone. Many of them got to do a full test of their disaster recovery processes. A big part […]

26 November 2012 12:36 pm by
Grant Fritchey

Hosted Monitoring

0 comments

The concept of using services to take the place of writing a lot of your own code goes way, way back in computing history. The fundamentals of the concept go back to the dawn of computing with places like IBM hosting time-shares for computing power that you could rent for short periods of time. But […]

25 October 2012 6:44 pm by
Grant Fritchey

Getting a Database into Source Control

1 comment

For any number of reasons, from simple auditing, to change tracking, to automated deployment, to integration with application development processes, you’re going to want to place your database into source control. Using Red Gate SQL Source Control this process is extremely simple. SQL Source Control works within your SQL Server Management Studio (SSMS) interface.  This […]

17 September 2012 12:45 pm by
Grant Fritchey

Databases in Source Control

3 comments

I’ve been working as a database professional for quite a long time. But originally, I was a developer. And I loved being a developer. There was this constant feedback loop of a job well done, your code compiled and it ran. Every time this happened successfully, you’d check it into source control. These days you […]

10 September 2012 12:45 pm by
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
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
Grant Fritchey

Monitoring Your Servers

0 comments

If you are the DBA in a large scale enterprise, you’re probably already monitoring your servers for up-time and performance. But if you work for a medium-sized business, a small shop, or even a one-man operation, chances are pretty good that you’re not doing that sort of monitoring. You know that you’re supposed to be […]

17 August 2012 1:42 pm by
Grant Fritchey

Tuning Red Gate: #5 of Multiple

1 comment

In the Tuning Red Gate series I’ve shown you how to look at a current load on the system and how to drill down to look at historical analysis of the system. I’ve also shown how you can see the top queries and other information from the current status of the system. I have one […]

4 April 2012 5:18 am by
Grant Fritchey

Tuning Red Gate: #4 of Some

1 comment

First time connecting to these servers directly (keys to the kingdom, bwa-ha-ha-ha. oh, excuse me), so I’m going to take a look at the server properties, just to see if there are any issues there. Max memory is set, cool, first possible silly mistake clear. In fact, these look to be nicely set up. Oh, […]

23 February 2012 5:00 am by
Older posts