The Multifunctioning DBA:

MS SQL Server


August 16, 2012  3:45 PM

Database Virtulization



Posted by: Colin Smith
Database Administration, Database Virtualization, MS SQL, MS SQL Admin, MS SQL Server

Some of you may see the name of this post and think that I am going to talk about running SQL Server on VMWare or HyperV. Well that is sort of correct but not really. I am involved in the very early beta testing of a new product that will let you provision VDB's. I am not going to mention names...

June 8, 2012  10:00 AM

Table Partitioning in MS SQL Server



Posted by: Colin Smith
MS SQL Server, MSSQL

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...


March 12, 2010  5:28 PM

Phoenix SQL Saturday



Posted by: Colin Smith
DBA, MS SQL Server, PASS, SQL Saturday

Like I said in my last post, I attended my first users group and it was announced that a SQL Saturday is in the early planning stages. I am excited about this and since I am so excited I contacted Samson Loo, who is the one that made the anouncement, to see if I could help and also if I could post...


January 8, 2010  7:19 PM

Find SQL Server Instances using Powershell



Posted by: Colin Smith
MS SQL Server, MSSQL Administration, MSSQL Instance, Powershell, Scripting

As I had mentioned before, I recieved a network scan that lists the host names of servers that have some sort of SQL Server running on them. Now I need to get a list of all instances that are on those servers. I thought I could do it in Powershell and I was correct. I know that all instnances of...


October 26, 2009  4:26 PM

Databases not accessible



Posted by: Colin Smith
MS SQL Admin, MS SQL Server, MS SQL Troubleshooting, MSSQL Administration, SQL Server 2005

Just got a call that three databases on an instance where many reside were not accessible. Users were getting errors about not enough disk, memory, or the files were inaccessible. I logged into the server and found that the databases were not offline but could not be accessed. I looked into the...


October 22, 2009  10:00 AM

MCTS Exam



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 8, 2009  5:33 PM

MS Certification Test



Posted by: Colin Smith
Certification, MS SQL, MS SQL Admin, MS SQL Server

I have scheduled my first certification test for late October. I think that by putting the date on the calendar it will push me to finish my study more quickly. I have not been as vigilent as I would have liked to be so I am lighting the fire so to speak. Also with my new position I think that I...


August 28, 2009  7:12 PM

Powershell execute SQL Server Jobs



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

I have been asked to write a script that will allow users to connect to a server, get a list of only the jobs that I want them to see, and execute only those jobs. No options to do anything other than execute the job. This is what I have come up...


August 27, 2009  3:30 PM

Moving System Databases in MSSQL2005



Posted by: Colin Smith
MS SQL, MS SQL Server, SQL Server Administration, System Database Moves

Recently I had to move all system databases for one server to another physical drive. This is pretty simple for all but the Master and SystemRecource databases. For all others you can just do the following and then copy the mdf and ldf files to the new location.


August 27, 2009  3:13 PM

Questions about health check script



Posted by: Colin Smith
Answers, MS SQL, MS SQL Server, MSSQL Administration, Powershell, Powershell Tips, SQL Server

I recieved a comment that contained a question about my previous post about writing a script to output a health check of SQL Server. http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/ The following is the question: should we make anychanges for this do...


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: