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

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

Life is dirty. So is your data. Get used to it.

Dirty data UFO

The internet provides everyone the ability to access data at any time, for any need. Unfortunately, it does not help guarantee that the data is valid, or clean. In the past year I have earned certifications in three areas: Data Science, Big Data, and Artificial Intelligence. Those studies have provided me the opportunity to explore … Read more