SQL Antipatterns
Avoiding the Pitfalls of Database Programming
Price | $24.35 - $25.11
|
Rating | |
Author | Bill Karwin |
Publisher | The Pragmatic Programmers |
Published | 2010 |
Pages | 352 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1934356557 |
ISBN-13 | 9781934356555 |
Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns the most common errors he's identified in those thousands of requests for help.
Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What's more, it shows you what's behind these fixes, so you'll learn a lot about relational databases along the way.
- Bill Karwin (2 books)
4 5 894
Similar Books
by Bill Karwin
SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - -solutions that look right but become increasingly painful to work with as you u...
Price: $47.95 | Publisher: The Pragmatic Programmers | Release: 2022
by Stephen B. Morris
As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, an...
Price: $79.99 | Publisher: O'Reilly Media | Release: 2023
SQL Queries for Mere Mortals, 4th Edition
by John L. Viescas
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.Step by step, Viescas guides you through creating re...
Price: $18.13 | Publisher: Addison-Wesley | Release: 2018
SQL Server 2019 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni
Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...
Price: $48.15 | Publisher: Microsoft Press | Release: 2020
A Developer's Guide to Data Modeling for SQL Server
by Eric Johnson, Joshua Jones
Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...
Price: $6.15 | Publisher: Addison-Wesley | Release: 2008
Beginning Microsoft SQL Server 2008 Administration
by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation a...
Price: $5.17 | Publisher: Wrox | Release: 2009
Professional SQL Server 2008 Internals and Troubleshooting
by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort
When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together - and simplifies - practical internal information concerning SQL Server along with troubles...
Price: $5.49 | Publisher: Wrox | Release: 2010
SQL All-in-One For Dummies, 2nd Edition
by Allen G. Taylor
SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into ea...
Price: $7.49 | Publisher: Wiley | Release: 2011