The Multifunctioning DBA:

Microsoft Windows


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

June 20, 2012  4:18 PM

Catching up and Powershell



Posted by: Colin Smith
Learining, online course, Powershell, Training

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


April 27, 2012  4:36 PM

JackandJill Comment



Posted by: Colin Smith
Comment, Help, Powershell

JackandJill left me a comment about an issue with one of my scripts and I would like to reach out to you and let you know that I would like to help. I am not sure what the issue really is and I would like to get more information from you so I can help you get it working. My twitter is @smithco32...


April 27, 2012  3:54 PM

More reporting work



Posted by: Colin Smith
Jobs, Powershell, Reporting

I told you about the SQL server jobs repository I was buyilding, and that is done. It works great and I have one report written that gives me an overview of all the jobs in my environment and what succeeded and what failed in the past 24 hours. That is very nice but because of that, I noticed a few...


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


April 3, 2012  3:33 PM

Powershell Plus Beta



Posted by: Colin Smith
Idera, Powershell

I was just notified of a new Beta of Powershell Plus. I love Powershell Plus and I am excited to get this Beta and play with it.  If you would like to play with it and give your feedback to Idera then follow the link and put it to the test and let them know what you think. You might win a Kindle...


January 15, 2012  8:00 AM

Connect-sql Function



Posted by: Colin Smith
Powershell, Scripting, SMO

This is a function that I keep in my profile so I can call it in any of my scripts that will run from my profile. It makes it easier for me so it might for you. function connect-sql ($arg) { if($arg -eq $null) { $server = Read-Host "enter instance name to connect to" } else { $server =...


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


November 29, 2011  5:35 PM

Powershell Gather Table Data



Posted by: Colin Smith
Powershell, SQL Server

I had a person on my team that wanted to identify tables in our enterprise that might be good candidates for compression. I thought it might help him out if I had a script that would look at every table in our enterprise that exists in a SQL Server database and give him some basic info that may...


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: