Posts and articles about Databases
How do you find inconsistent data?
Hi all, it's time to go through our data lake, and I'm dreading it because it's everything but small. I am tasked with looking for and correcting inconsistencie...
What would be some sources of data for aggregation?
Hello everyone, I'm new here. I need to aggregate data, and I was just wondering what sources you used for this? Also, is there any specific software you use to...
How do I create an enterprise search?
Hi everyone, my company has built up a data pool, and I want to increase productivity and make it easier for the employees to access and find information. Do I ...
How do I ensure data from multiple sources is compatible?
Hi everyone. I'm setting up a database for a client, and I have to use data from multiple different data sources from other companies. How do I ensure this data...
How do you avoid having duplicate data in a database?
We have been having tons of duplicate data, and it's starting to become a pain. Is there anything we can put in place to prevent a duplicate from being saved?
What is SQL server security level?
Hi, what is the purpose of SQL security, and how do you know its level?
What makes a SharePoint column searchable?
Hi, our company uses SharePoint for enterprise searches, and I manage that data. I've been adding metadata columns into SharePoint this past week, only to find ...
What are the risks of dumping data into a data lake?
Good afternoon everyone. Having a data pool within our company that is accessible to all employees would be a good idea. But while everything has its pros, I am...
Is there an open-source enterprise search engine?
Does an open source enterprise search engine exist, or is it only for private data within companies?