Pro T-SQL 2019

Toward Speed, Scalability, and Standardization for SQL Server Developers



Bookstore > Books > Pro T-SQL 2019

Price$24.62 - $52.72
Rating
AuthorElizabeth Noble
PublisherApress
Published2020
Pages406
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484255895
ISBN-139781484255896
EBook Hardcover Paperback

Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies.
Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward.

- Choose correct data types and database objects when designing T-SQL
- Write T-SQL that searches data efficiently and uses hardware effectively
- Implement source control and testing methods to streamline the deployment process
- Design T-SQL that can be enhanced or modified with less effort
- Plan for long-term data management and storage





Similar Books


Pro T-SQL 2012 Programmer's Guide, 3rd Edition

Pro T-SQL 2012 Programmer's Guide, 3rd Edition

by Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles

Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2012

Pro T-SQL Programmer's Guide, 4th Edition

Pro T-SQL Programmer's Guide, 4th Edition

by Miguel Cebollero, Michael Coles, Jay Natarajan

Pro T-SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert...

Price:  $45.64  |  Publisher:  Apress  |  Release:  2015

Program the Internet of Things with Swift for iOS

Program the Internet of Things with Swift for iOS

by Ahmed Bakir, Manny de la Torriente, Gheorghe Chesler

Program the Internet of Things with Swift and iOS is a detailed tutorial that will teach you how to build apps using Apple's native APIs for the Internet of Things, including the Apple Watch, HomeKit, and Apple Pay. This is the second book by Ahmed Bakir (author of Beginning iOS Media App Development) and his team at devAtelier LLC, who h...

Price:  $36.49  |  Publisher:  Apress  |  Release:  2015

Pro TBB

Pro TBB

by Michael Voss, Rafael Asenjo, James Reinders

This open access book is a modern guide for all C++ programmers to learn Threading Building Blocks (TBB). Written by TBB and parallel programming experts, this book reflects their collective decades of experience in developing and teaching parallel programming with TBB, offering their insights in an approachable manner. Throughout the boo...

Price:  $32.36  |  Publisher:  Apress  |  Release:  2019

Refactoring Legacy T-SQL for Improved Performance

Refactoring Legacy T-SQL for Improved Performance

by Lisa Bohm

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQ...

Price:  $23.99  |  Publisher:  Apress  |  Release:  2020

Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

by Ahmad Osama

As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It's important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2018

T-SQL Window Functions, 2nd Edition

T-SQL Window Functions, 2nd Edition

by Itzik Ben-Gan

Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unpr...

Price:  $26.99  |  Publisher:  Microsoft Press  |  Release:  2019

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

by Paul Turley, Riccardo Muti, Christopher Finlan

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful re...

Price:  $36.22  |  Publisher:  Wrox  |  Release:  2017