Blog
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
Patching (Health Checks Series Part 1)
In this series of posts, I’m going to cover fixes for some of the most common issues on clients’ SQL Servers. Let’s kick things off with Patching.
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.
Production VMs (T-SQL Tuesday – Changing your mind)
In this month’s installment of T-SQL Tuesday, Alex Yates has invited participants to write about something in their IT career that they have changed their mind about.
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.
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…
Archives
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