Author Archives: DBAduck
Posted over on sqlblog.com about my speaking at the SQL Saturday. Hope to see you there.
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
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
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
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
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.
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
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
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