Page 1
Page 1
MCITP self-paced training Kit (Exam 70-444) : Optimizing and maintaining a database administration solution microsoft SQL server 2005
Designed to help you make the most of your study time. Maximize your performance on the exam by learning to: * Monitor and troubleshoot queries, databases, and servers * Help defend against injection attacks, denial of service attacks, worms, and viruses * Manage security strategies and perform audits * Detect and resolve data conflicts * Diagnose faults and recover from database failures and disasters * Optimize database availability with failover clustering, database mirroring, log shipping, and replication * Customize a maintenance strategy and automate routine tasks * Build, debug, and deploy SQL Server Integration Services packages PRACTICE TESTS Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers-including a customized learning path that describes how and where to focus your studies. Your training kit includes: Details inside. * Official self-paced study guide. * Practice tests with multiple, customizable testing options and a learning plan based on your results. *400+ practice and review questions. * Case scenarios, practice exercises, and best practices. *180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition. * Fully searchable eBook of this guide.
High Performance SQL Server " Consistent Response for Mission-Critical Applications
An excellent complement to query performance tuning books and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed. You will: Understand SQL Server's database engine and how it processes queries / Configure instances in support of high-throughput applications / Provide consistent response times to varying user numbers and query volumes / Design databases for high-throughput applications with focus on performance / Record performance baselines and monitor SQL Server instances against them / Troubleshot and fix performance problems
Hardening Windows
Hardening is the process of protecting a system against unknown threats. System administrators harden against that which they think could be a threat. Administrators know the Internet is a hostile environment. Although they can't tell, for example, that a hacker will attempt to gain access to the SQL server next Tuesday, they can bet money there'll be an attempt soon and should "batten down the hatches" in anticipation. Hardening Windows, Second Edition is the definitive "counterintelligence" guide to performing preventative security measures for the Windows operating system. This second edition covers the release of Windows XP Service Pack 2 and its new security features, including the Windows Firewall and the Security Center. It also covers Windows Server 2003 Service Pack 1, Windows Server R2's new Security Configuration Wizard, Windows NT, Windows 2000, branch-office security features, and new setup options.
Foundations of SQL Server 2005 Business Intelligence
This book explains how best to use Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Data Mining. It also describes best practices for implementing end-to-end BI solutions in small, medium, and large business environments. And it provides important information about integrating BI with various client tools.
Foundation ASP.NET for Flash
If you're a reasonably experienced Flash user who has mastered the basics but wants to empower your SWFs, taking them further toward rich Internet applications, then you've come to the right place! Foundation ASP.NET for Flash will teach you everything you need to know to integrate two of the most exciting technologies used on the Web today. Using Flash and ASP.NET, it's possible to utilize the amazing user interface capabilities of Flash along with the extensive power of ASP.NET to create dynamic, data-driven web applications. In this book, advanced topics are made easy by providing intuitive step-by-step examples. This book covers Flash MX 2004 and Flash 8, ASP.NET 2.0, Visual Studio 2005, and Access and SQL Server 2005. It is an essential part of any Flash or ASP.NET web developer's arsenal.
Fast Track to MDX
Fast Track to MDX gives you all the necessary background to let you to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems.
Expert SQL Server 2005 Development
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.
Building a Data Warehouse : With Examples in SQL Server
The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.
Beginning xml with C# 2008 : From novice to professional
Beginning XML with C# 2008 focuses on XML and how it is used within .NET 3.5. As you'd expect of a modern application framework, .NET 3.5 has extensive support for XML in everything from data access to configuration, from raw parsing to code documentation. This book demystifies all of this. It explains the basics of XML as well as the namespaces and objects you need to know in order to work efficiently with XML. You will see clear, practical examples that illustrate best practices in action. With this book, you'll learn everything you need to know from the basics of reading and writing XML data to using the DOM, from LINQ and SQL Server integration to SOAP and web services.
Beginning VB 2008 Databases : From novice to professional
Beginning VB 2008 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the SQL Server XML data type and the LINQ enhancements to the next version of Visual Basic. In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in Visual Basic 2008 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 3.5 and offers you the best contemporary practice in this core programming area, so that you'll find yourself using it in nearly all your .NET projects.
Beginning VB 2005 Databases : From novice to professional
Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.
Beginning SQL Server 2008 for Developers : From novice to professional
SQL Server 2008 is a first–rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You'll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy–based management system, and more.
Beginning SQL Server 2005 for Developers : From novice to professional
SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005. This book features practical steps to help you overcome issues youre likely to encounter. You'll learn to use SQL for querying, inserting, updating, and deleting data. You'll also learn how to back up and restore databases for basic administration in SQL Server.
Beginning SQL Server 2005 Express for Developers : From novice to professional
This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express, creating, backing up, and restoring databases, creating tables, then querying and manipulating them with T-SQL, coding stored procedures and triggers, and using Reporting Services to deliver information to end users.
Beginning SQL Server 2005 Express database applications with Visual Basic Express and Visual Web Developer Express : From novice to professional
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.
Beginning Databases with PostgreSQL : From novice to professional
The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. Key features such as transactions, stored procedures and triggers are covered, along with many of the capabilities new to version 8. To help you get started quickly, step-by-step instructions on installing PostgreSQL on Windows and Linux/UNIX systems are included. In the remainder of the book, we show you how to make the most of PostgreSQL features in your own applications using a wide range of programming languages, including C, Perl, PHP, Java and C#. Many example programs are presented in the book, and all are available for download from the Apress web site. By the end of the book you will be able to install, use, and effectively manage a PostgreSQL server, design and implement a database, and create and deploy your own database applications.
Beginning C# 2008 Databases : From novice to professional
Assuming only basic knowledge of C# 2008, Beginning C# 2008 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers. A comprehensive tutorial on both SQL Server 2005 and ADO.NET 3.0, Beginning C# 2008 Databases explains and demonstrates how to create database objects and program against them in both T–SQL and C#. Full of practical, detailed examples, it's been fully revised and updated for C# 2008 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience.
Beginning ASP.NET 2.0 Databases : From novice to professional
Beginning ASP.NET 2.0 Databases: From Novice to Professional is a comprehensive introduction to connecting a website to many different data sourcesnot just databases. You'll learn how to build a relational database, use SQL to communicate with it, and leverage both in your web applications. You'll also learn about the new features of ADO.NET and ASP.NET in .NET 2.0. The authors cover mission-critical issues, such as design, transactions, error handling, optimization, and scalability. They examine SQL Server, Jet, and MySQL databases, and highlight the differences among them.
Accelerated SQL Server 2008
The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the 2008 release of Microsoft's flagship database management system quickly. Take full advantage of the features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.
