Monthly Archives: January 2014

Powershell in a Month Day 14 – WMI

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones. Day 14 introduces us to Windows Management Instrumentation (WMI). Since many people … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Adding to SQL Server

The next version of SQL Server will release in a few months. Most of the development is complete, and the feature list is set for SQL Server 2014. However there is work already underway for a version of SQL Server … Continue reading

Posted in Editorial | Tagged

Starting to Use Powershell

I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of anything. It looked cumbersome, I didn’t always understand how sample scripts worked, and it was just easier to use the … Continue reading

Posted in Blog | Tagged ,

Software Patents

I highly dislike the current patent system in the US. I think awarding patents for an idea like “1-click purchasing” is a poor practice that discourages innovation. There are numerous problems with our patent system, not the least of which … Continue reading

Posted in Editorial | Tagged , ,

The DBA is Dead

I love seeing articles like this one: The Database Administrator is Dead. They make me laugh and look back at previous incarnations of the same thought. I think I should save the text of this article, stick it in an appointment … Continue reading

Posted in Editorial | Tagged , , | 3 Comments

Branding, Encryption, and Yoga in Cleveland

It’s just under two weeks to SQL Saturday #241 in Cleveland. This will be my second trip of 2014 and I’m doing some planning for the trip. First, Yoga. I practice yoga every week and find it to be a … Continue reading

Posted in Blog | Tagged , , ,

Just use Version Control

There are free systems out there. If you have no budget, and want to get started, download one of these: Subversion: http://subversion.tigris.org Git: http://git-scm.com/ Mercurial: http://mercurial.selenic.com/ There are good ones to pay for as well, and some of them have … Continue reading

Posted in Blog | Tagged , , | 16 Comments

Servicing SQL Server in the Future

Service Packs have become the way that many of us patch the various Microsoft products we use. Many administrators find patching to be time consuming and difficult to justify, even for security patches, and as a result, often wait for … Continue reading

Posted in Editorial | Tagged , ,

Powershell in a Month Day 13 – Remote Control

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones. Remoting. It sounds complex, and intimidating. It isn’t, and it’s powerful. It’s also essential, allowing … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Management at Scale

Would you like to manage 20,000 databases by yourself? What about 20,000 instances? It’s not quite the same thing, but Facebook recently announced that each of their data center operations staff manages 20,000 servers. That’s an impressive number, and it comes about … Continue reading

Posted in Editorial | Tagged