The Multifunctioning DBA:

SQL Server


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


June 25, 2012  5:34 PM

Great contest running now.



Posted by: Colin Smith
Free Training, SQL Server, SQL Skills

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


April 18, 2012  6:00 PM

SQL Saturday Swag



Posted by: Colin Smith
Powershell, SQL Server, Swag, Training

All, I have just been informed by my good friends at Idera that they will be providing me with two full licenses for there great


April 18, 2012  8:00 AM

Jobs Repository



Posted by: Colin Smith
Powershell, SQL Server

I have been working on a task that will populate a database with a ton of information about jobs from all my sql servers and allow me to do reporting on it. Of course I chose powershell to write the script to go get all my data and to populate my tables. I am also using some SPROCS in order to...


February 1, 2012  10:00 AM

SQL Saturday is back in Phoenix



Posted by: Colin Smith
Free Training, SQL Saturday, Training

SQL Saturday is back on in Phoenix. I am excited as I really enjoyed the event last year and I expect that this one will be even better now that the organizers have the first one under there belts. Here is a link to the event home page.


January 14, 2012  8:00 AM

PS script to check SQL Server Groups



Posted by: Colin Smith
AD, Groups, Powershell, SQL Server

This is the script that I threw together to check and see if a user is in multiple AD Groups that are logins to the SQL Server instance. This helped me resolve an issue and it may help you look for things like explicit deny or some other reason why a user does not have the access they need or...


January 13, 2012  5:35 PM

Strange Issue with MSSQL error 18456



Posted by: Colin Smith
18456, connectivity, SQL Server, Troubleshooting

I know that this is everyone's favorite error message that SQL Server spits out. I love it because it has so many states that can give you an idea about what the root cause of the issue is. The downside is that some of the states really do not give you any good information and are just generic. So...


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: