Article Topics

All Articles

Peformance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...

Latest FAQ's

SSIS Lookups are Case Sensitive

Convert Number to Words in SSRS

After installing SP2 on SQL Server 2005 x64, when trying to ...

Remote Name Could not be Resolved in SQL Server Reporting Services ...

Latest SQL Server Developer Articles

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.

View all articles for this topic