LoveReading

Becoming a member of the LoveReading community is free.

No catches, no fine print just unadulterated book loving, with your favourite books saved to your own digital bookshelf.

New members get entered into our monthly draw to win £100 to spend in your local bookshop Plus lots lots more…

Find out more

SQL Server / MS SQL

See below for a selection of the latest books from SQL Server / MS SQL category. Presented with a red border are the SQL Server / MS SQL books that have been lovingly read and reviewed by the experts at Lovereading. With expert reading recommendations made by people with a passion for books and some unique features Lovereading will help you find great SQL Server / MS SQL books and those from many more genres to read that will keep you inspired and entertained. And it's all free!

DB2 SQL Tuning Tips for z/OS Developers

DB2 SQL Tuning Tips for z/OS Developers

Author: Tony Andrews Format: Paperback / softback Release Date: 15/10/2012

The Definitive Solutions-Oriented Guide to IBM (R) DB2 (R) for z/OS (R): Now Fully Updated for Both v9 and v10! The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance. DB2 tuning expert Tony Andrews ( Tony the Tuner ) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you're writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability. This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application. Coverage includes Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs Providing many programming and SQL coding examples Establishing standards and guidelines that lead to high-performance SQL Implementing time-efficient code walkthroughs to ensure that your standards are followed Focusing on the small number of SQL statements that consume the most resources Identifying simple solutions that deliver the most sizable benefits Optimizing performance by rewriting query predicates more efficiently Providing a better understanding of SQL optimization and Runstat statistics Recognizing opportunities to tweak your code more effectively than the Optimizer Optimizing SQL code with COBOL applications Efficiently checking for the existence of data, rows, or tables Using Runstats' newest capabilities to consistently optimize paths to data

Microsoft SQL Server 2012 Security Cookbook

Microsoft SQL Server 2012 Security Cookbook

Author: Rudi Bruchez Format: Paperback / softback Release Date: 25/09/2012

Each recipe comprises step-by-step instructions followed by an analysis of what was done in each task and other useful information. The book is designed so that you can read it chapter by chapter, or look at the list of recipes and refer to them in no particular order. Each example comes with its expected output to make your learning even easier thus enabling you to successfully secure your SQL Server 2012 database. This book is for SQL Server administrators, developers, and consultants who want to secure their SQL Server database with cutting edge techniques for data and code encryption, user authentication and authorization, protection against brute force attacks, denial-of-service attacks, and SQL Injection, securing business intelligence, and more. Working knowledge of SQL Server is expected.

Pro SQL Server 2012 BI Solutions

Pro SQL Server 2012 BI Solutions

Author: Randal Root, Caryn Mason Format: Paperback / softback Release Date: 17/09/2012

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete! Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments. Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need. Provides recipes for multiple business intelligence scenarios Progresses from simple to advanced projects using several examples Shows Microsoft SQL Server technology used to complete real-world business intelligence projects

Microsoft SQL Server 2012 Integration Services

Microsoft SQL Server 2012 Integration Services

Author: Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding Format: Paperback / softback Release Date: 15/09/2012

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle complex data integration scenarios more efficiently-and acquire the skills you need to build comprehensive solutions. Discover how to: Use SSIS to extract, transform, and load data from multiple data sources Apply best practices to optimize package and project configuration and deployment Manage security settings in the SSISDB catalog and control package access Work with SSIS data quality features to profile, cleanse, and increase reliability Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps Load data incrementally to capture an easily consumable stream of insert, update, and delete activity

SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns

Author: Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss Format: Paperback / softback Release Date: 04/09/2012

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services. Takes you through solutions to several common data integration challenges Demonstrates new features in SQL Server 2012 Integration Services Teaches SSIS using practical examples

Microsoft SQL Server 2012 Bible

Microsoft SQL Server 2012 Bible

Author: Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla Format: Paperback / softback Release Date: 10/08/2012

Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects. * Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers * Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications * Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services * Demonstrates tasks both graphically and in SQL code to enhance your learning * Provides source code from the companion web site, which you can use as a basis for your own projects * Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.

Microsoft SQL Server 2012 Performance Tuning Cookbook

Microsoft SQL Server 2012 Performance Tuning Cookbook

Author: Ritesh R. Shah, Bihag Thaker Format: Paperback / softback Release Date: 26/07/2012

