SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

SQL Server Backup Performance with Imceda LiteSpeed

Introduction For the last several weeks, I have been working with Imceda (now Quest Software) on improving the performance of LiteSpeed for SQL Server, particularly for high–end storage systems. This report represents my assessment of LiteSpeed performance characteristics. I am an independent consultant, so this report does not represent the views or claims of Quest. […]

Create Local Cubes with Microsoft SQL Server 2000 and Microsoft Office

As the number of people who are conducting business from outside the corporate workplace increases, the need to access corporate databases using devices such as mobile phones and portable computers also increases. The corporate world invests considerable resources in capturing volumes of data. Online Analytical Processing (OLAP) is a popular technology used to collate and […]

SQL Server 2000 & 2005 Clustering

Chapter 1 – Basics of SQL Server ClusteringIf your AAA critical SQL server faces a memory board failure, how long will be the outage? How much will this cost your business in productivity and data availability to the users? Being a SQL Server DBA can be demanding and stressful, as the success of your application […]

How to Identify Non-Active SQL Server Indexes

As a DBA, it is our regular task to review our databases and see if there is any way we can boost their performance. While adding new or better indexes to a database is one of the primary ways we can boost performance, an often forgotten way to help boost database performance is to remove […]

Eliminación de Índices no Usados

En la tarea habitual de aumentar la performance de una base de datos, creamos índices de acuerdo a las necesidades. La creación de índices se realiza tanto analizando los planes de ejecución o utilizando el ITW (Asistente para la Optimizacion de Indices). Una vez que la base de datos se encuentra estabilizada en su performance, […]

Monitor Your Database Servers with DTS, Part 1: Backup SLA Report

It is difficult to keep track of critical things like backup, space, and error logs in large environments. Different database management tools from third party vendors can help you monitor these but the tools are normally expensive. There is an inexpensive alternative. In this series of three articles, I will describe how to monitor a […]

Transferencia de las Estadísticas de SQL Server de una Base de Datos a otra

Nota del traductor: Algunas palabras se han mantenido en inglés por no disponer en castellano de una traducción apropiada, en el lenguaje computacional. Esas palabras son las siguientes con su traducción literal en algunas de ellas y con un pseudo castellano en otras. Constraints: Restricciones, limitaciones, Obligaciones Default: Por defecto, a falta de… Setting: Ajustes, […]

MANTENIMIENTO: Reorganización de Índices – Actualización de Estadísticas

Dentro de las tareas habituales de Mantenimiento de las Bases de Datos se encuentran aquellas destinadas al control y respaldo de las mismas como ser: Control de Integridad, Chequeo de Consistencia, Copias de Seguridad o Compactación de las bases. Pero también es necesario ejecutar trabajos de mantenimiento cuyos objetivos sean el de mantener la performance […]

SQL PASS Community Summit vs. SQL Server Connections Conference

In the past, I have attended SQL PASS five times, and this past week, I attended my first SQL Connections conference. For those who have not been able to attend both, I thought I would describe some of the differences I found between the two. Two Different Focuses The SQL PASS Community Summit focuses on […]

Implementing the SQL Server Multiple Publishers and Central Subscriber Replication Topology

Introduction This article describes how to set up the following topology: where P1 and P2 are two different publishers and S is the central subscriber. This is a fairly typical requirement, e.g. the subscriber might be a head office and the publishers are each separate branch of a company. In this arrangement, data often needs […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |