Download eBOOK | Free eBOOK | Free Download eBOOK

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 of personality 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:

Who is this book for?

SQL Server database administrators

SQL Server Integration Services is groundbreaking. It exists for both the DBA and the developer, as well as that new role SSIS has created between the two—the data artisan.

Pro SQL Server 2005 Integration Services contains everything you could ever hope to know about this exciting new development from Microsoft: developer insight, Microsoft group manager–level access, personal experience of using the technology in the real–world, and fine–grained analysis. If you want to rapidly gain knowledge and context from your data, Microsoft’s latest and greatest interpretation of Enterprise Application Integration, SQL Server Integration Services, is for you. As part of the extensive SQL Server suite, Integration Services is a more serious and expandable interpretation of the integration paradigm than previously available. At once both simple to use yet incredibly complex, it goes far beyond being a reimagining and reengineering of DTS, and its all presented in a familiar Visual Studio context. It’s Agile, it’s service-oriented, it’s everything to everyone.

Written for the developer, the DBA, and the data artisan, Pro SQL Server 2005 Integration Services will show you how to develop and deploy enterprise SSIS solutions in multibillion–item environments. Its everything SSIS, explained for everyone!

What you’ll learn

• Understand how to develop and deploy SSIS solutions that will perform in multibillion–item environments from an author who has been there and done it.
• Build bespoke custom components tailored to your projects exact requirements.
• Create perfomant and scalable solutions with an eye to future requirements and upgrades.

Who is this book for?

This book is for anyone working with SQL Server who has an interest in the Integration Services technology. Deep experience of SQL Server 2005 is not expected, however, you should be comfortable with fundamental techniques.

Sql Server Integration Services with the acronym SSIS is a comprehensive ETL tool that made its debut with SQL Server 2005. It is a tool tightly integrated with the Visual Studio 2005 having all the functionalities that its forerunner DTS (Data Transformation Services) had in SQL Server 2000. This does not mean that it is just an improvement over DTS but a product which is totally different with a vastly improved interface; an extensible architecture; an enlarged tool set; ease of integration with other SQL Server Tools such as Analysis Services; capable of supporting connectivity with third party databases and bringing into a central location many database management tasks.

Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers explains how to use ASP.NET 2.0 and SQL Server 2005 most efficiently together. It covers all crucial performance issues and illustrates optimal techniques with enterprise-quality development.

Performance is always an issue, and optimizing database access is one of the most daunting performance challenges facing web developers. With Brennan Stehling as your guide, you'll explore the many overlaps of web and database technologies, including configuration, programming, performance tuning, and deployment. You’ll learn how to make high-performance database access not just a goal, but a reality.

What you’ll learn

• Discover what impedes ASP.NET 2.0 access to SQL Server 2005 and how to make web applications and databases work blindingly fast together.
• Learn to make the subtle choices between DataSets, DataReaders, and DataObjects, to simplify code and maximize performance.
• Optimize data-bound controls and create your own.
• See when a custom database provider is advisable and how to build one.
• Understand how to monitor and measure web/database performance.
• Learn to build, deploy, and configure enterprise-level web applications against SQL Server 2005.

Who is this book for?

Anyone involved in .NET web development will find this book invaluable. Whether you’re struggling just to handle traffic or scaling up to meet demand, you’ll find all the tools, tips, and techniques you need for high-performance web access to databases. If you want to build enterprise-level web database applications 100% of the time, this book will tell&emdash;and show&emdash;you how to do it.

Today's DBAs need to know how to work with users, management, and key stakeholders to identify organizational needs and leverage the technology to meet them. Covering intermediate to advanced subjects, such as performance tuning, this book shows you how to build a reporting infrastructure that can be used in any environment.

Focusing on six key principles simplicity, clarity, generality, automation, and communications all vital elements of meaningful reports, you'll learn everything you need to know to design a report infrastructure that integrates the best practices of reporting systems. When you're finished, you will have a roadmap that enables you to help corporate managers make the most of this technology.

Loaded with real-world examples, this book arms you with guidelines that apply equally well to small businesses and mega-corporations.

Database professionals will find that this new edition aids in mastering the latest version of Microsofts SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.

Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.