SQL Server Developer

Working with XML Data in SQL Server 2005

XML is one of the data types in SQL Server 2005.It is considered as one of the significant changes introduced in SQL Server 2005.In the previous versions, storing and retrieving XML data were possible but it was not as easy and extensible as it is in the current version. The XML data type lets the […]

CLR Integration in SQL Server 2005

The Common Language Runtime (CLR) of the .Net framework is integrated into SQL Server 2005. The CLR supplies managed code with services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support. CLR provides various functions and services required for program execution, including just-in-time (JIT) compilation, allocating and managing memory, […]

Notification Services in SQL Server 2005

SQL Server Notification Services is used for developing and deploying applications that generate and send notifications. Notifications are personalized messages sent to a device that subscribes to them. A subscription defines the preference of the subscriber for a specific type of event. For example, a subscriber can specify a preference to the notification application such […]

Using Service Broker to Communicate With Other Database Servers

In this article, we are going to discuss the Service Broker, another new feature in SQL Server 2005. In simple terms, 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. After generating a Service Master Key (SMK) and a Database Master Key (DMK), you have to build encryption keys to encrypt your data. If […]

Exposing API Server Cursors

Introduction Recently, I was informed that a process which executed a distributed query was running longer than was originally anticipated.  Initially, I identified that the distributed query was allocating cpu, but the memory and disk io values were increasing at a much slower pace.  In fact, so slowly that the memory and disk io values […]

Encrypting Your Valuable Data With SQL Server 2005: Part 1

Security has become extremely important in today’s fiercely completive business environment. Industry standards require you to implement firm techniques to secure your data. 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. Encryption is the last […]

Handling Cursor-Friendly Problems in T-SQL: Running Totals Example

By design, the SQL programming language works with data sets, so it is not surprising that for most problems, row by row processing is not nearly as efficient as data set processing. There is a class of problems, however, that is much easier to solve using cursors. A typical “cursor friendly” problem is one where […]

SQL Server 2005 Security and the Microsoft Developer’s Security Resource Kit

What is the Microsoft Developer’s Security Resource Kit? The Microsoft Developer Security Resource Kit is a single resource that provides security-related development guidance. Its contents include best practices, how-to guides, code samples and sample applications, training, and white papers on security topics. This must-have DVD is available free for a limited time — you pay […]

An Interview with Bill Hamilton, Author of the Book ‘Programming SQL Server 2005’

To begin with, tell us about yourself. I’ve been working for the last fifteen years in the software industry and have worked creating both COTS software and developing custom software solutions for companies in the manufacturing, retail, financial services, and professional services verticals. Over the last four years, I’ve been architecting enterprise solutions — both […]