Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

Microsoft SQL Server


21. 

Abfragen von Microsoft SQL Server 2012 - Original Microsoft Training für Examen 70-461

Abfragen von Microsoft SQL Server 2012 - Original Microsoft Training für Examen 70-461

By: ; ;

Publisher: Microsoft Press Deutschland

Publication Date: 21-MAY-2013

Insert Date: 23-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Erlernen Sie das Administrieren von Microsoft SQL Server 2012-Datenbanken und bereiten Sie sich gleichzeitig effizient auf das Examen 70-461 vor. ...

22. 

SQL Server Concurrency: Locking, Blocking and Row Versioning

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

Table of Contents • Start Reading

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...

23. 

The Art of SQL Server FILESTREAM

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

Table of Contents • Start Reading

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...

24. 

Microsoft SQL Server 2012 Reporting Services

Microsoft SQL Server 2012 Reporting Services

By: Stacia Misner

Publisher: Microsoft Press

Publication Date: 15-APR-2013

Insert Date: 02-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Use your SQL Server skills to create and manage key data reports 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. This book is ideal for experienced SQL Server developers, whether you’re new to Reporting Services or upgrading from an earlier version. Discover how to: Use the latest features, including the Power View ad...

25. 

Microsoft® SQL Server® 2012 Step by Step

Microsoft® SQL Server® 2012 Step by Step

By: Patrick LeBlanc

Publisher: Microsoft Press

Publication Date: 15-FEB-2013

Insert Date: 19-MAR-2013

Slots: 1.0

Table of Contents • Start Reading

Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012 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. Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply...

26. 

Introducing Microsoft® SQL Server® 2012

Introducing Microsoft® SQL Server® 2012

By: ;

Publisher: Microsoft Press

Publication Date: 31-MAR-2012

Insert Date: 15-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

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....

27. 

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

By: Leonard Lobel and Andrew Brust

Publisher: Microsoft Press

Publication Date: 15-JUL-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

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...

28. 

Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions

Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions

By: Itzik Ben-Gan

Publisher: Microsoft Press

Publication Date: 15-APR-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Apply powerful window functions in T-SQL—and increase the performance and speed of your queries 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. Discover how to: Go beyond traditional query...

29. 

Microsoft® SQL Server® 2012: Pocket Consultant

Microsoft® SQL Server® 2012: Pocket Consultant

By: William R. Stanek

Publisher: Microsoft Press

Publication Date: 15-FEB-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field! Get fast facts to: Manage SQL Server services and clients Configure, manage, and tune servers Implement policy-based management Administer security and access Monitor server activity and tune performance Automate maintenance Perform...

30. 

Microsoft® SQL Server® 2012 Integration Services

Microsoft® SQL Server® 2012 Integration Services

By: Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Publisher: Microsoft Press

Publication Date: 15-SEP-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

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...

31. 

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model

By: Marco Russo, Alberto Ferrari, and Chris Webb

Publisher: Microsoft Press

Publication Date: 15-JUL-2012

Insert Date: 12-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Build agile and responsive Business Intelligence solutions 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...

32. 

Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases

Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases

By: Orin Thomas, Peter Ward, and boB Taylor

Publisher: Microsoft Press

Publication Date: 15-JUL-2012

Insert Date: 12-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

EXAM PREP GUIDE Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. Maximize your performance on the exam by mastering the skills and experience measured by these objectives: Install and configure SQL Server Maintain instances and databases Optimize and troubleshoot SQL Server Manage...

33. 

Exam 70-463: Implementing a Data Warehouse with Microsoft® SQL Server® 2012: Training Kit

Exam 70-463: Implementing a Data Warehouse with Microsoft® SQL Server® 2012: Training Kit

By: Dejan Sarka, Matija Lah, and Grega Jerkic

Publisher: Microsoft Press

Publication Date: 15-DEC-2012

Insert Date: 14-DEC-2012

Slots: 1.0

Table of Contents • Start Reading

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. Maximize your performance on the exam by learning how to: Design and implement a data warehouse Develop and enhance SQL Server Integration Services packages Manage and maintain SQL Server Integration Services packages Build data quality solutions Implement custom code in SQL Server...

34. 

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

By: Itzik Ben-Gan, Dejan Sarka, and Ron Talmage

Publisher: Microsoft Press

Publication Date: 15-DEC-2012

Insert Date: 20-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

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. Maximize your performance on the exam by learning how to: Create database objects Work with data Modify data Troubleshoot and optimize queries For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook....

35. 

Securing SQL Server, 2nd Edition

Securing SQL Server, 2nd Edition

By: Denny Cherry

Publisher: Syngress

Publication Date: 17-JUL-2012

Insert Date: 18-SEP-2012

Slots: 1.0

Table of Contents • Start Reading

SQL server is the most widely used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, 2e, readers learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book written by Denny Cherry, a Microsoft SQL MVP and one of the biggest names in SQL server today, readers learn how to properly secure a SQL server database from internal and external threats using best...

36. 

Delivering Business Intelligence with Microsoft® SQL Server® 2012, Third Edition

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

Table of Contents • Start Reading

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...

37. 

Decompiling Android

Decompiling Android

By: Godfrey Nolan

Publisher: Apress

Publication Date: 04-JUL-2012

Insert Date: 10-JUL-2012

Slots: 1.0

Table of Contents • Start Reading

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...

38. 

Microsoft® SQL Server® 2012: A Beginner’s Guide, Fifth Edition

Microsoft® SQL Server® 2012: A Beginner’s Guide, Fifth Edition

By: Dusan Petkovic

Publisher: McGraw-Hill

Publication Date: 02-MAR-2012

Insert Date: 24-MAY-2012

Slots: 1.0

Table of Contents • Start Reading

Essential Microsoft SQL Server 2012 Skills Made Easy Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data,...

39. 

Beginning Microsoft® SQL Server® 2012 Programming

Beginning Microsoft® SQL Server® 2012 Programming

By: 

Publisher: Wrox

Publication Date: 24-APR-2012

Insert Date: 22-MAY-2012

Slots: 1.0

Table of Contents • Start Reading

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds...

40. 

Microsoft® SQL Server® 2012 Reporting Services, Fourth Edition

Microsoft® SQL Server® 2012 Reporting Services, Fourth Edition

By: Brian Larson

Publisher: McGraw-Hill

Publication Date: 01-MAR-2012

Insert Date: 04-MAY-2012

Slots: 1.0

Table of Contents • Start Reading

The Definitive Guide to Microsoft SQL Server 2012 Reporting Services Create, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2012 Reporting Services, Fourth Edition covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are included in this practical...