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 ...

The October release of Azure Data Studio (formerly called SQL Operations Studio) includes preview support for SQL Server 2019 and more. Azure Data Studio, which was introduced last year as SQL ...

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 ...

Many of the principles that apply to manufacturing supply chains can also be applied to data management. The real challenge is figuring out how to efficiently coordinate all the sources so the ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

Note: This article is excerpted from Chapter 7, "Creating a Shared Database," of Microsoft .NET and J2EE Interoperability Toolkit [Microsoft Press, 2003, ISBN: 0735619220]. It has been edited for ...