Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: <ul>
<li>Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.</li> <li>Handle transactions, concurrency, and error handling.</li> <li>Efficiently use temporary objects, including temporary tables, table variables, and table expressions.</li> <li>Evaluate when to use set-based programming techniques and when to use cursors.</li> <li>Work with dynamic SQL in an efficient and secure manner.</li> <li>Treat date- and time-related data in a robust manner.</li> <li>Develop CLR user-defined types and learn about temporal support in the relational model.</li> <li>Use XML and XQuery and implement a dynamic schema solution.</li> <li>Work with spatial data using the new geometry and geography types and spatial indexes.</li> <li>Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.</li> <li>Use Service Broker for controlled asynchronous processing in database applications.</li> </ul>
All the book’s code samples will be available for download from the companion Web site.

Inside Microsoft® SQL Server® 2008: T-SQL Programming (Pro-developer)

Computers & Technology

Greg Low

Itzik Ben-Gan

Dejan Sarka

Roger Wolter

Ed Katibah

Isaac Kunen

Operating Systems

Microsoft Press

In The Rational Guide to Building Technical User Communities, Microsoft Regional Director Greg Low explains how the most successful user communities succeed by focusing on people rather than technology. He explains the differences between user groups and user communities, how to ensure productive meetings, the importance of using speakers effectively, and tried and true methods of recruiting and growing a group. He also discusses the best uses for technology, remote and online communities, and the ins and outs of group dynamics. Advanced topics include legal and financial issues, such as funding, insurance, and sponsors.

The Rational Guide to Building Technical User Communities (Rational Guides)

History & Culture

Rational Press

SQL Server 2005 revolutionized the way database applications are written. Microsoft's Common Language Runtime (CLR) allows you to create development and execution environments with integrated languages and libraries. In The Rational Guide to Microsoft® SQL Server 2005 CLR, Microsoft Regional Director Greg Low clearly and concisely explains everything you need to know to use the CLR features of SQL Server 2005, including user-defined functions, stored procedures, triggers, user-defined aggregates, user-defined types, security, and performance. Advanced topics include deployment, advanced integration topics, tips for developers, and advice for DBAs. Technical Accuracy is assured by Bob Beauchemin, Microsoft SQL Server MVP and Director of Developer Skills, SQLskills.

The Rational Guide to SQL Server CLR Integration (Rational Guides)

Software

See the best price to sell, buy, or rent books by Greg Low. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Greg Low