Pro T-SQL 2019
Toward Speed, Scalability, and Standardization for SQL Server Developers
|Price||$24.62 - $52.72
|Format||Paper book / ebook (PDF)|
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
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
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
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
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
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
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
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
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