Latest SQL News

SSRS Reporting Services & Architecture

SQL Server Reporting Services [SSRS] is Reporting system based on SQL Server. It provides a set of tools & services enabling us to create, manage, and deliver reports for ...

Error 2533 in corrupt SQL Server 2008 database

A page is the most basic unit of storage in SQL Server. The space allocated to a data (.mdf) file is divided into contiguous pages from 0 to n. Every page starts with a 96-byte header ...

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