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 help you understand what indexes are doing in the database and what can be done to mitigate and improve their effects on performance. The final destination is a guided tour through a number of real-world scenarios and approaches that can be taken to investigate, mitigate, and improve the performance of your database.* Defines indexes and provides an understanding of their role * Uncovers and explains the statistics that are kept in indexes * Teaches strategies and approaches for indexing databases What you'll learn * Fully understand the index types at your disposal * Recognize and remove unnecessary indexes * Review statistics to understand indexing choices made by the optimizer * Properly apply strategies such as covering indexes, included columns, index intersections, and more * Write queries to make good use of the indexes already in place * Design effective indexes for full-text, spatial, and XML data types * Manage the big picture: Encompassing all indexes in a database, and all database instances on a server Who this book is for Expert Performance Indexing for SQL Server 2012 is intended for database administrators and developers who are ready to boost the performance of their environments without the need to go in blindly building indexes. Table of Contents * Index Fundamentals * Index Storage Fundamentals * Index Statistics * XML, Spatial and FULLTEXT * Index Myths and Best Practices * Index Maintenance * Indexing Tools * Index Strategies * Query Strategies * Index Analysis

Pro T--SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built--in Transact--SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact--SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact--SQL into your own hands. Step--by--step explanations ensure clarity, and an advocacy of best--practices will steer you down the road to success. Transact--SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.What you'll learn * Take full advantage of window functions and other new features in T-SQL 2012 * Move business logic into the database via procedures and functions * Develop using advanced features such as encryption and full-text search * Store and retrieve XML data using XQuery and XPath * Debug and Optimize T-SQL Execution * Build ADO.NET Client Applications Who this book is for Pro T--SQL 2012 Programmer's Guide is written for SQL Server and Transact--SQL developers who want to implement best--practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

Microsoft SQL Server implements extensive support for location-based data.Pro Spatial with SQL Server 2012 introducesSQL Server's spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You'll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server's spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You'll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects. Explains spatial concepts from the ground upno prior knowledge is necessary Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer Brilliantly illustrated with code examplesthat run in SQL Server 2012, that you can adapt and use as the basis for your own projects. What you'll learn The fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems How to create and store spatial data using the geometry and geography data types How to use of spatial indexes in the design of highly-performant databases Write spatial queries to answer practical, business questions Pass spatial data seamlessly between database and application layers using T-SQL and C# Overcome common issues, including how to deal with invalid, imprecise, or erroneous spatial data Apply advanced techniques such as routefinding and clustering Who this book is for

Pro Spatial with SQL Server 2012is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2012. The book helps database administrators create and optimize the performance of spatial database. The book gives developers what they need to know in order to make effective use of the extensive support for location-based data provided by SQL Server, T-SQL, and C#. Table of Contents 1. Spatial Reference Systems 2. Spatial Features 3. Spatial Datatypes 4. Creating Spatial Data 5. Importing Spatial Data 6. Geocoding 7. Precision, Validity, and Errors 8.Transformation and Reprojection 9. Examining Spatial Properties 10.Modification and Simplification 11. Aggregation and Combination 12. Testing Spatial Relationships 13. Clustering and Distribution Analysis 14. Route Finding 15. Triangulation and Tesselation 16. Visualization and User Interface 17. Reporting Services 18. Indexing 19.

Prepare for Microsoft Exam 70-765-and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Implement SQL in Azure * Manage databases and instances * Manage storage This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning

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 solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. * Focused on solutions: Look up what you need to do. Learn how to do it. Do it.* Current: Newly updated for SQL Server 2012 * Comprehensive: Covers all common T-SQL problem domains What you'll learn * Create databases, tables, and indexes * Query and manipulate data * Store and manage XML inside the database * Move business logic into the database * Resolve common performance problems. * Build reports that matter to your business. * Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back--end database, and the database administrators who create, manage, and secure those databases.

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. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.* Provides best practices for using Reporting Services * Covers the very latest in new features for SQL Server 2012 * Your key to delivering business intelligence across the enterprise What you'll learn * Write efficient queries on which to base a report * Build and lay out a report using Report Designer * Enable end users to create ad hoc reports on demand * Combine Reporting Services with Analysis Services, SharePoint Server, and other technologies to deliver business intelligence across the enterprise * Secure and audit your reports as part of your regulatory compliance efforts * Customize your reports using C# assemblies and embedded Visual Basic .NET code Who this book is for Pro SQL Server 2012 Reporting Services is aimed at data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services. Table of Contents1. Introducing the Reporting Services Architecture 2. Report Authoring: Designing Efficienc Queries 3. Introduction to Reporting Services Design with SQL Server Data Tools 4. Laying Out A Report 5. Implementing Dashboard-Style Report Objects 6. Building Reports 7. Using Custom .NET Code with Reports 8. Deploying Reports 9. Rendering Reports from .NET Applications 10. Managing Reports 11. Securing Reports 12. Delivering Business Intelligence using SSRS 13. Creating Reports using Report Builder 1.0, 2.0, and 3.0

