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 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
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
SQL Server ships with an internal system function, PWDCOMPARE(), that we can use to find SQL logins with weak passwords.
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
Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.
