RSS Feeds

Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

SQL Azure

Developer

General DBA

ASP.NET / ADO.NET

SQL Azure

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...

SQL Server Destination remote server error

Setting Up Data And Log Files For SQL Server

Will Check Constraints Improve Database Performance?

SQL Server Audit Articles

Auditing in SQL Server 2008
Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.

SQL Server Security Audit (Part 3) - Operating System Level Audit
The final part of the Security Audit series examines how to secure the Windows Server operating system.

SQL Server Security Audit (Part 1) - Server Level Audit
The first of this three part series on SQL Server Security Auditing focuses on the SQL Server itself and addressing any of its security vulnerabilities.

Change Tracking in SQL Server 2008
Change tracking is a lightweight solution which provides an efficient change tracking mechanism for applications.

Automate Audit Requests
In this article TJay Belt describes a process to help respond to audit requests in a timely manner

Audit Data Modifications
In this article new author TJay Belt describes a solution to Audit Data Modifications

SQL Server 2005 Database Options and Configuration Performance Audit Checklist
As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.

SQL Server 2005 Server Configuration Performance Audit Checklist Part 2
Part 2 of configuring SQL Server settings.

SQL Server 2005 Server Configuration Performance Audit Checklist : Part 1
Examine the key performance related SQL Server configuration settings.

SQL Server 2005 Performance Audit : Operating System Configuration Performance Checklist
Squeeze more performance out of SQL Server by optimizing Windows Server.

SQL Server 2005 Performance Audit : SQL Server Hardware Configuration Checklist
Start off your Audit by examining the performance of the hardware SQL Server runs on.

SQL Server 2005 Performance Audit : Introduction
Get started on SQL Server 2005 auditing with this introduction to the series.

DDL Triggers in SQL Server 2005
DDL Triggers are key improvement in SQL Server auditing, allowing tracking of events such as the creation of a new table, database or user.

New Index Locking Granularity in SQL Server 2005 Gives You More Options
While most DBAs are familiar with how locking works with tables, few DBAs are familiar with how SQL Server 2005 applies locking to indexes. That's right, indexes, just like tables, are subject to locking. And as most DBAs already know, inappropriate locking (in tables or indexes) can negatively affect the performance of SQL Server. By Brad M. McGehee.

How to Perform a SQL Server Performance Audit
Introduction to conducting a SQL Server Performance Audit

How to Best Implement a SQL Server Performance Audit
Best practices on how to best implement a SQL Server Performance Audit

SQL Server Query Performance Audit Checklist
Indentify queries than run longer than they should, and use up more than their fare share of SQL Server resources.

Job Performance Audit Checklist
Jobs that run poorly-designed code, or run at bad times, can put a significant strain on SQL Server. Because of this, it is important to include your SQL Servers' jobs as part of your performance audit

Database Configuration Settings Performance Checklist
As part of a performance audit there is a requirement to examine each database located on theserver and examine some basic database settings

SQL Server 2000 Configuration Performance Checklist
This article examines the performance-related SQL Server configuration settings.

Index Performance Audit Checklist
This article tackles the difficult task of auditing single and multiple indexes

Operating System Performance Optimization
Focusing on the base operating system, and how to optimize it in order to get the best performance out of SQL Server.

Hardware Performance Optimization
Looking at each of the major components of a SQL Server's hardware and examining what can be done to help maximize the performance of your hardware.

Identify SQL Server Hardware Bottlenecks
The best place to start your SQL Server performance audit is to begin with the Performance Monitor (System Monitor).