This book has individual recipes and you can read it from cover to cover or dip into any recipe and get solution to a specific issue. Every recipe is based on a script/procedure explained with step-by-step instructions and screenshots. Concepts are illustrated for better understanding of why one solution performs better than another. SQL Server 2012 Performance Tuning Cookbook is aimed at SQL Server Database Developers, DBAs, and Database Architects who are working in any capacity to achieve optimal performance. However, basic knowledge of SQL Server is expected, but professionals who want to get hands-on with performance tuning and have not worked on tuning the SQL Server for performance will find this book helpful.

SQL Server 2012 Query Performance Tuning

SQL Server 2012 Query Performance Tuning

Author: Grant Fritchey, Sajal Dam Format: Paperback / softback Release Date: 20/06/2012

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. It provides the tools you need to approach your queries with performance in mind. SQL Server 2012 Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You'll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You'll learn to recognize bottlenecks and defuse them before the phone rings. You'll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server 2012 Query Performance Tuning into practice today. Establish performance baselines and monitor against them Troubleshoot and eliminate bottlenecks that frustrate users Plan ahead to achieve the right level of performance

SQL Injection Attacks and Defense

SQL Injection Attacks and Defense

Author: Justin Clarke-Salt Format: Paperback / softback Release Date: 18/06/2012

SQL Injection Attacks and Defense, First Edition: Winner of the Best Book Bejtlich Read Award SQL injection is probably the number one problem for any server-side application, and this book unequaled in its coverage. -Richard Bejtlich, Tao Security blog SQL injection represents one of the most dangerous and well-known, yet misunderstood, security vulnerabilities on the Internet, largely because there is no central repository of information available for penetration testers, IT security consultants and practitioners, and web/software developers to turn to for help. SQL Injection Attacks and Defense, Second Edition is the only book devoted exclusively to this long-established but recently growing threat. This is the definitive resource for understanding, finding, exploiting, and defending against this increasingly popular and particularly destructive type of Internet-based attack. SQL Injection Attacks and Defense, Second Edition includes all the currently known information about these attacks and significant insight from its team of SQL injection experts, who tell you about: Understanding SQL Injection - Understand what it is and how it works Find, confirm and automate SQL injection discovery Tips and tricks for finding SQL injection within code Create exploits for using SQL injection Design apps to avoid the dangers these attacks SQL injection on different databases SQL injection on different technologies SQL injection testing techniques Case Studies

Visualizing Data with Microsoft Power View

Visualizing Data with Microsoft Power View

Author: Brian Larson, Mark Davis, Dan English, Paul Purington Format: Book Release Date: 16/06/2012

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Create and Distribute High-impact Microsoft Power View Reports Explore data in insightful new ways and transform the way your enterprise uses BI with help from this expert guide. Visualizing Data with Microsoft Power View shows how to effectively analyze and communicate complex information through elegant interactive reports. Discover how to create and populate tables, connect to databases, build multi-view reports in real-time, and publish your results to end-users. BI Semantic Model development and administration are also covered in this comprehensive volume. Launch Power View and navigate its user interface Load BI from SQL databases and external sources Build basic and multi-level table visualizations Develop card-, chart-, and matrix-based reports Incorporate auto-sizing, filtering, tiling, and slicing Securely distribute reports via SharePoint and PowerPivot Add functionality with hierarchies, perspectives, and KPIs Design, deploy, and support custom BI Semantic Models DVD includes: More than four hours of video demonstrations A complete package of sample data-a Power View-optimized BI Semantic Model, a SQL Server database, and additional underlying data sources Comprehensive instructions for creating a learning environment, including Windows Server, SharePoint Server 2010, and Microsoft SQL Server 2012 with PowerPivot and Reporting Services SharePoint integration Six completed Power View Reports that include multiple views, visualizations, and performance dashboards BI Semantic Model with advanced extensions using DAX functions, including date and time, mathematical, logical, informational, and statistical functions

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook

Author: Reza Rad, Pedro Perfeito Format: Paperback / softback Release Date: 24/05/2012

This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations. If you are an SQL database administrator or developer looking to explore all the aspects of SSIS and need to use SSIS in the data transfer parts of systems, then this is the best guide for you. Basic understanding of working with SQL Server Integration Services is required.

Professional Microsoft SQL Server 2012 Reporting Services

Professional Microsoft SQL Server 2012 Reporting Services

Author: Paul Turley, Robert M. Bruckner, Thiago Silva, Ken Withee Format: Paperback / softback Release Date: 18/05/2012

A must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors. * Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012 * Explains Reporting Services architecture and BI fundamentals * Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient * Discusses semantic model design, Report Builder, Crescent, and more * Targets business analysts and report designers as well as BI solution developers Professional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.