SQL Server and PowerShell Security

Sometime back, I heard that Microsoft was going to start using PowerShell scripts to monitor and optionally enforce security standards in SQL Server configurations, such as in the Microsoft Security Compliance Manager (SCM). I knew little about PowerShell, but right away I had a serious concern about whether or not requiring the use of PowerShell…


Free SQL Ranger Training

When I first heard about “SQL Rangers” I wasn’t sure what it was, but I definitely wanted to be one. Just ’cause it sounded so cool. Basically, it was an early name for what later became Microsoft Certified Masters, which was the highest level of certification. Over time, the Master certification program expanded and evolved,…


PFE vs. Consultant

Well, it’s almost the end of June and none of my draft posts are close enough to finishing to meet my self-imposed standard of at least one post per month. So, here’s a pathetic little human-interest post. Microsoft has a Services group which provides a variety of support personnel to customers. Customers pay for this…

1

Test SharePoint Mirror Without Down-Time

Here’s a ??SQL Server PFE war-story to give one example of one of the kind of work we might do. Most of the customers I support run SharePoint services, and they use a variety of methods to provide disaster recovery capabilities. One method involves SQL Server’s Database Mirroring capability to maintain a copy of the data at…


SQL Server Index Key Performance Indicators

It’s common for PFE’s to get involved with performance tuning issues, and for SQL Server, indexes are a critical part of maximum performance. I recently ran into a performance problem that was due entirely to the statistics being outdated on an index, so I refreshed my memory a bit about them and came up with a…

1