Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
21. | Professional SQL Server 2012 Internals and Troubleshooting By: Christian Bolton; James Rowland-Jones; Glenn Berry; Justin Langford; Gavin Payne; Amit Banerjee Publisher: Wrox Publication Date: 06-NOV-2012 Insert Date: 23-NOV-2012 Slots: 1.0 | Overview: Professional SQL Server 2012 Internals and Troubleshooting
Hands-on troubleshooting methods on the most recent release of SQL Server
The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any...
|
22. | Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX Publisher: Wrox Publication Date: 02-OCT-2012 Insert Date: 21-NOV-2012 Slots: 1.0 | Overview: Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
Understand Microsoft's dramatically updated new release of its premier toolset for business intelligence
The first major update to Microsoft's state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed book from key members of the product's development team? If you're a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsoft's new SQL Server 2012 Analysis Services and related tools.
Discover how to...
|
23. | Microsoft SQL Server 2012 Master Data Services 2/E By: Tyler Graham Publisher: McGraw-Hill Publication Date: 09-OCT-2012 Insert Date: 20-NOV-2012 Slots: 1.0 | Overview: Microsoft SQL Server 2012 Master Data Services 2/E
Deploy and Maintain an Integrated MDS Architecture Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012Master Data Services, Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide.
...
|
24. | Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 By: Itzik Ben-Gan; Dejan Sarka; Ron Talmage Publisher: Microsoft Press Publication Date: 05-DEC-2012 Insert Date: 20-NOV-2012 Slots: 1.0 | Overview: Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 Ace your preparation for Microsoft® Certification Exam 70-461 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 practice tests on CD—featuring multiple, customizable testing options....
|
25. | By: Bradley Ball; TJay Belt; Glenn Berry; Jes Borland; Carlos Bossy; Louis Davidson; Ben DeBow; Grant Fritchey; Jonathan Gardner; Jesper Johansen; Jeremy Lowell; Wendy Pastrick; Kellyn Pot'vin; Mladen Prajdić; Herve Roggero; Chris Shaw; Gail Shaw; Jason Strate Publisher: Apress Publication Date: 31-OCT-2012 Insert Date: 09-NOV-2012 Slots: 1.0 | Overview: Pro SQL Server 2012 Practices
Pro SQL Server 2012 Practices Edition is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching into release management, auditing, and other issues—the book helps you deliver the most value for your company's investment in Microsoft's flagship database system
Goes beyond the manual to cover good techniques and best practices
Delivers knowledge usually gained only by hard experience
Focuses...
|
26. | By: Orin Thomas; Peter Ward; boB Taylor Publisher: Microsoft Press Deutschland Publication Date: 02-NOV-2012 Insert Date: 08-NOV-2012 Slots: 1.0 | Erlernen Sie das Administrieren von Microsoft SQL Server 2012-Datenbanken und bereiten Sie sich gleichzeitig effizient auf das Examen 70-462 vor....
|
27. | SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach By: Jason Brimhall; David Dye; Jonathan Gennick; Andy Roberts; Wayne Sheffield Publisher: Apress Publication Date: 19-SEP-2012 Insert Date: 31-OCT-2012 Slots: 1.0 | Overview: SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach
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...
|
28. | SQL Server 2012 with PowerShell V3 Cookbook By: Donabel Santos; Publisher: Packt Publishing Publication Date: 25-OCT-2012 Insert Date: 26-OCT-2012 Slots: 1.0 | Overview: SQL Server 2012 with PowerShell V3 Cookbook
Increase your productivity as a DBA, developer, or IT Pro, by using PowerShell with SQL Server to simplify database management and automate repetitive, mundane tasks.
Provides over a hundred practical recipes that utilize PowerShell to automate, integrate and simplify SQL Server tasks
Offers easy to follow, step-by-step guide to getting the most out of SQL Server and PowerShell
Covers numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes or other components
Builds a strong foundation that...
|
29. | By: Rachel Clements; Jon Reade Publisher: Packt Publishing Publication Date: 18-OCT-2012 Insert Date: 19-OCT-2012 Slots: 1.0 | Overview: What's New in SQL Server 2012
Unleash the new features of SQL Server 2012
Upgrade your skills to the latest version of SQL Server
Discover the new dimensional model in Analysis Services
Utilize data alerts and render reports to the latest versions of Excel and Word
Build packages to leverage the new features in the Integration Services environment
Plan, load and simulate real-world database activity using Distributed Replay
In Detail
Microsoft SQL Server has been part of the enterprise database landscape since SQL Server 7 arrived in 1998 and has evolved into the relational and BI platform of...
|
30. | Pro SQL Server 2012 BI Solutions By: Randal Root; Caryn Mason Publisher: Apress Publication Date: 12-SEP-2012 Insert Date: 29-SEP-2012 Slots: 1.0 | Overview: Pro SQL Server 2012 BI Solutions
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...
|
31. | SQL Server 2012 Integration Services Design Patterns By: Andy Leonard; Matt Masson; Tim Mitchell; Jessica M. Moss; Michelle Ufford Publisher: Apress Publication Date: 05-SEP-2012 Insert Date: 28-SEP-2012 Slots: 1.0 | Overview: SQL Server 2012 Integration Services Design Patterns
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...
|
32. | Microsoft SQL Server 2012 Security Cookbook By: Rudi Bruchez; Publisher: Packt Publishing Publication Date: 25-SEP-2012 Insert Date: 27-SEP-2012 Slots: 1.0 | Overview: Microsoft SQL Server 2012 Security Cookbook
Over 70 practical, focused recipes to bullet-proof your SQL Server database and protect it from hackers
and security threats.
Practical, focused recipes for securing your SQL Server databse
Master the latest techniques for data and code encryption, user authentication and authorization,
protection against brute force attacks, denial-of-service attacks, and SQL Injection, and more
A learn-by-example recipe-based approach that focuses on key concepts to provide the
foundation to solve real world problems
In Detail
In 2011, a big corporation suffered a 23-day network...
|
33. | Securing SQL Server, 2nd Edition By: Denny Cherry Publisher: Syngress Publication Date: 17-JUL-2012 Insert Date: 18-SEP-2012 Slots: 1.0 | Overview: Securing SQL Server, 2nd Edition
Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the...
|
34. | Microsoft® SQL Server 2012 Management and Administration, Second Edition By: Ross Mistry Publisher: Sams Publication Date: 18-SEP-2012 Insert Date: 13-SEP-2012 Slots: 1.0 | Overview: Microsoft® SQL Server 2012 Management and Administration, Second Edition If you need to deploy, manage, or secure Microsoft SQL Server
2012, this is the complete, fast-paced, task-based reference
you’ve been searching for. Authored by a worldclass expert on
running SQL Server in the enterprise, this book goes far beyond the
basics, taking on the complex tasks that DBAs need to make the most
of Microsoft’s first cloud-enabled database platform.
Designed for maximum practical usability, it’s packed with
expert tips and up-to-date real-world configuration guidance you
simply won’t find anywhere else.
As someone who helped influence the design of SQL Server 2012...
|
35. | Expert Performance Indexing for SQL Server 2012 By: Jason Strate; Ted Krueger Publisher: Apress Publication Date: 04-JUL-2012 Insert Date: 28-AUG-2012 Slots: 1.0 | Overview: Expert Performance Indexing for SQL Server 2012
Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.
What you'll learn from Expert Performance Indexing for SQL Server 2012 will...
|
36. | Pro SQL Server 2012 Reporting Services, Third Edition By: Brian McDonald; Shawn McGehee; Rodney Landrum Publisher: Apress Publication Date: 08-AUG-2012 Insert Date: 06-AUG-2012 Slots: 1.0 | Overview: Pro SQL Server 2012 Reporting Services, Third Edition
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine.
Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports....
|
37. | Microsoft SQL Server 2012 Performance Tuning Cookbook By: Ritesh Shah; Bihag Thaker Publisher: Packt Publishing Publication Date: 26-JUL-2012 Insert Date: 28-JUL-2012 Slots: 1.0 | Overview: Microsoft SQL Server 2012 Performance Tuning Cookbook
"80 recipes to help you tune SQL Server 2012 and achieve optimal performance with this book and ebook.
Learn about the performance tuning needs for SQL Server 2012 with this book and ebook
Diagnose problems when they arise and employ tricks to prevent them
Explore various aspects that affect performance by following the clear recipes
In Detail
As a DBA you must have encountered a slow running application on SQL Server, but there are various factors that could be affecting the performance. If you find yourself in this situation, don't wait, pick up this book and...
|
38. | Delivering Business Intelligence with Microsoft® SQL Server® 2012, Third Edition By: Brian Larson Publisher: McGraw-Hill Publication Date: 16-MAR-2012 Insert Date: 24-JUL-2012 Slots: 1.0 | Overview: Delivering Business Intelligence with Microsoft® SQL Server® 2012, Third Edition Implement a Robust BI Solution with Microsoft SQL Server 2012
Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools. Data mining and forecasting are also covered in this comprehensive...
|
39. | By: Godfrey Nolan Publisher: Apress Publication Date: 04-JUL-2012 Insert Date: 10-JUL-2012 Slots: 1.0 | Overview: Decompiling Android
Decompiling Android looks at the the reason why Android apps can be decompiled to recover their source code, what it means to Android developers and how you can protect your code from prying eyes. This is also a good way to see how good and bad Android apps are constructed and how to learn from them in building your own apps.
This is becoming an increasingly important topic as the Android marketplace grows and developers are unwittingly releasing the apps with lots of back doors allowing people to potentially obtain credit card information and database logins to back-end systems, as they...
|
40. | Pro SQL Server 2012 Integration Services By: Francis Rodrigues; Michael Coles; David Dye Publisher: Apress Publication Date: 27-JUN-2012 Insert Date: 10-JUL-2012 Slots: 1.0 | Overview: Pro SQL Server 2012 Integration Services
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You'll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from...
|