The Multifunctioning DBA:

August, 2012


August 31, 2012  7:00 AM

Have a good Holiday



Posted by: Colin Smith
Database

If you are like me you are getting away for the long weekend. I am heading out to San Diego to take Mason to the Beach for the first time. I hope that all of you will be having a good time as well. Get away from work and just have a good time. Drink some beer, have a good time with your family and...

August 30, 2012  7:30 AM

Just a little rant



Posted by: Colin Smith
Database

This one is really for application support teams. All I ask is that you understand how your app works before you blame the database. For instance, if a user is unable to save a project to a database in your application, you should know and understand the workflow and the security model that is in...


August 30, 2012  2:23 AM

My Future DBA



Posted by: Colin Smith
Database

8 months ago I had my first child and I thought I would introduce him. His name is Mason and he is my future DBA. He loves to bang on the keyboard when I sit at the computer and I am holding him so I just know that he will be a natural. He hears me talking about work all the time so I am sure he is...


August 23, 2012  3:17 PM

Index Fragmenting on Purpose



Posted by: Colin Smith
SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

In most cases we would like to reduce fragmentation and try to come up with ways, like reducing fill factor, to minimize the amount of fragmentation that occurs when doing inserts and updates. I , however, need to create fragmentation. I am sure that you are asking yourself why I might need to do...


August 21, 2012  9:10 PM

Partition Table Load Mistake



Posted by: Colin Smith
SQL Admin, SQL Administration, SQL Server

I have a table that has 54 partitions and is a range right partition function. So ideally I like to have 52 partitions with data in them and the first and the last partitions are empty. Well the other day, our ETL team ran a load job that is meant to run after our weekly load process. They had not...


August 21, 2012  4:29 PM

Powershell to get DB Role Members Report into Excel



Posted by: Colin Smith
Database, Excel, Powershell

Recently I had an application support group ask if I could get a report of all the members of the database roles that the application uses. I thought about it and, you know me, I thought, POWERSHELL!! Of course I can do that, I will get you a spreadsheet with that data as soon as I can. Off to...


August 21, 2012  4:18 PM

MSSQL Server and BCP



Posted by: Colin Smith
SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

I recently had a need to BCP a very large data set in and out of a database. The out is no issue. bcp [databasename].[schema].[table] direction path_to_output_file.txt -Sservername -c -T is the format that I was using and it worked fantastic. I was able to BCP out my 934Million rows. Now I...


August 18, 2012  10:36 PM

Windows 8 Enterprise Activation



Posted by: Colin Smith
Database

I mentioned that I downloaded Windows 8 from my TechNet subscription, but I had one heck of a time getting it to activate. When installing the Enterprise version the installer never asks you for your product key. I thought this was strange but I went with it until I could not customize my desktop...


August 17, 2012  12:00 PM

Powershell to Drop Procs



Posted by: Colin Smith
POSH, Powershell Tips, Scripting, Scripts, SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

I was asked by a developer if I could drop all the procs in a database except the ones that he knew were being used. I thought Powershell can do that. So I told him that I could if he provided me a list of the ones that he did not want to be droped. So he sent me a list and I got to work. I thought...


August 17, 2012  4:00 AM

Windows 8



Posted by: Colin Smith
OS

I have downloaded the RTM Windows 8 bits from my technet account and installed them on a laptop that I use to do testing. I must say that I am actually, so far, somewhat impressed. I have not played with it for long so I still have a lot of things to do before I give it a a thumbs up or down but...


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: