Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)

Buy

This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.

About the Authors

Itzik Ben-Gan is a mentor and founder of Solid Quality Learning. A Microsoft SQL Server MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning, and Programming. Itzik is the author of several books on Microsoft SQL Server. He has written many articles for SQL Server Magazine, as well as articles and white papers for MSDN. Itzik's speaking engagements include Tech Ed, DevWeek, various SQL user groups around the world, PASS, SQL Server Magazine Connections, and Solid Quality Learning's events, to name a few.

Since 1992, Itzik has been involved in many projects covering various database and computer systems—related technologies. In addition to helping customers with their pressing needs, fixing their problems, optimizing their databases, teaching, and mentoring, Itzik has helped developers and database administrators shift to a relational/set-based mindset, improving both the performance of their code and its maintainability. Itzik's main expertise is T-SQL Querying, Query Tuning, Programming, and Internals, but he's proficient in other database areas as well. In 1999, Itzik founded the Israeli SQL Server and OLAP User Group, and he has been managing it since then.

Dejan Sarka—MCP (Microsoft Certified Professional), MCDBA (Microsoft Certified Database Administrator), MCT (Microsoft Certified Trainer), SQL Server MVP, Solid Quality Learning Mentor—is a trainer and consultant working for many Certified Partners for Learning Solutions (CPLS) centers and development companies in Slovenia and other countries. In addition to providing professional training, he continuously works on online transaction processing (OLTP), OLAP, and Data Mining projects, especially at the design stage. He is a regular speaker at some of the most important international conferences, such as TechEd, PASS, and MCT. He is also indispensable at regional Microsoft TechNet meetings, the NT Conference, which is the largest Microsoft conference in Central and Eastern Europe, and other events. He is the founder of the Slovenian SQL Server Users Group. Dejan Sarka also developed two courses for Solid Quality Learning: Data Modeling Essentials and Data Mining with SQL Server 2005.

Roger Wolter has close to 30 years' experience in the computer industry, the last 7 years with Microsoft. He is currently a program manager on the SQL Server team specializing in SQL Server Service Broker and SQL Server Express. His projects at Microsoft have included COM+, SQLXML, the Soap Toolkit, SQL Server Service Broker, and SQL Express.

Steve Kass is Associate Professor of Mathematics and Computer Science at Drew University in Madison, New Jersey. Steve graduated from Pomona College and holds a Ph.D. in Mathematics from the University of Wisconsin—Madison. He is also a Microsoft SQL Server MVP.

Lubor Kollar is a group program manager for SQL Server at Microsoft. His team led the development of key enhancements to the relational engine, including some of the T-SQL enhancements in SQL Server 2005.

(HTML tags aren't allowed.)

Fault-Tolerant Systems
Fault-Tolerant Systems
There are many applications in which the reliability of the overall system must be far higher than the reliability of its individual components. In such cases, designers devise mechanisms and architectures that allow the system to either completely mask the effects of a component failure or recover from it so quickly that the application is not...
All the Mathematics You Missed: But Need to Know for Graduate School
All the Mathematics You Missed: But Need to Know for Graduate School
Math is Exciting. We are living in the greatest age of mathematics ever seen. In the 1930s, there were some people who feared that the rising abstractions of the early twentieth century would either lead to mathematicians working on sterile, silly intellectual exercises or to mathematics splitting into sharply distinct...
Raspberry Pi User Guide
Raspberry Pi User Guide

The essential guide to getting started with the Raspberry Pi ®

The Raspberry Pi has been a success beyond the dream of its creators. Their goal, to encourage a new generation of computer programmers who understand how computers work, is well under way.

Raspberry Pi User Guide 2e is the newest edition of the runaway...


Distributed Database Systems (International Computer Science Series)
Distributed Database Systems (International Computer Science Series)

For many types of organization, the ultimate information handling aspiration is to have an integrated database system so that common files can be consulted by various sections of the organization, in an efficient and effective manner. However, database systems are not just pertinent to organizations or even large sections of enterprises. Many...

Emerging Trends And Challenges in Information Technology Management
Emerging Trends And Challenges in Information Technology Management
Many theoretical development practices exist for creating multimedia systems. Most of these development models are orientated towards building traditional information systems, where the requirements are usually well understood. Multimedia systems, like the industry itself, are evolving rapidly, therefore new tools and techniques are constantly...
Introduction to Data Compression, Third Edition (Morgan Kaufmann Series in Multimedia Information and Systems)
Introduction to Data Compression, Third Edition (Morgan Kaufmann Series in Multimedia Information and Systems)

The second edition of Introduction to Data Compression builds on the features that made the first the logical choice-for practitioners who need a comprehensive guide to compression for all types of multimedia and instructors who want to equip their students with solid foundations in these increasingly important and diverse...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy