Since Microsoft SQL Server databases are critical for many organizations, protecting SQL Server from disasters such as security breaches and data loss isn’t optional—it’s essential. This is especially true for sectors like healthcare, banking, and FinTech. I’ve suffered a great many catastrophes in my life. Most of them never happened. -Mark Twain Mark Twain’s quip…
Read more
Keeping SQL Servers secure is essential, especially in highly regulated industries like finance, healthcare, and government. The Center for Internet Security (CIS) offers a valuable resource for SQL Server administrators: a set of security benchmarks that provide actionable, best-practice guidance to secure SQL Server instances effectively. Implementing these standards helps reduce vulnerabilities, achieve compliance, and…
Read more
Storing sensitive information in a database, like passwords or social security numbers, is common practice. However, storing them securely is less common. Unfortunately, one of the most typical approaches is to store sensitive information in a table as clear text. That means that anyone with access to that table can see all of that sensitive…
Read more
Whether in the cloud or a data center, the cost of maintaining a SQL Server estate can escalate quickly. Beyond the direct expenses, indirect costs can quietly unbalance and outpace your IT budget. Let’s look at 8 ways to reduce the costs of your SQL Server estate. Direct and Indirect Costs of a SQL Server…
Read more
If you’re running an older version of SQL Server, you might be wondering if it’s time to upgrade. SQL Server 2022 brings powerful new features for both on-premises and cloud environments. It promises better performance, stronger security, and real-time analytics. But with the potential announcement of SQL Server vNext looming, is now the right time…
Read more
Since security and permissions are a big part of a DBA’s job, it’s important to be able to find out things like who has elevated login permissions or when a login was last used. Here are a few queries to help you check your server and database access. Most of these scripts are based off…
Read more
As an IT leader in a heavily regulated sector such as finance or healthcare, you’re no stranger to audits. They’re a critical part of ensuring compliance with regulations like the Sarbanes-Oxley Act (SOX), the Gramm-Leach-Bliley Act (GLBA), the PCS Security Standards Council (PCI DSS), and the Health Insurance Portability and Accountability Act (HIPAA). Still, audits…
Read more
Your SQL Servers are the backbone of your company’s data operations. They power critical applications and store valuable information. They enable financial decisions, undergird operational activities, and support your sales processes. But what happens if there’s a problem? What happens when data is lost or corrupted? Or if one of your key systems is down…
Read more
The SERO Group will be at the IT Symposium in Louisville on August 21st! I’m looking forward to connecting with industry leaders, sharing insights, and discussing the latest trends and innovations. The event will be at the Louisville Marriott East from 8:30 a.m. to 3:15 p.m. If you’re in the area, stop by our table…
Read more
I recently had a discussion with a client that turned to the question of SQL Server code compatibility with Azure SQL Database. We were designing a new pipeline for their on-premises SQL environment, and they mentioned their abandoned cloud migration effort from a few years earlier. The business ended up pausing this effort because of…
Read more
Recent Comments