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

Inside Microsoft SQL Server 2008: T-SQL Programming (Pro-Developer), 9780735626027 (0735626022), Microsoft Press, 2009

This book and its prequel—Inside Microsoft SQL Server 2008: T-SQL Querying—cover advanced T-SQL querying, query tuning, and programming in Microsoft SQL Server 2008. They are designed for experienced programmers and DBAs who need to write and optimize code in SQL Server 2008. For brevity, I’ll refer to the books as T-SQL Querying and T-SQL Programming, or just as these books.

Those who read the SQL Server 2005 edition of the books will find plenty of new material covering new subjects, new features, and enhancements in SQL Server 2008, plus revisions and new insights about the existing subjects.

These books focus on practical common problems, discussing several approaches to tackle each. You will be introduced to many polished techniques that will enhance your toolbox and coding vocabulary, allowing you to provide efficient solutions in a natural manner.

These books unveil the power of set-based querying, and they explain why it’s usually superior to procedural programming with cursors and the like. At the same time, they teach you how to identify the few scenarios where cursor-based solutions are superior to set-based ones.

The prequel to this book—T-SQL Querying—focuses on set-based querying and query tuning, and I recommend that you read it first. This book—T-SQL Programming—focuses on procedural programming and assumes that you read the first book or have sufficient querying background.

T-SQL Querying starts with five chapters that lay the foundation of logical and physical query processing required to gain the most from the rest of the chapters in both books.

The first chapter covers logical query processing. It describes in detail the logical phases involved in processing queries, the unique aspects of SQL querying, and the special mind-set you need to adopt to program in a relational, set-oriented environment.

The second chapter covers set theory and predicate logic—the strong mathematical foundations upon which the relational model is built. Understanding these foundations will give you better insights into the model and the language. This chapter was written by Steve Kass, who was also the main technical editor of these books. Steve has a unique combination of strengths in mathematics, computer science, SQL, and English that make him the ideal author for this subject.

Comments

Amazing Books

C for Engineers and Scientists: An Introduction to Programming With ANSI C

West Publishing Company, 1993

This text introduces the C programming language using a range of engineering and science applications in the examples and exercises. The book assumes no programming experience and is suitable for an introduction to programming course (using C instead of Fortran or Pascal). Structured programming principles are introduced early and used throughout....

XNA 2.0 Game Programming Recipes: A Problem-Solution Approach (Books for Professionals by Professionals)

Apress, 2008

Join the game development revolution today! XNA greatly simplifies the development of your own games, lowering the barrier for programmers to get into game development. In XNA, you can start coding your games from the very start, a true revelation compared to other game programming environments. XNA doesn't sacrifice power for this ease of use - it...

Hands-On Neural Networks with Keras: Design and create neural networks using deep learning and artificial intelligence principles

Packt Publishing, 2019

Your one-stop guide to learning and implementing artificial neural networks with Keras effectively

Key Features

Design and create neural network architectures on different domains using Keras

Integrate neural network models in your applications using this highly practical...

Kafka: The Definitive Guide: Real-time data and stream processing at scale

O'Reilly, 2016

Learn how to take full advantage of Apache Kafka, the distributed, publish-subscribe queue for handling real-time data feeds. With this comprehensive book, you’ll understand how Kafka works and how it’s designed. Authors Neha Narkhede, Gwen Shapira, and Todd Palino show you how to deploy production Kafka clusters; secure,...

Software Process and Product Measurement: International Conference, IWSMMENSURA 2007, Palma de Mallorca, Spain, November 5-8, 2007, Revised Papers

Springer, 2008

This book constitutes the thoroughly refereed post-proceedings of the International Workshop on Software Measurement, IWSM-Mensura 2007, held in Palma de Mallorca, Spain, in November 2007.

The 16 revised full papers presented were carefully reviewed and selected for inclusion in the book. The papers deal with aspects of software measurement...

Three-Dimensional Model Analysis and Processing (Advanced Topics in Science and Technology in China)

Springer, 2011

With the increasing popularization of the Internet, together with the rapid development of 3D scanning technologies and modeling tools, 3D model databases have become more and more common in fields such as biology, chemistry, archaeology and geography. People can distribute their own 3D works over the Internet, search and download 3D...