With the increasing popularization of personal hand-held mobile devices, more people use them to establish network connectivity and to query and share data among themselves in the absence of network infrastructure, creating mobile social networks (MSNet). Since users are only intermittently connected to MSNets, user mobility should be exploited to bridge network partitions and forward data. Currently, data route/forward approaches for such intermittently connected networks are commonly "store-carry-and-forward" schemes, which exploit the physical user movements to carry data around the network and overcome path disconnection. And since the source and destination may be far away from each other, the delay for the destination to receive the data from the source may be long. MSNets can be viewed as one type of socially-aware delay tolerant networks (DTNs). Observed from social networks, the contact frequencies are probably different between two friends and two strangers, and this difference should be taken into consideration when designing data dissemination and query schemes in MSNets. In this book, the fundamental concepts of MSNets are introduced including the background, key features and potential applications of MSNets, while also presenting research topics, such as, MSNets as realistic social contact traces and user mobility models. Because the ultimate goal is to establish networks that allow mobile users to quickly and efficiently access interesting information, particular attention is paid to data dissemination and query schemes in subsequent sections. Combined with geography information, the concepts of community and centrality are employed from a social network perspective to propose several data dissemination and query schemes, and further use real social contact traces to evaluate their performance, demonstrating that such schemes achieve better performance when exploiting more social relationships between users.

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 What you'll learn * Load data from flat file formats * Explore patterns for executing SSIS packages * Discover a pattern for loading XML data * Migrate SSIS packages through your application lifecycle without editing connections * Take advantage of SSIS 2012 Dependency Services * Build an SSIS Framework to support your application needs Who this book is for SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It's for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It's an excellent choice for business intelligence and data warehouse developers.Table of Contents * Metadata Collection * Execution Operations * Scripting * SQL Server Source Patterns * Data Cleansing * DB2 Source * Flat File Source Patterns * Parallel Data Warehouse * XML * Expression Language Patterns * Data Warehouse * Logging * Slowly Changing Dimensions * Loading the Cloud * Reporting * Parent-Child Patterns * BIML * Configuration * Deployment * Estimating ETL Projects

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's bookSQL 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 What you'll learn Establish performance baselines and monitor against them Recognize and eliminate bottlenecks leading to slow performance Deploy quick fixes when needed, following up with long term solutions Implement best-practices in T-SQL so as to minimize performance risk Design in the performance that you need through careful query and index design Take advantage of the very latest performance optimization features in SQL Server 2012 Who this book is for

SQL Server 2012 Query Performance Tuning is aimed at developers and database administrators having responsibility for application performance in SQL Server environments. Programmers and administrators alike will find the book a trove of good insight into bottlenecks, how to recognize them, how to eliminated them. SQL Server 2012 Query Performance Tuning provides the tools and techniques readers need to create good-performing applications that delight their users. Table of Contents SQL Query Performance Tuning System Performance Analysis SQL Query Performance Analysis Index Analysis Database Engine Tuning Advisor Lookup Analysis Statistics Analysis Fragmentation Analysis Execution Plan Analysis Query Recompilation Analysis Query Design Analysis Blocking Analysis Deadlock Analysis Cursor Cost Analysis Testing Query Performance Database Workload Optimization SQL Server Optimization Checklist

Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators, consumers, and the business community at large, the job descriptions of SQL DBAs and developers are expanding to include encryption. Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.Introduces encryption, guiding readers through its implementation in SQL Server Demonstrates advanced techniques such as the use of hardware security modules Covers all that a SQL Server database administrator needs to know about encryption What you'll learn Take advantage of hardware security modules via extensible key management Implement targeted encryption of individual columns Secure an entire database at once with Transparent Data Encryption Encrypt disk volumes using BitLocker encryption Effectively design and manage encryption as part of your total security solution Digitally sign documents stored in your database Who this book is for

The audience for this book includes SQL Server DBAs, SQL developers, and .NET developers who want to take advantage of the powerful encryption functionality available in SQL Server 2008. The features of SQL Server 2008 provide a powerful set of tools to secure your most sensitive data, helping protect it from theft. Table of Contents Introduction to Encryption Encryption Key Management Symmetric Encryption Asymmetric Encryption Extensible Key Management Transparent Data Encryption Hashing SQL CLR Cryptography Indexing Encrypted Data Encrypting Connections to SQL Server 2008 Regulatory Requirements

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond.Easy to follow, step-by-step instructions for beginner and intermediate users In-depth, detailed information for advanced and expert users Covers all phases of database mirroring from planning to sustained maintenance What you'll learn Plan effectively for database mirroring. Learn what questions to ask and what problems to anticipate Get step-by-step instructions on how to set up database mirroring Automate the initial setup and the ongoing maintenance of mirrored databases Monitor database mirroring, detect failures, and generate automated alerts Build a system that automatically responds to and fixes common problems Build in support for the missing facets of database mirroring, such as support for cross-database dependencies Define groups of databases that all fail over together to their mirrors when just one of those databases fails Create operational processes so that even nontechnical staff can manage mirrored databases Who this book is for

General audience: Pro SQL Server 2008 Database Mirroring is aimed at SQL Server 2008 database administrators, and especially those who desire to mirror their databases in support of high availability. System administrators and operational engineers who manage Windows Server systems that support mirrored database environments will also find much in the book of interest. Table of Contents High Availability Options Database Mirroring Overview Planning and Best Practices Database Mirroring Setup Automating Setup Maintenance Simplified Monitoring and Alerting Upgrading to SQL Server 2008 Reporting Considerations Planning for Failure

Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite-an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite's capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication. Examines the detailed configuration and the internal workings of the different replication types using reallife scenarios Covers replication with database mirroring and troubleshooting Discusses replication administration using different tools Table of Contents Introduction Replication Basics Types of Replication Configuring Snapshot Replication Using the GUI Configuring Snapshot Replication Using T-SQL Snapshot Generation Internals of Snapshot Replication Configuring Transactional Replication Using the GUI Configuring Transactional Replication Using T-SQL Internals of Transactional Replication Configuring Merge Replication Using the GUI Web Synchronization with Merge Replication Configuring Merge Replication Using T-SQL The Internals of Merge Replication Backup and Recovery of Snapshot and Transactional Replication Backup and Recovery of Merge Replication Optimizing Snapshot Replication Optimizing Transactional Replication Optimizing Merge Replication Heterogeneous Replication

Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.

The book begins by addressing the many misconceptions that surround the use of key performance indicators (KPIs) and giving a brief overview of the business intelligence (BI) and reporting tools that can be combined on the Microsoft platform to help you generate the results that you need.

The focus of the book is to help you implement a successful business intelligence project of your own. The text discusses many of the required project planning components, provides overviews and examples associated with Microsoft's BI tools, and gives detailed examples of successful dashboard implementations. What you'll learn The key functional and technical components of a successful report/dashboard implementation What Microsoft tools are provided both within and without SQL Server 2008 to help you achieve an integrated solution How to determine whether your performance indicators are correct for your business and how to roll them out to your organization in an effective way Who this book is for

This book is for entrepreneurs, technologists, and developers who want to bring clear-cut, reliable reporting into their organization. No prior experience of building analytics and reporting dashboards is required, but basic familiarity with SQL Server 2008 is assumed. Table of Contents An Overview of Analytics Seven Keys to Successful Reporting Projects Key Performance Indicators Microsoft Platform Components for Dashboards Core Components of SQL Server 2008 SQL Server Analysis Services Performance Management Implementation and Maintenance of the Integrated System Case Studies

Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.Clearly describes relational database concepts Explains the SQL Server database engine and supporting tools Shows various database maintenance scenarios What you'll learn To understand core concepts of relational databases How to install SQL Server in your environment How to use the tools that come with SQL Server to perform daily administrative tasks How to design and implement a database maintenance plan in SQL Server Configuring database security and protect your sensitive data from intruders How to meet regulatory and government compliance requirements like Sarbanes-Oxley and the Payment Card Industry (PCI) regulations Who this book is for

