Category: Data Strategy

How to Encrypt Sensitive Text in SQL Server with ENCRYPTBYPASSPHRASE

How to Encrypt Sensitive Text in SQL Server with ENCRYPTBYPASSPHRASE

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

Which Data Role Do You Need?

What’s in a Job Title? Understanding Changing Data Roles

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

Data Governance in Action: 4 Challenges for Small and Mid-Sized Businesses (SMBs)

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

archiving data in sql server

Archiving and Deletion Strategy…KonMari for Data Management?

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

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

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

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

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 data utility or asset

How to Justify IT Spend: Is Company Data an Asset or a Utility?

How do you justify investment in IT? That’s a commonly asked question for companies whose core business area is not technology. For many, it is a challenge to justify investment in technology. The primary purpose of IT, as some companies see it, is enabling the operation of the business. It’s not driving revenue. Every business,…
Read more