Military Action and Economic Sanctions Increase Risk of Cyberattack

The recent military invasion of Ukraine and resulting economic sanctions against Russia are expected to cause an increase in cyber threats such as ransomware and DDoS attacks. It is critical to stay vigilant and take necessary steps to ensure the security of your SQL Server databases. Below are a few items to review to help protect against data loss should your organization be targeted or fall victim. Limit highly privileged accounts – Make sure the sa login has a strong password. Ideally, this password should be rotated frequently and/or the login should be disabled. Use separate logins from your day-to-day

Read More »

Performance – Why CPU Configuration Matters

Sometimes, a seemingly insignificant configuration choice can have a profound impact on the performance of your SQL Server. In this short post, I will discuss a problematic CPU configuration I have come across at several companies.

Read More »

Vault for SQL Server – Dynamic Credentials

Security and automation are two of my favorite topics. HashiCorp designed Vault from the ground up to be API-driven and highly automation friendly. Because of this, I believe it is a valuable tool for SQL Server DBAs. This is the first post in a series that will cover how you can use HashiCorp Vault with SQL Server.

Read More »

End of Support for SQL Server 2008 – Coming July 9th, 2019

We are officially one week away from the end of support for SQL Server 2008 and 2008 R2 on July 9th, 2019. In a perfect world, everyone would have known this was coming and taken action already, but this is the real world. Maybe a previous upgrade went poorly and now your company prefers to cross their collective fingers and hope for the best…

Read More »

Would you like to start a project with us?

Use our online scheduling form to find a convenient time for a free 30-minute consultation to learn how SqlCS can help with your database needs