Latest SQL News

What is SQL Azure Database?

This video provides an overview of Microsoft SQL Azure, a part of the Windows Azure Platform, Microsoft’s cloud computing offering. It explains why you should care about SQL ...

SQL Server Index Maintenance Performance Tuning for Large Tables

Problem When using transactional replication to replicate data in a one way topology from a publisher to a read-only subscriber(s) there is no need to manage identity ranges. However, ...

How to Use Policy Based Management to Implement Database Settings

Introduction Database Administrators have always had a tough time to ensuring that all the SQL Servers administered by them are configured according to the policies and standards of ...

How to add a Column to a SQL Server Table

Adding a column to a table is  common task for  DBAs. You can add a column to a table which is a nullable column or which has default values. But are these two operations ...

How to correlate SQL Server Profiler with Performance Monitor

Both Performance Monitor and SQL Server Profiler provide valuable information about your server. However, if you combine the data from the two sources, then this correlated information ...

SQL Scripts Manager with PowerShell

The free tool SQL Scripts Manager (SSM) does much more than just run SQL Scripts. It will also run IronPython and PowerShell scripts. By using PowerShell, you’ll be able to run SMO ...

Maintenance Performance Tuning for Large Tables in SQL Server

It is nothing really new that indexes have their right to exist in SQL Server. It is also nothing really new, that these indexes need to be maintained every now and then, even though ...

Monitor Transactional Replication – The Distribution Queue

Monitoring the distribution queue is an important link in the chain of transactions delivery over a replicated topology. A chain that includes the log reader agent scanning the published ...

Encryption at Column-Level in SQL Server

Beginning with SQL Server 2005, column-level encryption and decryption capabilities where made available within the database.  This provides a compelling solution for situations ...

Natural Key Verses Surrogate Key in SQL Server

When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the ...