SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach [NOOK Book]

Overview



SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get ...

See more details below
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$27.49
BN.com price
(Save 42%)$47.99 List Price

Overview



SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed.

  • Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
  • Current: Newly updated for SQL Server 2012
  • Comprehensive: Covers all common T-SQL problem domains




What you’ll learn


  • Create databases, tables, and indexes


  • Query and manipulate data


  • Store and manage XML inside the database


  • Move business logic into the database


  • Resolve common performance problems.


  • Build reports that matter to your business.


  • Perform common backup and recovery tasks.




Who this book is for


SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back–end database, and the database administrators who create, manage, and secure those databases.



Table of Contents


  1. Getting Started with SELECT


  2. Elementary Programming


  3. Nulls and Other Pitfalls


  4. Combining Data from Multiple Tables


  5. Grouping and Summarizing


  6. Advanced SELECT Techniques


  7. Query Techniques for Reporting


  8. Inserting, Updating, Deleting


  9. Working with Strings


  10. Working with Dates


  11. Working with Numbers


  12. Transactions, Locking, Blocking, Deadlocking


  13. Managing Tables


  14. Managing Views


  15. Managing Indexes


  16. Managing Large Tables


  17. Stored Procedures


  18. User-Defined Functions


  19. Triggers


  20. Error Handling


  21. Query Performance


  22. Hints


  23. Index Tuning and Statistics


  24. XML


  25. Files, Filegroups, and Integrity


  26. Backup


  27. Recovery


  28. Principals and Users


  29. Securables and Permissions


  30. Objects and Dependencies




Read More Show Less

Product Details

  • ISBN-13: 9781430242017
  • Publisher: Apress
  • Publication date: 9/17/2012
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 3
  • Pages: 808
  • Sales rank: 890,730
  • File size: 8 MB

Meet the Author

Jason Brimhall is first and foremost a family man. He has 15+ yrs experience in IT and has worked with SQL Server starting with SQL Server 6.5. He has worked for both large and small companies in varied industries. He has experience in performance tuning, high transaction environments, large environments, and VLDBs. He is currently a DB Architect and an MCITP for SQL 2008. Jason regularly volunteers for PASS and is the VP of the Las Vegas User Group (SSSOLV). You can read more more from Jason on his blog at: http://jasonbrimhall.info.
David Dye is a Microsoft SQL Server MVP, instructor, and author specializing in relational database management systems, business intelligence systems, reporting solutions, and Microsoft SharePoint. For the past 9 years David's expertise has been focused on Microsoft SQL Server development and administration. His work has earned him recognition as: a Microsoft MVP in 2009 and 2010, a moderator for the Microsoft Developer Network for SQL Server forums, Innovator of the Year runner-up in 2009 by SQL Server Magazine, and in the Training Associates Technical Trainer Spotlight in April 2011. David currently serves as a technical reviewer and co-author with APress Publishing in the SQL Server 2012 series, and as an author with Packt Publishing.
Andy Roberts is a Data Platform Technology Specialist for Microsoft in the Northeast district. Prior to that, Andy spent 12 years as a consultant for Microsoft Consulting Services. As a consultant, Andy assisted customers in implementing mission critical OLTP and DW/BI solutions on SQL Server. Andy wore many hats as a consultant, including that of application developer, solution architect, mentor to development teams, mentor to DBAs, BI lead, SCRUM Master, and guy-that-knows-a-bunch-of-stuff-about-Microsoft. When not basking behind the glow of his laptop, Andy enjoys volunteering as a ski instructor at Maine Adaptive Sports. He also enjoys golfing, biking, and trying to reverse engineer his three month old son, Max.
Wayne Sheffield started working with databases in the late 1980's, using DBase, Foxbase and FoxPro. With over twenty years in the IT industry, he has worked with SQL Server database systems (starting from version 6.5) since the late 1990's in various development and administration roles, with an emphasis in performance tuning. He is author of several articles at www.sqlservercentral.com, and enjoys sharing his knowledge by presenting at various SQL PASS events and posting on his blog at http://blog.waynesheffield.com/wayne.
Jonathan Gennick is an Apress Assistant Editorial Director with responsibility for database topics. He is line-leader for Apress's Oracle and SQL Server lines. He publishes carefully-chosen database books of a general nature. He maintains a keen interest in books across all lines that touch upon relational databases.

In his last position before changing to an editorial career, Jonathan rose to the rank of Manager at KPMG Consulting (now BearingPoint). There he delivered development and system integration services to state and local government clients. He was noted for his troubleshooting skills and his ability to smoothly navigate the oft-turbulant waters between client management, consultants from competing firms, and client technical personnel. Jonathan has experience with languages and technologies such as Mumps, COBOL, Powerbuilder, various assembly-languages. He is well-known and widely-published for his expertise with Oracle Database and the attendendant languages SQL and PL/SQL.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)