This book is primarily for those who are aspiring to become SQL Server 2008 database administrators. Reading this book gives you a great foundation of knowledge upon which to build a future career in database administration. You might be new to SQL Server 2008, or you might have experience with competing products such as Oracle. Either way, this book gets you up to speed quickly in managing SQL Server 2008, helping you transfer your existing knowledge into the SQL Server 2008 environment. Table of Contents The Database Administration Profession Planning and Installing SQL Server 2008 What's in the Toolbox? Creating Tables and Other Objects Transact-SQL SQL Server Internals Storage Management Strategies Database Backup Strategies Database Restore Strategies Common Database Maintenance Tasks Automation Through SQLCMD and PowerShell Database Maintenance Plans Performance Tuning and Optimization SQL Server Security Auditing, Encryption, and Compliance SQL Server in the Enterprise Where to Go Next?

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.

The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter.

In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. What you'll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for

If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You'll learn to anticipate and reduce the likelihood of a disaster, and to mitigate the effects of a disaster when one does occur. Perhaps most importantly, you'll learn how to prepare so that you can return a system to its normal state quickly, ensuring system availability and the continued success and operation of your business.

Many SQL Server features and technologies are, or can be put to good use in disaster recovery planning. In this book, you'll learn about powerful tools and features -- such as Database Snapshots and Mirroring -- for data backup and disaster recovery that are present in SQL Server 2005, and that are enhanced in SQL Server 2008. Also covered are common issues to expect when using these features. This book explores your options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios.

There's a human side to disaster recovery planning as well. Like few other activities, disaster recovery planning requires that you work closely with a wide variety of people from all across your organization. People skills are as critical to disaster recovery planning as technical skills, and perhaps more so. This book does not leave you in the dark, but provides sound advice on how to keep disaster recovery planning projects on track, how to avoid dangerous scope creep, and how to work effectively with the variety ofpersonality types that you will encounter.

Disaster recovery planning is really about sleep. When you get the call at 3: 00 am that your database is lost, don't wake up with that icy feeling in your veins. Instead wake up with confidence that you have a plan in place, a plan that you've practiced, that management has bought into, a plan that you can execute even while half-asleep to get your database, your company, and your job back on track. What you'll learn

This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. It covers: Real-world examples of data loss and what might have been done to prevent it A systematic, problem-based approach to designing a disaster recovery plan Pitfalls one might encounter, and how to deal with them Team dynamics, and the soft-side of disaster planning New technology in SQL Server 2005 and 2008 that takes disaster recovery beyond the simple backup/recovery plan When and why to use disaster recovery features, as opposed to just describing how they work
Who is this book for?

SQL Server database administrators

This book constitutes the refereed proceedings of the 5th International Workshop on Databases in Networked Information Systems, DNIS 2007, held in Aizu-Wakamatsu, Japan in October 2007. Focusing on data semantics and infrastructure for information management and interchange, the papers are organized in topical sections on geospatial decision-making, Web data management systems, infrastructure of networked information systems, and Web query and web mining systems.

Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.Covers using the free Express Edition of SQL Server Describes creating a database from scratch and builds on this Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business What you'll learn Learn what features exist within SQL Server 2008 Express Edition and how to install and upgrade the product and set up security. Design and create a database. Build database objects, such as tables and stored procedures, graphically as well as programmatically. Work with datainserting, updating, deleting, and retrievingusing simple and complex queries, programs, and data views. Generate reports from data. Implement a solid database maintenance strategy that includes backing up and restoring your data when necessary. Take advantage of advanced TransactSQL techniques to get the most out of your data. Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner. Who this book is for

Anyone interested in working with SQL Server as a database, and particularly those who wish for a no-cost database platform that plays well in the .NET environment. Ideal for those starting out in IT or who have to prior database experience.

Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.

Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data. Every section is illustrated with code examples that you can use directly in SQL Server. All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express. What you'll learn Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems.Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types.Create different types of spatial data objectspoints, lines, and polygonsand use these to describe realworld objects.Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods.Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data.Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes. Who this book is for

SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008.

Learn effective and scalable database design techniques in a SQL Server environment.Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high-performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You'll learn how to apply development methodologies like these to produce high-quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.

