The Multifunctioning DBA:

June, 2012

June 29, 2012  10:05 PM

Weight Loss Contest Complete Part 2

Colin Smith Colin Smith Profile: Colin Smith

So all the results from my team are in and we did very well. I am pretty sure that we will win the competition but time will tell that. So my team had 8 guys that I work with, including me. At the start our combined weight was literally over a ton. Crazy right? The total starting weight for the...

June 29, 2012  3:52 PM

Wieght Loss Contest Complete

Colin Smith Colin Smith Profile: Colin Smith

Just wanted to give an update on the weight loss challenge that I was participating in. It was a long 8 weeks and it was not easy at all but it was worth it. Not all the final numbers are in for my team and or all the other teams but my numbers are in so here they are. Starting Weight:...

June 25, 2012  5:34 PM

Great contest running now.

Colin Smith Colin Smith Profile: Colin Smith

If you are not already a member of the SQL Skills Insiders, you need to be. Go sign up now. You are missing out on some good stuff and you should not be missing it. It is free and you...

June 20, 2012  11:00 PM

Epic app fail for Database Recovery

Colin Smith Colin Smith Profile: Colin Smith

The other day my team decided that we needed to rethink our recovery strategy for an application. In order to meet the new recovery requirements, we needed to put the database in Full Recovery and take T-Log backups every hour. This would allow us to recover up to the minute with a worst case of 1...

June 20, 2012  4:18 PM

Catching up and Powershell

Colin Smith Colin Smith Profile: Colin Smith

This morning I was catching up on some blog reading and I saw this great paragraph from Brent Ozar (blog | twitter) about...

June 20, 2012  3:33 PM

Get in Shape

Colin Smith Colin Smith Profile: Colin Smith

For the past few, well 5 weeks, I have been participating in a fitness challenge at work. It is really great. We have a gym on site and they are putting on this challenge. They broke all the contestants out on to teams and my team is made up of pretty much all the guys in my cube row. I am not...

June 8, 2012  10:00 AM

Table Partitioning in MS SQL Server

Colin Smith Colin Smith Profile: Colin Smith

How to create a partitioned table in SQL Server. This example is based on weekly partitions by date but it could be anything you need. 1.    Create the filegroup(s) that the partition table will reside on. a.    ALTER DATABASE databasename ADD filegroup [filegroupname] 2.    Create...

June 7, 2012  6:09 PM

Pass Summit 2012 Session Submission

Colin Smith Colin Smith Profile: Colin Smith

Yesterday I was notified that again this is not the year for me. My session was not accepted for the summit once again. That is OK though, I know that they only have so many spots that they can fill and I know that I was up against some good competition. I will try again next year and during the...

June 6, 2012  11:33 PM

New Ignite Version

Colin Smith Colin Smith Profile: Colin Smith

We just upgraded our Ignite to version 8 and it is nice. First you will notice some nice useful widgets at the top of the home page that give you a good overview of what is currently going on. I like these but if you do not they give you the ability to hide them. The other big thing that I...

June 4, 2012  2:56 PM

PASS 2012 Sessions

Colin Smith Colin Smith Profile: Colin Smith

This week is the week that hopeful presenters for the 2012 PASS Summit will be notified if they have been selected or not. We should all know by this Friday if we have been chosen to speak, to be an alternate, or just flat out denied, like I was...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: