Tag: IT Manager

enhanced data security

5 Reasons You Should Use SQL Audit to Enhance Database Security

We know better than to click a link from the son of an unfairly deposed Nigerian Prince who needs our help. Yet, according to Deloitte’s 2023 Global Risk Management Survey, 91% of all cyberattacks begin with a phishing email. And many of them are successful. No business or industry is off limits. So, it’s important…
Read more

DB#JAMMER targets SQL Server

DB#JAMMER is Targeting Poorly Secured SQL Servers

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

the zen of sql server data management

Data Management Strategy: A Kaizen Approach

“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

putting out a SQL Server fire

How to Align Your SQL Server to Your RPO and RTO Goals

Many businesses depend on data systems. Data systems help doctors schedule appointments with patients. They allow construction companies to manage projects and calculate costs. The list goes on and on. And if a key data system isn’t available, it hurts. It’s disruptive. And users, customers, patients, and leadership get unhappy. That’s why it’s important to…
Read more

Data Collection: Two Key Tools to Improve Your Data Strategy

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

SQL Server database corruption can make you sick

A Severe Error Occurred! 5 Ways to Detect Database Corruption Early

No one likes to think about how to detect database corruption. But, Imagine this: you’re arriving at your job expecting an ordinary day. You begin receiving calls that the main application is returning a weird error when submitting or updating data; A severe error occurred on the current command.  The results, if any, should be…
Read more

Are Information and Data Lifecycle Management Processes Different…and Who Cares?

Are Data Lifecycle Management (DLM) and Information Lifecycle Management (ILM) just fancy terms for the exact same thing – namely, data management? Will understanding these terms actually impact your data strategy in any meaningful way? Will knowing this distinction affect your business at all? Recently, we began a series of posts on data strategy by…
Read more

Why is SQL Server slow?

Why is My SQL Server Slow? 14 Common Reasons

“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

sql server data storage strategy

10 Data Storage Considerations for Growing Companies

As the business world becomes more and more data-centric, what questions does your growing company need to ask about its data storage? Recently, we began a series of posts on data strategy by asking whether your company data is an asset or a utility. In this post, we will look at 10 key data storage…
Read more

SQL Server heartbeat

Why is it important to monitor SQL Server?

SQL Server is good. You install it, give it some databases to manage, and let it do it’s thing. When queries come in, it figures out how to resolve them. If it needs some statistics, it creates them. If the database is running out of space, it’ll grow the data file for you. Automatically. And…
Read more