Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

In the age of big data, efficiently managing relational databases, particularly SQL Server, may be the single most important issue facing a growing number of CIOs and data center managers. Throughout ...

Enterprise data warehouses, or EDWs, are unified databases for all historical data across an enterprise, optimized for analytics. These days, organizations implementing data warehouses often consider ...

The whole world has fallen in love with the value that data can bring. The work that must be done to unlock that value is far less popular. As Thomas Edison said, "Opportunity is missed by most people ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

Ingesting large volumes of disparate data can yield a rich source of information — but it's also a recipe for data chaos. Use these tips to improve data quality as your data lake grows. Image: ...