In SQL Server 2022, Basic Availability Groups provide a limited, cost-effective solution for high availability and disaster recovery in the Standard Edition. However, they have several limitations when compared to a standard Availability Group in the Enterprise Edition. Although Basic AGs were introduced before SQL Server 2022, we’ll focus strictly on the latest version. Let’s…
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
SQL Server Availability Groups can present challenges after a failover, such as missing logins, outdated passwords, or absent SQL Server Agent jobs. Some clients address these issues by requiring the primary replica to remain on the same instance. If a failover occurs due to an outage or patching, they generally request to revert the AG…
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
SQL Server is designed to efficiently manage memory on its own. It requests memory when it’s needed and releases memory back to the system when it’s not. However, the default settings may not be ideal for your situation. An experienced database administrator will usually fine-tune these settings to optimize performance and server stability. Minimum server…
Read more
With the explosion of AI and ever-increasing awareness of the importance of data, the term “data governance” seems to be everywhere these days. We hear it used in different contexts, and it may seem to equate to regulatory compliance or to have relevance for only the largest companies. This interpretation misses a key benefit of…
Read more
Editor’s note: This webinar has passed, but click here to access a recording of the event. This insightful webinar digs into the critical realm of data governance for small and mid-sized businesses (SMBs) with Natasha Collins, Database Consultant at The SERO Group. Discover how overlooking data quality and integrity can cost your company dearly, from…
Read more
“I thought the cloud was supposed to be fast. Why are things moving like a sloth?” Have you heard someone complain about the speed of an application after moving it to the Microsoft Azure? Azure is a good environment, but things are not always fast in the cloud. To illustrate, in this post, we’ll review…
Read more
“Should I Use VM Snapshots to Backup SQL Server?” Like so many SQL Server related questions, the answer is “It depends.” However, most often the ultimate answer will be no. And, in this upcoming webinar we’ll share 8 questions you should ask before using VM snapshots as your approach to backing up SQL Server. RTO…
Read more
If you’ve moved your SQL Server workload to Azure Virtual Machines, you’ve noticed there’s no shortage in the number of options available. Virtual machine sizes, disk types, caching vs no caching, support for bursting, etc. When hosting SQL Server on Azure Virtual Machines, choosing the right combination of VM size and disk types is essential…
Read more
Recent Comments