Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
1. | SQL Server Concurrency: Locking, Blocking and Row Versioning By: Kalen Delaney Publisher: Red Gate Books Publication Date: 11-SEP-2012 Insert Date: 21-MAY-2013 Slots: 1.0 | Overview: SQL Server Concurrency: Locking, Blocking and Row Versioning
If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one process wait, sacrificing concurrency and performance, in order that in order that all can succeed, without destroying data integrity. Your application can have world-class indexes and queries, but they won't help you if you can't get your data, because another application has it locked. That's why...
|
2. | The Art of SQL Server FILESTREAM By: Jacob Sebastian; Sven Aelterman Publisher: Red Gate Books Publication Date: 31-AUG-2012 Insert Date: 21-MAY-2013 Slots: 1.0 | Overview: The Art of SQL Server FILESTREAM
Storing large object data in the database offers a number of benefits, but introduces performance challenges. Conversely, storing large object data in the file system has overriding performance advantages, but fails to offer some of the basic data integrity, security and manageability features that are required for business data, and which SQL Server provides. Up to now, most people have adopted file system storage by necessity, and often struggled to overcome the associated shortcomings. This is exactly where SQL Server's new FILESTREAM feature fits in. We hope this book will get you...
|
3. | Microsoft® SQL Server® 2012 Reporting Services By: Stacia Misner Publisher: Microsoft Press Publication Date: 24-APR-2013 Insert Date: 02-MAY-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2012 Reporting Services Deliver interactive business intelligence reports using SQL Server 2012 Reporting Services, and help facilitate real-time decision making throughout the enterprise. SQL Server expert Stacia Misner shows you in detail how to design, manage, and access custom reports that capture data from multiple sources....
|
4. | Microsoft® SQL Server® 2012 Step by Step By: Patrick LeBlanc Publisher: Microsoft Press Publication Date: 25-FEB-2013 Insert Date: 19-MAR-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2012 Step by Step Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems....
|
5. | SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools By: Adam Aspin Publisher: Apress Publication Date: 16-NOV-2012 Insert Date: 19-FEB-2013 Slots: 1.0 | Overview: SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to...
|
6. | Microsoft SQL Server 2012 Bible By: Adam Jorgensen; Jorge Segarra; Patrick LeBlanc; Jose Chinchilla; Aaron Nelson Publisher: John Wiley & Sons Publication Date: 28-AUG-2012 Insert Date: 19-FEB-2013 Slots: 1.0 | Overview: Microsoft SQL Server 2012 Bible
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...
|
7. | Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer By: Brian Knight; Devin Knight; Mike Davis; Wayne Snyder Publisher: Wrox Publication Date: 28-NOV-2012 Insert Date: 24-JAN-2013 Slots: 1.0 | Overview: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project.
Guides novice database...
|
8. | Microsoft SQL Server 2012 - Überblick über Konfiguration, Administration, Programmierung By: Markus Raatz; Jörg Knuth; Ruprecht Dröge Publisher: Microsoft Press Deutschland Publication Date: 09-JAN-2013 Insert Date: 18-JAN-2013 Slots: 1.0 | Overview: Microsoft SQL Server 2012 - Überblick über Konfiguration, Administration, Programmierung Microsoft SQL Server 2012 ist ein mächtiges Datenbanksystem, das mit vielen anderen Anwendungen in den Bereichen Business Intelligence, Office, Reporting und Cloud-Computing verwoben werden kann. Damit Sie nicht den Überblick verlieren, haben Markus Raatz...
|
9. | Introducing Microsoft® SQL Server® 2012 By: Ross Mistry; Stacia Misner Publisher: Microsoft Press Publication Date: 31-MAR-2012 Insert Date: 15-JAN-2013 Slots: 1.0 | Overview: Introducing Microsoft® SQL Server® 2012 Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers....
|
10. | Microsoft SQL Server 2012 - Das Handbuch By: Thomas Joos Publisher: Microsoft Press Deutschland Publication Date: 17-AUG-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Microsoft SQL Server 2012 - Das Handbuch Dieses Buch ist der umfassende Leitfaden zum Arbeiten mit der cloud-fähigen Informationsplattform und Datenbank-Unternehmenslösung von Microsoft....
|
11. | Microsoft SQL Server 2012 - Ratgeber für Administratoren By: William R. Stanek Publisher: Microsoft Press Deutschland Publication Date: 16-JUL-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Microsoft SQL Server 2012 - Ratgeber für Administratoren Der kompakte Ratgeber für die tägliche Arbeit des Datenbankadministrators in Unternehmen jeder Größe. Es unterstützt Sie effizient bei der Verwaltung von Microsoft SQL Server 2012....
|
12. | Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2012 By: Robert Panther Publisher: Microsoft Press Deutschland Publication Date: 27-JUN-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2012 Diese Buch vermittelt sowohl die Datenbankgrundlagen als auch das Programmierwissen, das Sie benötigen, um professionell mit SQL Server 2012 zu arbeiten....
|
13. | Programming Microsoft® SQL Server® 2012 By: Leonard Lobel; Andrew Brust Publisher: Microsoft Press Publication Date: 24-JUL-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Programming 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....
|
14. | Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions By: Itzik Ben-Gan Publisher: Microsoft Press Publication Date: 24-APR-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks....
|
15. | Microsoft® SQL Server® 2012 Pocket Consultant By: William R. Stanek Publisher: Microsoft Press Publication Date: 03-FEB-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2012 Pocket Consultant This pocket-sized guide delivers ready answers for administering SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists that help you save time and get the job done!...
|
16. | Microsoft® SQL Server® 2012 Integration Services By: Wee-Hyong Tok; Rakesh Parida; Matt Masson; Xiaoning Ding; Kaarthik Sivashanmugam Publisher: Microsoft Press Publication Date: 10-SEP-2012 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2012 Integration Services 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...
|
17. | Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model By: Marco Russo; Alberto Ferrari; Chris Webb Publisher: Microsoft Press Publication Date: 19-JUL-2012 Insert Date: 12-JAN-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model Analyze tabular data using the BI Semantic Model (BISM) in Microsoft® SQL Server® 2012 Analysis Services—and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you’ll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on book shows you how the tabular model’s in-memory database enables you to perform rapid analytics—whether you’re a professional BI developer new to Analysis Services or familiar with its multidimensional model....
|
18. | Training Kit (Exam 70-462): Administering Microsoft® SQL Server® 2012 Databases By: Orin Thomas; Peter Ward; boB Taylor Publisher: Microsoft Press Publication Date: 09-JUL-2012 Insert Date: 12-JAN-2013 Slots: 1.0 | Overview: Training Kit (Exam 70-462): Administering Microsoft® SQL Server® 2012 Databases This 2-in-1 Training Kit delivers preparation plus practice for Microsoft Exam 70-462. Ace your exam prep—and enhance your job skills—with hands-on lessons, practice tests, and other resources....
|
19. | Professional Microsoft SQL Server 2012 Reporting Services By: Paul Turley; Robert M. Bruckner; Thiago Silva; Ken Withee; Grant Paisley Publisher: Wrox Publication Date: 05-JUN-2012 Insert Date: 09-JAN-2013 Slots: 1.0 | Overview: Professional Microsoft SQL Server 2012 Reporting Services
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...
|
20. | Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft® SQL Server® 2012 By: Dejan Sarka; Matija Lah; Grega Jerkic Publisher: Microsoft Press Publication Date: 14-DEC-2012 Insert Date: 14-DEC-2012 Slots: 1.0 | Overview: Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Ace your preparation for Microsoft® Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options....
|