Author Archives: dbaduck

Speaking at SQL Saturday #287 – Madison, WI

http://www.sqlsaturday.com/287/eventhome.aspx I am excited to get on my way to Madison. I will be speaking on TSQL Best Practices.  We have a great lineup and it will be a great time.

Uncategorized

Speaking at SQL Saturday 220 Atlanta #SQLSATATL

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

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

 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

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

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

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

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)?

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

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