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.)

Concrete Mathematics: A Foundation for Computer Science (2nd Edition)
Concrete Mathematics: A Foundation for Computer Science (2nd Edition)

This book, updated and improved, introduces the mathematics that support advanced computer programming and the analysis of algorithms. The book's primary aim is to provide a solid and relevant base of mathematical skills. It is an indispensable text and reference for computer scientists and serious programmers in virtually every...

Software Configuration Management Using Vesta
Software Configuration Management Using Vesta

This monograph addresses two core problems in developing large software projects: versioning and building. In order to develop and evolve large software code bases, software engineers need to understand the central role of automated, scalable software configuration management (SCM). Using the well-known Vesta system (an open-source SCM system...

Oracle Digital Assistant: A Guide to Enterprise-Grade Chatbots
Oracle Digital Assistant: A Guide to Enterprise-Grade Chatbots
Use this book as an on-ramp to the development of enterprise-grade chatbots and digital assistants. It is based on real-life experience and explains everything you need to know to start building your own digital assistant (DA) using Oracle technologies. You will become familiar with the concepts involved in DA development from both a...

iPAQ for Dummies
iPAQ for Dummies
Get organized with iPAQ’s power – use Word, Excel, and more

Put your office, your music, e-mail, even the Web in your pocket!

All that power in your pocket might be a little overwhelming, if you didn’t have this friendly book to help you use it! From choosing the iPAQ model that’s right for you to surfing...

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Microsoft SQL Server Analysis Services ("Analysis Services" from here on) is now ten years old, a mature product proven in thousands of enterprise-level deployments around the world. Starting from a point where few people knew it existed and where those that did were often suspicious of it, it has grown to be the most widely deployed OLAP...
Statistical Analysis with R
Statistical Analysis with R

This is a practical, step by step guide that will help you to quickly become proficient in the data analysis using R. The book is packed with clear examples, screenshots, and code to carry on your data analysis without any hurdle. If you are a data analyst, business or information technology professional, student, educator, researcher, or...

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