C# Help – C# Tutorials and Resources

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.

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.

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

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

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

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 implemented, [...]

Introduction
In this Article I want to describe you how we can approach a data base free data layer.
It doesn't mean that we will not use anydatabase, but we will try to incorporate any data source with our datalayer. This kind of problem happen when we are not sure about eitherdata source/Database will be Oracle, SQLServer, [...]

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.
This code should work on any PC use VB.NET and installed SQL Server 2000 (any edition or Client Components for SQL Server 2000.
SQLDMO [...]

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

Here is the simplest way to sort and filter data in a DataTable. Use DataView.
Note: This demo connects to an SQL Server anduses the Northwind database. You need to modify the App.config to makethis demo work.
Here iss the C# sample.
using System;using System.Data;using System.Data.SqlClient;using System.Configuration;
namespace SortingDataTables{ /// <summary> /// Summary description for Class1. /// </summary> class [...]