Master Data Services – MDS in SQL Server 2008 R2
Master Data Services (MDS) is a component in SQL 2008 R2 that allows storing of Master Data in a central repository called the Master Data Services Database.
Read moreMaster Data Services (MDS) is a component in SQL 2008 R2 that allows storing of Master Data in a central repository called the Master Data Services Database.
Read moreOne of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.
Read moreMicrosoft’s recent demo of Windows Phone Series 7 OS was very impressive but developer details were thin on the ground– SQL Server will likely be the database in some form… [WinPhonePro.com]
Read moreAn essential part of auditing SQL Server is ensuring the Operating System the SQL Server isntance runs on is secure. [SQL-Server-Performance.com]
Read moreThe series on securing SQL Server looks at securing the actual database. [SQL-Server-Performance.com]
Read moreAlthough security is a major component of database administration, it is sometimes overlooked in favour of convenience. As a developer, you need to know how vulnerable your SQL Servers are before you can start securing them. To get this answer, you will first need to conduct a “security audit”. This audit should give you a [...]
Read moreAuditing is the monitoring and recording all user actions on a database. You can base auditing on individual actions, such as database backup, change of user logins, insert etc. or on combination of factors. [SQL-Server-Performance.com] Though auditing has become a popular buzzword, many DBAs and developers still do not appreciate the requirement for auditing. Properly [...]
Read more