Oct 162015
 

MSOver the past few months, I have been working diligently to learn more about Azure. As a result of my studies, I have successfully passed the Implementing Microsoft Azure Infrastructure Solutions certification exam (70-533). By far, this is the hardest exam I have taken to date.

Over the past 15+ years I have worked very hard to learn as much as possible about SQL Server and the Windows operating systems that it runs on, but that knowledge only took me so far within Azure. I had to look at Azure as an entire suite of products that seamlessly work together, and to successfully pass the exam, I had to learn about each one of them. I found the content around websites to be the toughest to understand. I’m pretty comfortable with how websites are hosted, but I needed to know more on the internals of features such as application settings, diagnostic logs, and monitoring. And of course we can’t forget PowerShell. It wouldn’t be an accurate test without a few PowerShell syntax questions.

The skills we learn over the years tend to be forgotten if we don’t use them. That’s why I’d like to welcome you to the Azure edition of Everyday SQL. I thought the best way to keep my skills up-to-date would be to host a portion of my blog within Azure. Going forward, I plan to post more articles about using SQL Server and other features within Azure.

Before I end this article, there is one thing that does bug me from time to time. It’s the correct way to pronounce “Azure”. It’s a little hard to type out, so I’ll provide you will a link to the Cambridge Online Dictionary where you can play the US version of the pronunciation.

Oct 142015
 

In case you missed it last week, there will be another SQL Saturday this weekend in Charlotte, NC. If you are in the area, please come out to this free training event to hear a bunch of great professionals talk about SQL Server. You can register for the event here: http://www.sqlsaturday.com/452/eventhome.aspx.

I will be presenting one session on Performance Monitoring Tools.

No Money for Performance Monitoring Tools? No Problem!
So you like the idea of using one of the commercially available performance monitoring tools but can’t convince your boss to spend the money? Then join me as we explore some absolutely free tools born right out of Microsoft’s customer support teams: DiagManager and SQLNexus. We will see just how easy it is to use them to collect and analyze performance data from your SQL Servers. These tools can get you started quickly without having to deal with the red tape.

Oct 072015
 

I will be speaking this weekend at SQL Saturday #445 – Raleigh, NC. If you are in the area, please come out to this free training event to hear a bunch of great professionals talk about SQL Server. You can register for the event here: http://www.sqlsaturday.com/445/eventhome.aspx. So come on out and meet some great people who might be able to help you solve your worst problems.

I will be presenting two sessions on Policy Based Management and Performance Monitoring Tools.

Policy Based Management – Beyond the Basics
Policy Based Management is a great feature of SQL Server and easy to implement; however, for most organizations you need a way to customize it to your enterprise. Join me for this session as we take a deeper dive into PBM to see how you can customize polices, evaluate those polices across your entire enterprise environment, track those changes over time, and deliver reports to management showing your progress.

No Money for Performance Monitoring Tools? No Problem!
So you like the idea of using one of the commercially available performance monitoring tools but can’t convince your boss to spend the money? Then join me as we explore some absolutely free tools born right out of Microsoft’s customer support teams: DiagManager and SQLNexus. We will see just how easy it is to use them to collect and analyze performance data from your SQL Servers. These tools can get you started quickly without having to deal with the red tape.