In this book, youll learn how to: Install, configure, and troubleshoot a testing environment with PHP/MySQL and Apache or IIS Learn the fundamentals of PHP and good database design Use Dreamweaver 8 server behaviors to create robust dynamic applications that validate user input for greater security and reliability Incorporate live XML feeds into your web pages with PHP and Dreamweaver 8s new XSL Transformation server behavior Download and apply a suite of custom-built PHP functions designed exclusively for this book Want to add the power of a database to your websites? Build online forms that send feedback straight to your inbox? Incorporate live news feeds and XML data into your web pages? This book shows you how to do all that and more. Dreamweaver 8 takes a lot of the hard work out of integrating a database into your websites, but it cant do everything. So instead of just giving you a series of instructions to click this and click that, this book helps you understand whats going on in the background. As a result, youre more likely to remember and to get it right. Most books on PHP concentrate on code and throw all design considerations out the window. This one is different. It makes use of Dreamweaver 8s vastly improved CSS rendering, and shows you how to build a site thats smart in both senses of the word. It looks good and is intelligent too. Youll learn how to change the entire look of the site, using PHP to serve up different stylesheets each month. Youll also build a contact form protected against email injection attacks. All of Dreamweavers PHP server behaviors are put through their paces, and youll even make some custom server behaviors that will come in useful on any site youcreate. Two chapters take you through the setup process with step-by-step instructions for both Windows and Mac OS X, helping you make the right choices: Apache or IIS? Remote or local testing? There are even instructions on how to set up virtual hosts on your own computer. And in the unlikely event that things go wrong, theres plenty of troubleshooting advice too. In this book we look specifically at using Dreamweaver's built-in server behaviors to build dynamic web sites using PHP and MySQL, the worlds most popular open source server-side language and database server combination, which are both reliable, powerful, and open source (and therefore free to use!) This latest version of Dreamweaver includes more powerful support for PHP and MySQL than ever before, and we'll show you how to make this work for you. No previous experience of PHP or MySQL is necessary to use this book. Examples built throughout the book include a content management system, and an online image gallery. All examples are designed to meet modern usability requirements and be web standards compliant. Summary of Contents: Introduction Chapter 1: So, You Want to Build Dynamic Sites? Chapter 2: Dreamweaver and PHPA Productive Partnership Chapter 3: Getting the Work Environment Ready Chapter 4: Getting Ready for the Case Study Chapter 5: Integrating PHP into Your Site Chapter 6: Getting Feedback from an Online Form Chapter 7: Putting the Power of a Database Chapter 8: Building a Random Quotation Generator Chapter 9: Working with Multiple Tables Chapter 10: Using Sessions to Track Chapter 11: Displaying a Blog and Photo Gallery Chapter 12: Using XSLT to Display Live News Feeds and XML Appendix A: Using Languages OtherThan English in MySQL Appendix B: Essential MySQL Maintenance Index

Purchase this book and you'll get the free, fully searchable eBooka $20 value! (Details are printed inside the book.)

It does a good job of covering the fundamentals and simple reporting needs. For the SSRS newcomer, it is a great place to start. -- Will Wagers, C# Online.NET

SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This book examines all of the technology that SSRS provides to design, author, render and deploy professional business reports to the Web or to the company intranet (in a variety of formats, from HTML to XML, PDF, or TIFF), with detailed examples at every step.

It covers all of the new functionality present in the 2005 version, including the new management and BI development studios as well as the new report viewer controls and end-user reporting tools. It also contains significantly expanded chapters on Business Intelligence along with a wealth of tips and workarounds for effective development with SSRS.

The authors are both highly experienced with SQL Server and with business reporting in the medical industry, which is subject to rigorous HIPAA regulations and strict security. It is not their intention to evangelize the product or present "idealized" examples based on the simple built-in schemas. Instead, they take a hard, critical look at the technology and provide exactly what the reader needs to know to deliver effective reports. Their code examples are based on real, complex schemas and the need to deliver versatile, dynamic reports, as well as on strict security and performance requirements.

In summary, this book will provide you with step-by-step guides, best practices, and realcode examples covering all of the common Reporting Services tasks, including: A detailed overview of the reporting architecture and tools The new Report Definition Language Standard, which is XML-based and allows you to define reports in VS.NET Building effective queries for high-performance reporting Building custom .NET applications with SSRS Rendering reports to HTML, XML, PDF and Excel Deploying secure reports, using Windows authentication through Active directory Business Intelligence reporting using SQL Server Analysis Services

SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (non-enterprise) features from SQL Server 2005, and comes complete with development and administration tools. As such, it is an ideal database for developers and administrators to use in prototype/evaluation projects. It is also a powerful development platform for database applications on nonprofit websites, e-commerce sites, and in small offices and departments.

Author -->Rick Dobson--> provides all of the installation, configuration, administration, and development techniques that you need to build applications quickly. He focuses on techniques that are easy to learn and transparent in their real-world translations. Topics include the SSMS-based query tool and T-SQL programming, and Visual Basic Express and Visual Web Developer, both with SSE, to build Windows Forms applications and to develop ASP.NET web applications.