When I talk with companies, whether they be community banks or healthcare companies, about their SQL Server environments, I find that most aren’t intentionally and proactively managing their SQL Server environment–they’re reacting to it. Things run fine until they don’t. Then, suddenly, IT teams are dealing with performance issues, failed backups, or questions from auditors…
Read more
When a SQL Server database is the backbone of your application, its design will have a huge impact on the application’s performance. While many developers just view the database as a container for storing data, the truth is that a well-designed database is critical to your application’s speed, reliability, and ability to scale with your…
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
The world of data is rapidly evolving, and the demand for skilled data professionals has continued to rise. But who are these data professionals? Those of us in the field have been asked many times about the nature of what we do. Students and prospective career changers, hiring managers, business partners, and prospective clients all…
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
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
“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
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
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
Recent Comments