The Multifunctioning DBA:

Administration

1

August 16, 2012  3:08 PM

Easy way to find bytes per cluster on your disk



Posted by: Colin Smith
Administration, Data Files, Database Administration, Disk Performance

I recently learned a new windows command that is not the most intuitive, but it is nice.  I know that when I get a server and I am told that all my volumes are ready to go for SQL Server, I want to make sure that I have a 64K block. This command makes it easy to verify.   fsutil fsinfo...

May 26, 2010  7:00 AM

Powershell to get unique login count from SQL Server



Posted by: Colin Smith
AD, Administration, DBA, Powershell, Reporting

Just like I needed to get a count of unique logins to an application on one of our Sybase instances I also needed to get these values for a few of our SQL Servers. Since SQL Server uses mixed mode authentication and we are using AD groups to aid in the security of the SQL Server, I could not just...


April 29, 2010  9:32 PM

ddlgen in Sybase



Posted by: Colin Smith
Administration, DDL, DDLGEN, Sybase

I completed an upgrade from Sybase 12.5 to Sybase 15.0 recently and I found that it ended up breaking some scripts that we use to generate ddl for all instance devices and all create databases. The scripts that we were using were writting log ago by people that are no longer working for the...


April 19, 2010  4:50 PM

SQL Saturday in Phoenix



Posted by: Colin Smith
Administration, Education, SQL Saturday, sql saturday 47, SQL Server, Training

I have posted this before, but I was asked to post about it again. SQL Saturday is a go for Phoenix. We have a date of July 17th at the

Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 18, 2009  4:37 PM

AD Audit in Powershell



Posted by: Colin Smith
AD, Administration, Audit, Automation, Powershell

I have mentioned this before but I have finally done what I set out to do and re-wrote my old vbscript that audits AD Accounts based on Create Date and Last LogonDate in Powershell. This is another great example of how much better powershell is and why everyone should now it. My VB Script was just...


August 18, 2009  6:00 PM

Powershell Profile



Posted by: Colin Smith
Administration, Automation, Powershell, Powershell Tips, Scripting

The Powershell Profile is a script that druns anytime you launch Powershell. This is handy so you can ste up variables, add snapins, or just do what ever you like or think is cool when launching Powershell. I was just editing mine, which you can do by: notepad $profile This will pull up your...


June 30, 2009  8:13 PM

Select Folder Dialog Box



Posted by: Colin Smith
Administration, Powershell, Scripting

If you would like your scripts to interact with the user and have a nice popup box for a user to select a folder here is a link to an article that will help you out. I think this is pretty great. http://powershell.com/cs/blogs/tips/archive/2009/04/01/select-folder-dialog.aspx


June 30, 2009  3:38 PM

Reboot a Remote Windows Host Remotely



Posted by: Colin Smith
Administration, Powershell, Remote boot, Windows Administration

Say you need to reboot a server and this is something that you would like to automate based on certain criteria. For instance, I might want to reboot a server if I can talk to the server but for somereason my SQL Server is not up and running. If everything is configured correctly the SQL Server...


June 26, 2009  3:54 PM

Another Example of why you should learn Powershell



Posted by: Colin Smith
Administration, Powershell, Scripting, Server Administration

I was roaming around the web and reading some articles and I ran across the following blog post: http://bassplayerdoc.blogspot.com/2008/10/another-one-liner-in-windows-powershell.html I think this is a great reason why all administrators that deal with Microsoft products should learn...


1

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: