Welcome!

Microsoft Cloud Authors: Kevin Benedict, Pat Romanski, Liz McMillan, Lori MacVittie, Elizabeth White

Related Topics: Microsoft Cloud

Microsoft Cloud: Article

.NET Book Review: Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET

.NET Book Review: Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET

With the release of a major new version of SQL Server, it's incumbent on developers to take time to refresh and enhance their knowledge of this new version of T-SQL (Transact SQL) and stored procedure programming. The challenge is to find a good book that will cover the highlights but not give you a hernia in the process. Dejan Sunderic's book fits this bill.

The book consists of 21 chapters and three appendices. The first 10 chapters provide a nice review of current and new features of the T-SQL found in SQL Server 2005. There is a review of the new SQL Server environment as well as a discussion of stored procedure design concepts. Each chapter from Chapter 4 through 10 covers an important T-SQL concept such as functions and error handling. You might be very interested in Chapters 11 through 14 because the author walks you through numerous examples of how to develop stored procedures using .NET CLR (Common Language Runtime).

In the final chapters, he covers a lot of material and important topics such as advanced stored procedure programming and using source code control inside Visual Studio to protect your stored procedures. He also covers issues of security. If you've never used a debugger on stored procedures, then you're going to want to read the chapter on debugging, which also contains a clever "poor man's debugger."

I'll admit though that there are one or two areas that disappointed me a bit. For instance, Mr. Sunderic uses his own SQL Server database "Asset5" for many of the examples. I really didn't feel that it added much to the discussion and I would have preferred he used the "AdventureWorks" database instead since that's the new standard demo database that Microsoft provides for SQL Server 2005. Also, while most of his examples are really good, the one on common table expressions didn't really show the power behind this new feature. In fact, when he discusses the row number function, he doesn't touch on the important topic of removing duplicate records in SQL Server. With a combination of common table expressions and the row number function, it's become extremely easy to do this.

The book is a good review of existing T-SQL language concepts and does a good job of covering new features. The book is peppered with Mr. Sunderic's useful insights and observations. If you're looking to find out what's new in T-SQL and stored procedure programming, you'll find this book quite helpful.

Developers Note
To run stored procedures using CLR in SQL Server 2005 you'll need to run the this script against your database:

ALTER DATABASE <database> SET TRUSTWORTHY ON
go
sp_configure 'clr enabled', 1
go
reconfigure
go

More Stories By Steven Mandel

Steven Mandel has worked in the IT industry for over 15 years designing databases using Microsoft Access and SQL Server. He has developed Web and Windows applications using VB.NET and has written numerous articles and reviews about ASP.NET and VB.NET.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


IoT & Smart Cities Stories
DXWorldEXPO LLC announced today that Telecom Reseller has been named "Media Sponsor" of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. Telecom Reseller reports on Unified Communications, UCaaS, BPaaS for enterprise and SMBs. They report extensively on both customer premises based solutions such as IP-PBX as well as cloud based and hosted platforms.
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructure solutions deliver the adaptive architecture needed to manage this new data reality. Machine learning algorithms can better anticipate data storms and automate resources to support surges, including fully scalable GPU-c...
A valuable conference experience generates new contacts, sales leads, potential strategic partners and potential investors; helps gather competitive intelligence and even provides inspiration for new products and services. Conference Guru works with conference organizers to pass great deals to great conferences, helping you discover new conferences and increase your return on investment.
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use of real time applications accelerate, legacy networks are no longer able to architecturally support cloud adoption and deliver the performance and security required by highly distributed enterprises. These outdated solutions have become more costly and complicated to implement, install, manage, and maintain.SD-WAN offers unlimited capabilities for accessing the benefits of the cloud and Internet. ...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
SYS-CON Events announced today that Silicon India has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Published in Silicon Valley, Silicon India magazine is the premiere platform for CIOs to discuss their innovative enterprise solutions and allows IT vendors to learn about new solutions that can help grow their business.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...