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!

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.

Programming Microsoft SQL Server 2012

Programming Microsoft SQL Server 2012

Author: Leonard G. Lobel, Andrew J. Brust Format: Paperback / softback Release Date: 15/07/2012

Your essential guide to key programming features in Microsoft SQL Server 2012 Take your database programming skills to a new level-and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you're an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications. Discover how to: Build and deploy databases using the SQL Server Data Tools IDE Query and manipulate complex data with powerful Transact-SQL enhancements Integrate non-relational features, including native file streaming and geospatial data types Consume data with Microsoft ADO.NET, LINQ, and Entity Framework Deliver data using Windows Communication Foundation (WCF) Data Services and WCF RIA Services Move your database to the cloud with Windows Azure SQL Database Develop Windows Phone cloud applications using SQL Data Sync Use SQL Server BI components, including xVelocity in-memory technologies

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.

SQL Server Backup and Restore

SQL Server Backup and Restore

Author: Shawn McGehee Format: Paperback / softback Release Date: 14/05/2012

The duties and responsibilitie:s of a Database Administrator (DBA) make for long and dynamically changing list, ranging from offering query tuning advice, to cutting stored procedures, all the way through to system process design and implementation for high availability. A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. This means that if a database, for whatever reason, gets corrupted, dropped, or otherwise becomes unusable, then it is the DBA's responsibility to restore that database to the state it was in before the problem occurred, or as close as is possible. Of course, this doesn't mean that a DBA is required to restore a database each and every day, just that if disaster does strike the DBA must be prepared to deal with it, regardless of when or why it occurs. If a DBA isn't prepared, and significant data is lost, or databases become unavailable to end users for long periods of time, then that DBA probably won't be in their job for too long. This is why a good, and tested, SQL Server backup and restore plan must be on the top of every administrative DBA's list of tasks. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated and you'll also want to build in some checks that, for example, alert the responsible DBA immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building your own automated solution will take a lot of work, but we do offer some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs.