SQL Server Developer

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 […]

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. Below are the links to the three games that won. When you click on a link, you will be brought to a new page with the T-SQL code you need to […]

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. Yet, many people do not know enough about O/R mapping to consider using these tools and many others are weary of using any code generators (including O/R mapping tools). In this article, I will […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |