SQL Server Articles

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 more

SQL Server 2008 R2 Multi-server Administration

One 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 more

Windows Phone 7 – SQL Server

Microsoft’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 more

SQL Server Security Audit (Part 3) – Operating System Level Audit

An essential part of auditing SQL Server is ensuring the Operating System the SQL Server isntance runs on is secure. [SQL-Server-Performance.com]

Read more

SQL Server Security Audit (Part 2) – Database Level Audit

The series on securing SQL Server looks at securing the actual database. [SQL-Server-Performance.com]

Read more

SQL Server Security Audit (Part 1) – Server Level Audit

Although 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 more

Auditing In SQL Server 2008

Auditing 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