When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.
2009-06-19
2,401 reads
Learn to enable the FILESTREAM feature in SQL Server 2008 and configure your database to support it.
2009-06-18
2,817 reads
Recent installments of our series dedicated to the most prominent features of SQL Server 2005 Express Edition have discussed its reporting capabilities. This article illustrates another approach to generating reports, relying on the Report Server Project template, which offers a considerably wider range of flexibility than its wizard-driven counterpart does.
2009-06-18
2,151 reads
This document describes common data warehouse implementation strategies and proposes an effective hub-and-spoke architecture using a massively parallel processing system with multiple instances of SQL Server databases.
2009-06-17
2,159 reads
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
2009-06-17
2,531 reads
Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.
2009-06-16
4,808 reads
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
2009-06-15
4,321 reads
This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
2009-06-12
2,093 reads
Authenticators are additional data that gets encrypted along with the data to be stored in an encrypted manner. When it comes to decrypt the data, if the right authenticator isn't specified, SQL Server doesn't return the data in the decrypted form. Rather, a NULL value is returned, just as if the wrong key was used.
2009-06-12
2,384 reads
I would like to translate some of the Transact-SQL scripts that I use every day, starting with the simple ones like retrieving a list of databases and their properties for auditing purposes.
2009-06-11
3,960 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers