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.
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.
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]
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]
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 baseline picture and help you find potential loopholes. Once you have the report and management approval, you can start locking down where necessary. [SQL-Server-Performance.com]
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] Read more…
Data Base Independent Data Access Layer
Introduction
In this Article I want to describe you how we can approach a data base free data layer. Read more…
Automatic Sql Server Backup Utility Using sqlserveragent
Introduction
It is a sample C# (VS2005) application forAutomatic Sql server Backup Utility using sqlserveragent. I have usedSQL-DMO dll. This article will show you how to create a automaticbackup in Sql server 2000. Read more…
Tdo -Typed Data Object 2.0
Tdo is the acronym of Typed Data Object and ismade up of a NET assembly (Tdo.dll) and a source code generator(TdoCodeGenerator.exe). The source code generator produces a collectionof derived classes (VB.NET/C#.NET) that extends the base classes withinthe Tdo.dll assembly, all under the Object Oriented model.Every generated class has the scope "to represent" an object of yourSQL database, where object are Tables, Views, Stored Procedures,Functions. According to this model, every table or view, etc, isconsidered as an object itself that shows its attributes and operations(that are properties and methods).That means that the single cell of a table or the single parameter of astored procedure will be seen as object itself. All these classes areenclosed in a hierarchically macro-object as a representation of theentire database – the TdoHelper class.More ahead we'll see all the possible operations that we can execute onour database (select, insert, update, delete, stored procedure, etc)that will be called from the present methods within the TdoHelper classobjects. Read more…
Sorting Data Tables
Here is the simplest way to sort and filter data in a DataTable. Use DataView. Read more…
