Our team has been hard at work building the new SQL Server Daily Health Check Email and Dashboard. It’s designed to proactively deliver the information needed to keep your SQL Server environment healthy, secure, reliable, and running smoothly. And, we’d like your feedback on it. How the new SQL Server Daily Health Check works Here’s…
Read more
SQL Server is a critical component for many businesses, and its health and performance can have a significant impact on operations. If SQL Server is having a bad day, a lot of people are having a bad day. Users, patients, loan officers, etc, and of course, IT. That’s why we recommend performing a SQL Server…
Read more
Welcome to the third and final post in our series on Data Lifecycle Management (DLM), where we will talk about archiving and purging company data. In the last post, we talked about applying the Kaizen approach to data management to achieve a culture of continuous improvement on our data teams. In this post, we will…
Read more
SQL Server is being targeted again. This attack is called DB#JAMMER. And it’s targeting poorly secured SQL Servers. What’s happening? Attackers begin by brute-forcing access into poorly secured SQL Servers. Once they have gained access, the attackers use xp_cmdshell to deploy tools. They manipulate the firewall, if needed, and transfer files to and from the…
Read more
“Take time to improve our data management processes? Sorry, we are just too busy”… fixing errors from broken data processes. This refrain is more common than you think in IT departments of all sizes. Or maybe you live that reality every day and are fully aware that clunky, error-laden processes eat away at your team’s…
Read more
Are your company’s data collection processes sound? Do they align with best practices? Welcome to the first of three posts on how to refine your strategy for data lifecycle management. In this post, we will look at how to evaluate your data collection processes for improvements. Data Collection in Data LifeCycle Management (DLM) As has…
Read more
“Why is my SQL Server slow?” Have you ever asked that question? Have your users? Unfortunately, that’s a commonly asked question. Fortunately, though, something can usually be done about it. Here are fourteen reasons a SQL Server instance could be underperforming. I’ve divided them into four broad categories. Slowness due to resource constraints Often the…
Read more
Some companies take virtual machine snapshots of their web servers, their file servers, and their Citrix servers. They regularly snapshot before software patching, before server upgrades, and before other configuration changes. Snapshotting a good way to ensure they can recover the VM if something goes wrong. So, that begs the question: should you use VM…
Read more
There’s a lot of hype surrounding the next version of SQL Server. And for good reason. SQL Server 2022 is packed with some long awaited niceties, improvements, and enhancements. Here are a few of the SQL Server 2022’s new features we are excited about. Contained Availability Groups Enhancements to Availability Groups and Distributed Availability Groups…
Read more
SQL Servers? Check. Important databases? Check. SQL Server DBA? Umm, no. Now what? If you’re like some companies, you’ve tasked a sys admin with keeping the SQL Servers running, in their spare time. Not optimal, but a full-time DBA is not in the budget. In an upcoming webinar, Working Without a DBA? A 10-Step Recipe…
Read more
Recent Comments