Received the PASS Outstanding Volunteer Award

PASS is the Professional Association for SQL Server and is a Worldwide Organization with about 250,000 members. This is the 2nd time I’ve received this award, and I’m one of only 2 people to ever be awarded the designation more than once.  I was also awarded this designation in June of 2015. It will be announced at the late October PASS Summit in Seattle to over 4,000 attendees at the Washington Convention Center.
“As one of the Program Managers, Mindy has been an invaluable member of the PASS Community. She has restructured the process of reviewing abstracts by building her own database to manage the hundreds of abstracts received and to manage the workflow of reviewing all those abstracts for the team of 100 volunteers. In addition to this, when the abstract reviews were complete, Mindy alone went through all 3000 comments left by the reviewers to clean up poorly worded comments before sending those comments back to the submitter.  The processes she has set in place and the extensive knowledge she has brought to the Program Committee has made her a crucial part in making the Summit Program truly exceptional. She has time and again shown what is means to Connect, Share and Learn.”
pass_outstanding_volunteer_seal

Using Powershell to set Roles & Features required for MDS

This is my 3rd go-around installing MDS on SQL Server. I’ve been playing with it on each of the new SQL 2016 RC builds. Today I’m once again standing it up. Hey, practice makes perfect!

One of the first things that needs to happen in order to get MDS up and running is that the Roles & Features for the server need to be in the right state. Today I was playing with Powershell some (long story…but it involves an orphaned storage group in Azure), so I was already in a Powershell kind of mood. I then found a handy script, which allows you to use Powershell to “presto-chango” get the Roles & Features just right.

From: https://msdn.microsoft.com/en-us/library/ee633744.aspx

I was a little bit awkward pulling it off, but got it done. Wow, that was WAY easier than opening up the Roles and Features area of Windows! no more iterating through all of it, trying to make sure I didn’t miss anything.

Capture

But then, trying to run the Master Data Services Configuraiton Manager I still got one more warning about it needing the feature for Dynamic Web Compression in IIS to be enabled. **sigh**  So — I went back into powershell and added that feature:

compression

After that, everything was good as gold.  As you can see, in the Master Data Services Configuration Manager I had green checkbox on Prerequisites. Now I can move forward!

checkbox

Here’s the entire consolidated Powershell batch for you to copy/paste and run in your environment:

Install-WindowsFeature Web-Mgmt-Console, AS-NET-Framework, Web-Asp-Net, Web-Asp-Net45, Web-Default-Doc, Web-Dir-Browsing, Web-Http-Errors, Web-Static-Content, Web-Http-Logging, Web-Request-Monitor, Web-Stat-Compression, Web-Filtering, Web-Windows-Auth, NET-Framework-Core, WAS-Process-Model, WAS-NET-Environment, WAS-Config-APIs

Install-WindowsFeature Web-App-Dev, NET-Framework-45-Features -IncludeAllSubFeature –Restart

Install-WindowsFeature Web-Dyn-Compression

Automatically Deleting a Job

On a project my team was working on recently, we wanted to run a stored procedure every 10 minutes for 2 days to collect data over time. At the end of the 2 days, we would FTP the results up to a folder and remove any evidence that we had been on the server (clean up the tables we’d been writing to, drop the stored procedure, and in turn, drop the very job we had created to run this whole contraption.

How to delete the very job that is running?  (eyebrows raised). Is this even possible? At first we thought not. I mean, wouldn’t that tear a hole in the space-time continuum?  I asked my team to look a little deeper, there had to be a way. Maybe we could go through xp_cmdshell and call a statement that would essentially be in another process and that could do it? Let’s get creative.

Then they found it.

Automatically Delete a Job

Wow. 20 years of SQL Server and I never noticed that before. (Base of Palm to Forehead).

Thanks to Eric Blinn & Mayil Chandran for researching this and making me aware.