Programming Microsoft SQL Server 2005

by Andrew J. Brust, Stephen Forte

Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions.

Discover how to:


Program views, stored procedures, triggers, and functions using T-SQL Work with the new XML data type and XQuery method Automate common administration and maintenance tasks Debug databases, reports, and objects using Microsoft Visual Studio 2005 Write transactional code and implement local and distributed transactions Develop mobile data applications using SQL Server 2005 Everywhere Edition Use SQL Server Notification Services to develop applications that deliver event-driven notifications to users Use business intelligence tools, such as SQL Server Reporting Services and OLAP and data mining components PLUS—Get C# code samples on the Web

600 pages, Paperback

First published June 28, 2006

About the author

Andrew is Senior Director, Market Strategy and Intelligence at Big Data software company Datameer. He’s also ZDNet’s original Big Data blogger, a conference co-chair of Visual Studio Live! and author of several Big Data and NoSQL courses on Pluralsight. Andrew’s been a Microsoft Regional Director since 2002 and a Microsoft Most Valuable Professional since 2004. He also served on Microsoft's Business Intelligence Partner Advisory Council (BI PAC) from 2005 to 2011.

Andrew has developed in Microsoft Visual Basic, .NET and SQL Server from their respective first versions, and has focused on Microsoft BI technologies since the late 1990s.

Andrew began his career as a professional programmer while still in college, working for the City of New York, Department of Parks and Recreation. After graduation, Andrew served as Computer Systems Director at New York City’s Department of Cultural Affairs.

Moving on to two small consulting firms, then global tech firm Cap Gemini, Andrew helped build an array of computing systems, including the Bank of New York’s first Windows-based client management system, which went on to win best financial application in the Windows World Open competition, sponsored by Microsoft and Computerworld, in 1993.

After Cap Gemini, Andrew became an independent consultant working at Bankers Trust, then founded his own company, Progressive Systems Consulting.

After running Progressive Systems for 10 years, Andrew sold it to a 35-person Microsoft-focused consulting firm called Citigate Hudson, later renamed twentysix New York. At twentysix, Andrew became chief salesperson, winning roughly 10 million dollars worth of business during his tenure from 2004 – 2010.

After six years, Andrew moved on to establish his own firm, Blue Badge Insights, focused on helping consulting companies and Independent Software Vendors (ISVs) navigate the Microsoft partner channel.

Andrew was invited to become ZDNet’s new Big Data correspondent soon after founding Blue Badge Insights. Andrew also became a freelance analyst, focused on Big Data, for Gigaom Research, and was eventually recruited to become its first Research Director dedicated to Big Data.

In 2015, Andrew joined Big Data analytics software company Datameer, as Senior Director, Product Strategy and Intelligence. He also returned to writing about Big Data for ZDNet.