Site sponsored by:

Home

Articles

Forums

Tips

Quiz

FAQ's

Blogs

Software

Books

About Us

RSS Feeds

Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

Write for Us

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

Latest FAQ's

ALTER TABLE SWITCH statement failed because the object '%.*ls' is not ...

ALTER TABLE SWITCH statement failed because column '%.*ls' at ordinal %d ...

ALTER TABLE SWITCH statement failed because table '%.*ls' has %d columns ...

SQL Server Reporting Server (SSRS) service is failing to start ...

SQL Server Developer Articles

New Features in Visual Studio 2008
As a DBA it is important that you are able to talk to the development teams that you work with about development practices. This article provides an overview of some of the new features that have been introduced in Visual Studio 2008

New Data Types in SQL Server 2008 Part 3
This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.

New Data Types in SQL Server 2008 Part 2
SQL Server 2008 has introduced several new data types. This article discusses how the new HierarchyID data type can be used to implement hierarchies.

SQL Server 2008 New DATETIME DataTypes
SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.

CLR Integration in SQL Server 2005
The integrated CLR allows SQL Server developers to write stored procedures and user defined data-types using a .NET language such as C# or VB

Working with XML Data in SQL Server 2005
SQL Server 2005 features vastly improved handling of XML data, this article explores the methods of handling and storing XML data in SQL Server 2005.

Notification Services in SQL Server 2005
SQL Server Notification Services is used for developing and deploying applications that generate and send notifications. The notification can be scheduled on a weekly, daily, or hourly basis and sent to a wide variety of devices, such as a subscriber's cell phone, personal digital assistant (PDA), Windows Messenger or e-mail account. By S. Srivathsani.

Using Service Broker to Communicate With Other Database Servers
Service Broker is a distributed messaging framework, or MSMQ (Microsoft Message Queue), in SQL Server 2005. Using this new feature, you will be able to add reliable, scalable, asynchronous functionality to your database applications.

Encrypting Your Valuable Data With SQL Server 2005: Part 2
After reading Part I in this series, you will have an architectural understanding of data encryption in SQL Server 2005. In this article, we will discuss the real implementation of it.

Exposing API Server Cursors
In this article, I will expose the API server cursor by providing a brief overview of what an API server cursor is, explaining how to identify when a distributed query is utilizing an API server cursor, and giving an example of a simple distributed query that eliminates the usage of the API server cursor.

Encrypting Your Valuable Data With SQL Server 2005: Part 1
In SQL Server 2005, security has improved for authentication, authorization, and encryption. Encryption is so much improved that it is almost a new feature in SQL Server 2005.

Handling Cursor-Friendly Problems in T-SQL: Running Totals Example
A typical "cursor friendly" problem is one where the data set returned contains at least one column whose value depends on column values from one or more previous rows of the same row set. Even when a data set based solution exists, it is hard to build a query that is more efficient than a cursor based solution.

An Interview with Bill Hamilton, Author of the Book 'Programming SQL Server 2005'
Programming SQL Server 2005 is very different from programming SQL Server 2000. The introduction of CLR routines (the ability to program database objects such as stored procedures, functions, and triggers using the .NET Framework), the introduction of a new database management class library in SQL Server Management Objects (SMO) that replaces DMO, and extensive new functionality and enhancements to existing functionality.

SQL Server 2005 Security and the Microsoft Developer's Security Resource Kit
An Interview with Mark Brown, Senior Marketing Manager, US-Developer Business and Marketing Organization, Microsoft.

Winning T-SQL Games from the Red Gate Software-Sponsored January 2006 Contest
This past January, Red Gate Software sponsored a T-SQL contest. The goal was to write a game in T-SQL that was fun to play.

Top 10 Must Have Features in O/R Mapping Tools
Object-to-relational (O/R) mapping tools are becoming more popular each day and people are realizing the productivity gain they provide to developers.

Exception Handling in SQL Server 2000 and 2005
Learn the basics of SQL Server exception handling, along with learning a little about new exception handling features in SQL Server 2005.

Working With Temporary Views Using Common Table Expression in SQL Server 2005
This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I'll also give you some tips on how to use them in a not so obvious context.

Ownership Chains in SQL Server 2005
Learn how ownership chains are handled in SQL Server 2005.

Demystifying the SQL Server DATETIME Datatype
Learn how to take full advantage of the SQL Server DATETIME datatype.

Sending SQL Server Notifications with CDOSYS
Learn how to get e-mail notifications from SQL Server without using MAPI.

Implementing Triggers in SQL Server 2000
Learn the basics of using triggers in SQL Server 2000.

How to Delete SQL Server Database Duplicate Rows from a Table Using a Specified Column List and No Temp Tables
Learn how to delete duplicate rows in a SQL Server database table. By David VanDeSompele.

Advanced SQL Server DATE and DATETIME Handling
Learn how to get real milliseconds from SQL Server.

Views in SQL Server
A view is a virtual table that consists of columns from one or more tables & Once you have defined a view, you can reference it like any other table in a database.

An Introduction to SQL Server Scalar UDFs
Learn the basics about using scalar UDFs in SQL Server 2000.

SQL Server Techniques for Creating a Web Reporting Page — Part 3
Learn how to create a web page to extract data from a SQL Server database, with pivot/transpose.

SQL Server Techniques for Creating a Web Reporting Page -- Part 2
Learn how to create a web page to extract data from a SQL Server database, with SORT and TOTAL functionality.

Return Values: Getting Something Back from Your SQL Server Stored Procedures
Learn how to get return values from SQL Server stored procedures.

SQL Server Techniques for Creating a Web Reporting Page — Part 1
Learn how to create a web page to extract data from a SQL Server database.

How to Search for Date and Time Values Using Microsoft SQL Server 2000
Learn how to perform searches on date and time columns. Includes some tips on performance.

How to Write SQL to Dynamically Script Mass INSERT Statement Scripts
Learn how to write Transact-SQL code to dynamically script mass INSERT statement scripts.

How to Fix the Problem When ADO Truncates Milliseconds from SQL Server Datetime Columns
Learn how to return milliseconds from the SQL Server datetime data type using ADO and VB.

Fun with Numbers in Transact-SQL Queries
Strengthen your Transact-SQL skills by learning how to take advantage of derived tables to perform useful tasks.

Create and Manage SQL Server Stored Procedures using Transact-SQL
Learn the basics of how to create and manage SQL Server stored procedures.

Who Needs SQL Server Change Management?
Many DBAs give little thought to SQL Server change management, but is this really a good idea?

Using One-Way Functions to Protect Sensitive Information in SQL Server Databases
Find out how one-way functions can be used to help protect sensitive data in your SQL Server databases.

An Exclusive Interview with Author Fernando Guerrero On How to Get the Most of ADO.NET and SQL Server
Learn from an expert on how to get the best performance out of ADO.NET and SQL Server. Fernando is the author of Microsoft SQL Server 2000 Programming by Example.

Useful Undocumented SQL Server Extended Stored Procedures
SQL Server offers many features that are not documented in the Books Online. Here are some of the undocumented extended stored procedures found in SQL Server 7.0 and 2000.

SQL Server TSQL Coding Conventions, Best Practices, and Programming Guidelines
Learn the basics of writing top-notch Transact-SQL code.