Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Collapse
Featured CategoriesCollapse
Information Technology & Software Development
Microsoft SQL Server 2008
1. |  Microsoft® SQL Server® 2008 Internals By: Kalen Delaney; Paul Randal; Kimberly Tripp; Conor Cunningham Publisher: Microsoft Press Publication Date: 11-MAR-2009 Insert Date: 19-JAN-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2008 Internals Delve inside the core SQL Server engine—and put that knowledge
to work—with guidance from a team of well-known internals experts.
Whether database developer, architect, or administrator, you’ll
gain the deep knowledge you need to exploit key architectural
changes—and capture the product’s full potential. Discover how SQL
Server works behind the scenes, including: • What happens
internally when SQL Server builds, expands, shrinks, and moves
databases • How to use event tracking—from triggers to the Extended
Events Engine • Why the right indexes can drastically reduce your
query execution time...
|
2. |  Inside Microsoft® SQL Server® 2008: T-SQL Querying By: Itzik Ben-Gan; Lubor Kollar; Dejan Sarka; Steve Kass Publisher: Microsoft Press Publication Date: 18-MAR-2009 Insert Date: 19-JAN-2013 Slots: 1.0 | Overview: Inside Microsoft® SQL Server® 2008: T-SQL Querying Tackle the toughest set-based querying and query tuning
problems—guided by an author team with in-depth, inside knowledge
of T-SQL. Deepen your understanding of architecture and
internals—and gain practical approaches and advanced techniques to
optimize your code’s performance.
Discover how to:
• Move from procedural programming to the language of sets and
logic • Optimize query tuning with a top-down methodology • Assess
algorithmic complexity to predict performance • Compare
data-aggregation techniques, including new grouping sets • Manage
data modification—insert, delete, update, merge—for...
|
3. |  Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition Publisher: Microsoft Press Publication Date: 13-APR-2010 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition The fast-answers, daily administration guide to SQL Server® 2008 (updated for R2). This pocket-sized guide from award-winning author William Stanek features concise tables, listings, and step-by-step instructions for fast, accurate answers on the spot....
|
4. |  Inside Microsoft® SQL Server® 2008: T-SQL Programming By: Itzik Ben-Gan; Dejan Sarka; Greg Low; Roger Wolter; Ed Katibah; Isaac Kunen Publisher: Microsoft Press Publication Date: 23-SEP-2009 Insert Date: 14-JAN-2013 Slots: 1.0 | Overview: Inside Microsoft® SQL Server® 2008: T-SQL Programming Get a detailed look at the internal architecture of Transact-SQL (T-SQL)—the database programming language built into SQL Server—with this comprehensive, hands-on programming reference....
|
5. |  Microsoft SQL Server 2008 R2 - Das Entwicklerbuch By: Georg Urban; Jörg Neumann; Klaus Löffelmann; Alexander Köller Publisher: Microsoft Press Deutschland Publication Date: 24-NOV-2010 Insert Date: 02-MAR-2012 Slots: 1.0 | Overview: Microsoft SQL Server 2008 R2 - Das Entwicklerbuch Das umfassende Arbeitsbuch zu SQL Server 2008 R2: Wenn Sie professionell mit dem SQL Server zu tun haben, dann ist dies Ihr Buch! SQL Server 2008 R2 ist nicht einfach nur ein relationales DBMS, sondern eine komplexe Entwicklungsumgebung mit vielfältigen Angeboten und Herausforderungen für Entwickler. Die Spannbreite reicht von »klassischer« T-SQL-Programmierung über .NET-Programmierung in C# bis hin zur Geodatenverarbeitung und Complex Event Processing. Anhand eines durchgängigen Beispielszenarios werden diese Konzepte nicht nur theoretisch, sondern mit viel Praxisbezug vorgestellt: Über...
|
6. |  Microsoft SQL Server 2008 R2 Reporting Services - Das Praxisbuch By: Sven Bayer; Jörg Knuth; Martin B. Schultz Publisher: Microsoft Press Deutschland Publication Date: 14-SEP-2011 Insert Date: 01-MAR-2012 Slots: 1.0 | Overview: Microsoft SQL Server 2008 R2 Reporting Services - Das Praxisbuch Microsoft SQL Server Reporting Services sind als Bestandteil von SQL Server 2008 R2 ohne weitere Lizenzkosten nutzbar. Als Bestandteil des Microsoft Business Intelligence-Frameworks stellen sie eine serverbasierte Lösung zum Entwickeln, Verwalten und Verteilen von Berichten zur Verfügung. Ziel dieses Buchs ist es, Ihnen diese Technologien verständlich zu machen und dabei nah an der Praxis zu bleiben. Das heißt konkret: Die Autoren erläutern Ihnen anhand von Szenarien die Praxisrelevanz der jeweiligen Features und vertiefen wichtige Themen mit Schritt-für-Schritt-Anleitungen. Das Buch ist so...
|
7. |  Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2008 (R2) Express By: Robert Panther Publisher: Microsoft Press Deutschland Publication Date: 13-OCT-2010 Insert Date: 27-FEB-2012 Slots: 1.0 | Overview: Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2008 (R2) Express SQL Server 2008 R2 Express als kostenloser und leistungsfähiger Datenbankserver ist ideal, um in die professionelle Datenbankentwicklung einzusteigen. Mit dieser Version von SQL Server ist es möglich, auch komplexe Datenbankprojekte zu verwirklichen, die die Funktionalität einer Desktop-Datenbank wie Microsoft Access übersteigen. Wenn Sie in die Datenbankentwicklung mit einem professionellen Datenbankserver einsteigen wollen, ist dieses Buch genau das Richtige für Sie. Es vermittelt sowohl die Datenbankgrundlagen als auch das Programmierwissen, das Sie benötigen, um die umfangreichen...
|
8. |  Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition By: Guy Fouché; Lynn Langit Publisher: Apress Publication Date: 01-APR-2011 Insert Date: 16-FEB-2012 Slots: 1.0 | Overview: Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition
Foundations of SQL Server 2008 R2 Business Intelligence introduces the exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform. The database is at the core, and surrounding the database are tools for data mining, modeling, reporting, analyzing, charting, and integration with other, enterprise-level software packages.
SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That's what...
|
9. |  Microsoft® SQL Server® 2008 R2 Master Data Services: Implementation & Administration By: Tyler Graham; Suzanne Selhorn Publisher: McGraw-Hill Publication Date: 24-FEB-2011 Insert Date: 09-FEB-2012 Slots: 1.0 | Overview: Microsoft® SQL Server® 2008 R2 Master Data Services: Implementation & Administration Best Practices for Deploying and Managing Master Data Services (MDS)Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material...
|
10. |  SQL Server 2008 R2 - Der schnelle Einstieg: Abfragen, Transact-SQL, Entwicklung und Verwaltung By: Klemens Konopasek Publisher: Addison-Wesley Verlag Publication Date: 21-JUL-2010 Insert Date: 02-FEB-2012 Slots: 1.0 | Overview: SQL Server 2008 R2 - Der schnelle Einstieg: Abfragen, Transact-SQL, Entwicklung und Verwaltung Dieses Buch bietet Ihnen einen leichten und schnellen Einstieg in Einsatz, Verwaltung und Entwicklung einer Datenbank mit dem SQL Server 2008 und SQL Server 2008 R2. Sie erhalten eine Einführung in die neuen Features beider Versionen, in Installation und Konfiguration des SQL Servers und lernen die grafischen Oberflächen, allen voran das SQL Server Management Studio, kennen. Ein Schwerpunkt liegt auf der Lösungsentwicklung mit Transact-SQL, wobei auch die Common Language Runtime-Integration mit .NET berücksichtigt wird. An DBAs richten sich die Kapitel zur Benutzerverwaltung und...
|
11. |  MCTS 70-642 Cert Guide: Windows Server® 2008 Network Infrastructure, Configuring By: Don Poulton Publisher: Pearson Certification Publication Date: 17-FEB-2012 Insert Date: 09-DEC-2011 Slots: 1.0 | Overview: MCTS 70-642 Cert Guide: Windows Server® 2008 Network Infrastructure, Configuring Learn, prepare, and practice for Microsoft
MCTS 70-642 exam success with this MCTS 70-642: Windows Server
2008 Network Infrastructure, Configuring Cert Guide from
Pearson IT Certification, a leader in IT Certification learning.
The companion CD features two complete practice exams.
Master Microsoft’s MCTS 70-642 exam topics
Assess your knowledge with chapter-ending quizzes
Review key concepts with exam preparation tasks
Practice with realistic exam questions on the CD
MCTS 70-642: Windows Server 2008 Network
Infrastructure, Configuring Cert Guide is a best-of-breed...
|
12. |  Microsoft SQL Server 2008 R2 Administration Cookbook By: Satya Shyam K Jayanty; Publisher: Packt Publishing Publication Date: 24-MAY-2011 Insert Date: 30-SEP-2011 Slots: 1.0 | Overview: Microsoft SQL Server 2008 R2 Administration Cookbook
Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system
Provides Advanced Administration techniques for SQL Server 2008 R2 as a book or eBook
Covers the essential Manageability, Programmability, and Security features
Emphasizes important High Availability features and implementation
Explains how to maintain and manage the SQL Server data platform effectively
In Detail
Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels – be they small, medium, or large....
|
13. |  SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond By: Tom Carpenter Publisher: Sybex Publication Date: 17-MAY-2010 Insert Date: 23-SEP-2011 Slots: 1.0 | Overview: SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond The ideal on-the-job reference guide for SQL Server 2008 database administratorsIf you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more.And, if you're preparing for MCTS or MCITP certification in SQL Server 2008...
|
14. |  By: Michael Lee; Gentry Bieker Publisher: Sybex Publication Date: 20-JAN-2009 Insert Date: 16-SEP-2011 Slots: 1.0 | Overview: Mastering SQL Server® 2008 As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection....
|
15. |  MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook By: Tomislav Piasevoli; Publisher: Packt Publishing Publication Date: 09-AUG-2011 Insert Date: 16-AUG-2011 Slots: 1.0 | Overview: MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook
More than 80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries in this book and eBook
Enrich your BI solutions by implementing best practice MDX calculations
Master a wide range of time-related, context-aware, and business-related calculations
Enhance your solutions by combining MDX with utility dimensions
Become skilled in making reports concise
Learn how to optimize, dissect, and debug your MDX calculations
Maximize your learning with detailed explanations following each solution
Packed with...
|
16. |  Microsoft SQL Server 2008 R2 Master Data Services By: Jeremy Kashel; Tim Kent; Martyn Bullerwell Publisher: Packt Publishing Publication Date: 19-JUL-2011 Insert Date: 25-JUL-2011 Slots: 1.0 | Overview: Microsoft SQL Server 2008 R2 Master Data Services
"Manage and maintain your organization's master data effectively with Microsoft SQL Server 2008 R2 Master Data Services
Gain a comprehensive guide to Microsoft SQL Server R2 Master Data Services (MDS) with this book and eBook
Explains the background to the practice of Master Data Management and how it can help organizations
Introduces Master Data Services, and provides a step-by-step installation guide
Covers all features of Master Data Services, including hierarchy management, importing/exporting data, the MDS API, and business rules
Includes practical examples that guide...
|
17. |  Beginning Microsoft® SQL Server® 2008 Programming By: Robert Vieira Publisher: Wrox Publication Date: 09-JAN-2009 Insert Date: 04-JUL-2011 Slots: 1.0 | Overview: Beginning Microsoft® SQL Server® 2008 Programming
This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself
Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server
Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more
Features updated and new material, including new examples using Microsoft's AdventureWorks sample...
|
18. |  Practical DMX Queries for Microsoft® SQL Server® Analysis Services 2008 By: Art Tennick Publisher: McGraw-Hill Publication Date: 17-SEP-2010 Insert Date: 25-JUN-2011 Slots: 1.0 | Overview: Practical DMX Queries for Microsoft® SQL Server® Analysis Services 2008 250+ Ready-to-Use, Powerful DMX Queries
Transform data mining model information into actionable business intelligence using the Data Mining Extensions (DMX) language. Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 contains more than 250 downloadable DMX queries you can use to extract and visualize data. The application, syntax, and results of each query are described in detail. The book emphasizes DMX for use in SSMS against SSAS, but the queries also apply to SSRS, SSIS, DMX in SQL, WinForms, WebForms, and many other applications. Techniques for generating DMX syntax...
|
19. |  Professional Microsoft® SQL Server® 2008 Administration By: Brian Knight; Ketan Patel; Wayne Snyder; Ross LoForte; Steven Wort Publisher: Wrox Publication Date: 03-NOV-2008 Insert Date: 30-MAR-2011 Slots: 1.0 | Overview: Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor...
|
20. |  Professional SQL Server® 2008 Integration Services By: Brian Knight; Erik Veerman; Grant Dickinson; Douglas Hinson; Darren Herbold Publisher: Wrox Publication Date: 06-OCT-2008 Insert Date: 22-MAR-2011 Slots: 1.0 | Overview: Professional SQL Server® 2008 Integration Services
The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)
Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever
Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques
New chapters include coverage of data warehousing using SSIS, new...
|
©2013 Safari Books Online