SQL Server Is Better Than Ever – Blessing or Curse?
As SQL server became a world-class database system over the past two decades, setting a trap for many organizations. Twenty years ago, mission-critical applications were generally only served by enterprise-level database systems (think Oracle and DB2) . SQL Server...
SQL Server Health Check Checklist
SQL injection attacks represent over 65.1 percent of all website application attacks. To prevent your server from becoming a part of that statistic, you’ll need to take action. That way, you can mitigate damages and possibly prevent them. Moreover, you’ll want to...
SQL Server Vulnerability Assessment – Keep Your SQL Database Safe With This Microsoft Tool
By now you all know how hackers are having their way with business all over the world. I don’t need to give examples to remind you of that. Some are mentioned here and here and I’ve written a number of blogs about the importance of protecting the database here,...
7 Ways To Improve SQL Query Performance
How do you improve SQL query performance? That is a big question, and one that we get asked all the time. There is no one answer, but there is a process that we apply to make a difference in query performance. In this post, I will discuss some of the questions we ask,...