The Multifunctioning DBA:


June 8, 2012  10:00 AM

Table Partitioning in MS SQL Server

Posted by: 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...

January 25, 2011  6:02 PM

Free Training Contest

Posted by: Colin Smith
MSSQL, Training

Who wants some free training? I know I do and that is why my last post was what it was. Here is a link to the competition. Get in and get your post done today for your chance to win some Awesome Training.

January 27, 2010  5:46 PM

DBA Roles

Posted by: Colin Smith
Developer DBA, MSSQL, Roles, Seperation of Roles, Systems DBA

I have a scenario that I would like to talk to you all about and get your take on what should be done. I am a Systems DBA. I am not a Developer. Lets say that in the not so distant past my team of System DBA's got a phone call from a developer in a panic. They needed a restore and needed it now....

January 22, 2010  1:12 PM

Health Check into SQL Server

Posted by: Colin Smith
Audit, Baselining, MSSQL, MSSQL Administration, Trending

I have recently posted about my new job and how I am walking into the unknown. Like I have said in the past, I did get a list of Host Names that are running SQL Server. I have written a script to go out and look at each of those hosts and get me all instances. I have put together a list of about...

October 27, 2009  3:30 AM

Active, Active, Active

Posted by: Colin Smith
Cluster, MSSQL, MSSQL Administration, MSSQL Install, MSSQL Server, SQL Server 2008

Last week I got the chance to work on an Active, Active, Active SQL Server 2008 Cluster install. This was new to me and very fun. We have three physical hosts all using SQL Server 2008 Enterprise Edition. The Servers are also running Windows Server 2008 Enterprise Edition. I worked with one of our...

October 22, 2009  10:00 AM


Posted by: Colin Smith
Certification, MS SQL Server, MSSQL, Study

So Like I said before I did take the MCTS Exam and I did pass. I can not go into any detail about the test as you have to agree to an NDA before you take it. The test was, in my opinion, not as hard as the study material. I think that MS did a great job with the study material for this test. I was...

September 16, 2009  3:23 PM

Installing SQL Server 2008

Posted by: Colin Smith
MSSQL, MSSQL Administration, MSSQL Install, MSSQL Server

Yesterday I had to install SQL Server 2008 for the first time. I went through it on a development server first before installing on a production server. As I went through the setup process I noticed one thing that I think is long overdue. The Database Configuration step is a great addition to the...

July 28, 2009  10:18 PM

Migrating SQL 2005 Reporting Services

Posted by: Colin Smith
Database Administration, MSSQL, MSSQL Administration, MSSQL Server, Reporting Services

I have been asked to help with Migrating a SQL Server 2005 Reporting Services server from one host to another. I set up a couple VM's and away I went. I found that it is pretty straight forward though. I did run into a couple little hickups along the way but nothing to dificult. I did have a...

July 14, 2009  3:53 PM

New Job

Posted by: Colin Smith
Job, Job Market, MSSQL, MSSQL Administration

Last Thursday my company did some layoffs and re-orginization. I survived the layoffs but my job has changed. I am no longer a Database Administrator for a major media company in Phoenix Arizona, but now I am a Database Analyst for a nation wide media company. I am still based in the Phoenix area...

July 13, 2009  5:31 PM

MSSQL Server Renaming Physical Host

Posted by: Colin Smith
Database Administration, MS SQL, MS SQL Server, MSSQL

Recently I had a server that hosts a MSSQL 2005 SQL Server named instance and the Windows group decided that the name of the server had to be changed. I thought that this may cuase an issue since the MSSQL Server name is 'hostname\instancename'. I did a bit of research and found that a solution is...

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: