Using SQL Server Performance Objects

SQL Server performance objects are found inside the Performance Monitor tool, also known as perfmon. If you are using Performance Monitor for gathering resource metrics for SQL Server then you are familiar with a screen such as this one: You can see I have navigated to the SQL Server Plan Cache counter, selected Cache Hit … Read more

Microsoft Professional Program Is Ending

certified in artifical intelligence

Late last Friday night, Microsoft announced that it was retiring the Microsoft Professional Program. The reaction from many was a general “WTH is that anyway?” Frequent readers of this blog will recognize the program where I earned certifications in Data Science, Big Data, and Artificial Intelligence. I was also just shy of certifications in Cybersecurity … Read more

SQL Injection Protection

sql-injection-example-feature

SQL injection is a common form of data theft. I am hopeful we can make SQL injection protection more common. The 2018 TrustWave Global Security Report listed SQL Injection as the second most common technique for web attacks, trailing only cross-site scripting (XSS) attacks. This is a 38% increase from the previous year. That same … Read more

Updated Analytics and Big Data Comparison: AWS vs. Azure

analytics and big data comparison aws versus azure

Building upon my earlier post, today I want to share with you the updated graphic and links for the analytics and big data services offered by Microsoft Azure and Amazon Web Services. It is my hope that this post will be a starting guide for you when you need to research these analytic and big … Read more

Updated Data Services Comparison: AWS vs. Azure

data services comparison aws versus azure

Last year I wrote a post comparing the data services offered by both AWS and Microsoft Azure. Well, there’s been some changes since, so it was time to provide an updated graphic and links. Since both Microsoft Azure and Amazon Web Services offer many data services, I thought it worth the time to create a … Read more