Latest SQL News

SQL Server Stored Procedures

Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks. Why should you ...

Mistakes When Building and Maintaining a Database

Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. ...

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

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services.SQL Server provided geospatial data with SQL Server 2008 and you may have noticed (or ...

SQL Server Transaction Isolation Models

Normally, it’s best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the ACID model ...

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 are similar ...

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