Author Archives: DBAduck

About DBAduck

I am a Enterprise DBA Architect for HealthEquity in Draper, Utah. I am a Microsoft SQL Server MVP and a SQL Server 2008 MCM. I am President of the Utah County SQL Server Users Group and you can find me at @DBAduck. I am a regular poster at Experts-Exchange.com as DBAduck.

Speaking at SQL Saturday 220 Atlanta #SQLSATATL

Posted on May 11, 2013 by DBAduck Leave a comment

Posted over on sqlblog.com about my speaking at the SQL Saturday. Hope to see you there.

Powershell, SMO, SQL Saturday

MCM SQL Server 2008 Achieved

Posted on April 16, 2013 by DBAduck 4 Comments

Another step in my career as I have passed the Lab Exam and have become an MCM in SQL Server 2008.  I believed I could achieve it after passing my knowledge exam the first time. The first attempt at the … Continue reading →

MCM, SQL Server

T-SQL Tuesday #39: More Efficient SMO with Server.SetDefaultInitFields

Posted on February 12, 2013 by DBAduck 1 Comment

 This T-SQL Tuesday is about PowerShell and how I use it with SQL Server. There are many more posts to come about PowerShell and SQL Server but I thought I would cut my teeth on this T-SQL Tuesday since it … Continue reading →

Powershell, SMO, SQL Server

Log Shipping encounters corrupt log backup

Posted on October 16, 2012 by DBAduck 3 Comments

I ran into an issue the other day and wanted to ensure that I shared it out there.  In a Log Shipping scenario, you can occasionally run into a corrupt transaction log backup. This causes the database to stay in … Continue reading →

SQL Server

Get SQL Server Service Accounts with WMI

Posted on September 25, 2012 by DBAduck 1 Comment

Today I was tasked with retrieving the SQL Server Service accounts to validate them in Active Directory.  I wanted a simple way to get them and show the account names for each SQL Server service.  I knew that you could … Continue reading →

Powershell, SMO, SQL Server , ,

Opportunity to download Eval of Windows Server 2012

Posted on September 21, 2012 by DBAduck Leave a comment

Use this link to download your copy of Windows Server 2012 for evaluation.  I know that I have downloaded and installed it for evaluation. http://www.microsoft.com/click/services/Redirect2.ashx?CR_CC=200128600 Have fun, it is a great upgrade.  

SQL Server

SMO and Index Fragmentation

Posted on July 7, 2012 by DBAduck Leave a comment

When working with SMO and Indexes there are times that you want to get the fragmentation of this particular index.  In SMO there is a method on the Index called EnumFragmentation.  When you call this method, there is a bug … Continue reading →

Powershell, SMO , , ,

Networking: What exactly is it, and how do you use it (appropriately)?

Posted on May 16, 2011 by DBAduck Leave a comment

I have had the opportunity lately to tap into “Marketing” something to get some traction on a Vote for Me scenario.  It made me wonder about Networking and what it really is and what I would use it for.  There … Continue reading →

Networking

Powershell, SMO and Database Files

Posted on February 14, 2011 by DBAduck Leave a comment

In response to some questions about renaming a physical file for a database, I have 2 versions of Powershell scripts that do this for you, including taking the database offline and then online to make the physical change match the … Continue reading →

Powershell, SMO, SQL Server

An honor to be among the SQL Server MVPs

Posted on January 1, 2011 by DBAduck 1 Comment

I just found out last night that I was officially awarded SQL MVP.  I am honored to be among those that I respect and admire.  I don’t contribute for the recognition and as a former MVP Lead I know the … Continue reading →

Uncategorized