- Table View
- List View
Microsoft® SQL Server™ 2000 Operations
by Microsoft CorporationDesigned for database administrators and system engineers, this guide provides real-world, task-based information and best practices for the day-to-day management of SQL Server 2000. It draws on the combined knowledge and experience of Microsoft Consulting Services (MCS), Microsoft's Internal Technical Support Group, and the SQL Server Developer Team--illustrating both the theory behind and the field-tested practices for improving database operations. Get specific instructions and recommendations for server monitoring, backup, verification of scheduled events, capacity planning, developer and end user support, and other key procedures--exploiting the lessons learned from real enterprise settings to improve team responsiveness and effectiveness and help avoid common errors. All PATTERNS & PRACTICES guides are--reviewed and approved by Microsoft engineering teams, consultants, partners, and customers--deliver accurate, real-world information that's technically validated and tested.
Microsoft® SQL Server™ 2005: Database Essentials Step by Step
by Solid Quality LearningGet the guidance you need to start designing databases--one step at a time. With this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server. Discover how to: Install and configure SQL Server 2005 Design database components with SQL Server Management Studio Apply a three-step modeling approach to design databases that meet business requirements Create, modify, and manage views Write user-defined functions and stored procedures using T-SQL Add, delete, and update information in your databases Work with data from custom applications and legacy systems Troubleshoot error messages and handle exceptions CD features: All practice exercises Code samples A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Administrator's Companion
by Burzin Patel Edward Whalen Marcilina Garcia Stacia Misner Victor IsakovGet your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator's reference details features and capabilities of SQL Server 2005--including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results. Discover how to: Perform an installation or upgrade, and configure it on the network Plan and configure the I/O subsystem and model system capacity Create and maintain databases, tables, views, and indexes Administer transactions, deadlocks, and isolation levels Manage users with logins, user IDs, schemas, permissions, and roles Implement failover clustering, log shipping, and database mirroring for high availability Manage and tune snapshot, transactional, and merge replication Administer SQL Server Analysis Services and Reporting Services Monitor, troubleshoot, and fine-tune performance Includes a CD with a fully searchable eBook. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Analysis Services Step by Step
by Hitachi Consulting<div xmlns="http://www.w3.org/1999/xhtml"><p>Your hands-on, practical guide to Microsoft SQL Server 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis and with this popular, learn-by-doing tutorial.</p></div>
Microsoft® SQL Server™ 2005 Analysis Services Step by Step
by Stacia Misner Hitachi Consulting Reed JacobsenTeach yourself the fundamentals of SQL Server Analysis Services--one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization. Discover how to: Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers Create dimensions and measure groups to build, browse, and modify OLAP cubes Design objects to handle unique financial analysis requirements Improve query performance with aggregations and user hierarchies Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes Manage role-based security and restrict data access Deploy and maintain a database in a production environment CD features All practice exercises and answer files Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Integration Services Step by Step
by Hitachi Consulting Scott Cameron Paul Turley Satoshi Iizuka Pablo Guzman Joe KaspizakTeach yourself the fundamentals of SQL Server Integration Services--one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data--and build solutions that support your business intelligence needs. Discover how to: Design and execute packages that transform data between files and relational databases Configure connection managers to access other data sources Create data flows that alter, split, match, and merge data Develop event-handlers and monitor package performance Encrypt sensitive information and control access to packages Customize script code to automate Control Flow and Data Flow tasks Debug, troubleshoot, and optimize packages CD features: All practice exercises Sample databases Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Reporting Services: Step by Step
by Hitachi Consulting<div xmlns="http://www.w3.org/1999/xhtml"><p>Your hands-on, practical guide to Microsoft SQL Server 2005 Reporting Services. Get started using Business Intelligence tools that simplify data analysis and reporting with this popular, learn-by-doing tutorial.</p></div>
Microsoft® SQL Server™ 2005 Reporting Services Step by Step
by Stacia Misner Hitachi ConsultingTeach yourself the fundamentals of SQL Server Reporting Services--one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization. Discover how to: Install and configure Reporting Services Author, manage, and access reports Create attractive, information-rich reports with the Report Designer Calculate values, organize information, and manipulate report data Build, deploy, and maintain a report model Render and distribute reports in various formats Implement role-based security to restrict access to information Explore more advanced report design techniques Programmatically customize any stage of the reporting lifecycle CD features all practice exercises. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft SQL Server 2008 Administration with Windows PowerShell
by Yan Pan Ananthakumar MuthusamyThe definitive guide to automating SQL Server admnistration with Powershell scriptsIf you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server.You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort.The new release of Microsoft SQL Server 2008 now includes Windows PowerShell, allowing administrators of large-scale enterprise databases to automate many tasksSQL Server 2008 Administration with Windows PowerShell introduces you to PowerShell, covering its components in detail as well as providing basic instruction in using scripts to administer the database The book includes numerous examples of SQL tasks that have been automated and also provides completed scripts that you can put to use immediatelyThe Companion Web site includes complete code scriptsIf you're a database administrator, the scripts and techniques in SQL Server 2008 Administration with Windows PowerShell will save you hours of effort.
Microsoft® SQL Server® 2008 Administrator’s Pocket Consultant
by William Stanek<div xmlns="http://www.w3.org/1999/xhtml"><p>The fast-answers, daily administration guide to SQL Server 2008. 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.</p></div>
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant
by William R. StanekPortable and precise, this pocket-sized guide delivers ready answers for administering SQL Server 2008. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the focused information you need to solve problems and get the job done--whether at your desk or in the field! Get fast facts to: Plan, deploy, and configure SQL Server 2008 Administer server and surface security, access, and network configuration Import, export, transform, and replicate data Use SQL Server Management Studio for core administrative tasks Manipulate schemas, tables, indexes, and views Automate maintenance and implement policy-based management Monitor server activity and tune performance Manage log shipping and database mirroring Perform backups and recovery
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant
by William R. StanekFrom the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals. Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you'll want with you at all times as you deal with Microsoft® SQL Server® 2008 and SQL Server® 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now. Get fast facts to:Plan, deploy, and configure SQL Server® 2008 R2 Administer server and surface security, access, and network configuration Import, export, transform, and replicate data Use SQL Server® Management Studio for core administrative tasks Manipulate schemas, tables, indexes, and views Automate maintenance and implement policy-based management Monitor server activity and tune performance Manage log shipping and database mirroring Perform backups and recovery
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
by Robert D. Schneider Darril GibsonIf you're in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you'll find what's new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You'll discover how to:Build and maintain tablesDesign a database and communicate with itRetrieve, analyze, and report dataBuild solid, robust database applicationsUse the SQL Server Optimizer and Query DesignerNavigate SQL Server with Visual StudioDevelop useful reports with the Report Builder and Report DesignerCreate Business Intelligence solutions with Business Intelligence Development StudioConfigure your server and perform major administrative tasksTo help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks:Essential ConceptsDesigning and Using DatabasesInteracting With Your DataDatabase ProgrammingReporting ServicesAnalysis ServicesPerformance Tips and TricksDatabase AdministrationAppendixesMicrosoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!
Microsoft® SQL Server® 2008 Analysis Services Step by Step
by Scott CameronTeach yourself to use SQL Server 2008 Analysis Services for business intelligence--one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you'll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniques--direct from the companion Web site. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server® 2008 Analysis Services Step by Step
by Hitachi Consulting Scott CameronTeach yourself to use SQL Server 2008 Analysis Services for business intelligence-one step at a time. Work at your own pace through the practical, skill-building lessons and hands-on practice exercises on CD, plus get downloadable code samples.
Microsoft SQL Server 2008 Bible
by Paul Nielsen Mike White Uttam ParuiHarness the power of SQL Server, Microsoft's high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.
Microsoft SQL Server 2008 For Dummies
by Mike ChappleIf you're a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company's data management - read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You'll be able to: Develop and maintain a SQL Server system Design databases with integrity and efficiency Turn data into information with SQL Server Reporting Services Organize query results, summarizing data with aggregate functions and formatting output Import large quantities of data with SSIS Keep your server running smoothly Protect data from prying eyes Develop and implement a disaster recovery plan Improve performance with database snapshots Automate SQL Server 2008 administration Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!
Microsoft SQL Server 2008 High Availability
by Hemantgiri S. GoswamiWith clear step-by-step instructions, various real world examples, and plenty of screenshots, this book provides all the support and guidance you will need as you begin to install various SQL Server HA options. If you are an SQL Server developer, or a system administrator, or even a novice DBA, then this book is for you. It only requires you to have a basic understanding of how SQL Server works to get you through the installation of SQL Server HA.
Microsoft® SQL Server® 2008 Integration Services
by Erik Veerman Jessica M. Moss Brian Knight Jay HackneyAn authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them. Shows you how to design SSIS solutions for data cleansing, ETL and file management Demonstrates how to integrate data from a variety of data sources, Shows how to monitor SSIS performance, Demonstrates how to avoid common pitfalls involved with SSIS deployment Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages The companion Web site provides sample code and database scripts that readers can directly implement This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day.
Microsoft® SQL Server® 2008 Internals
by Kalen DelaneyTake a comprehensive look at the internals of SQL Server 2008 architecture and resource management, and understand how the product's internal structures affect application development and functionality.
Microsoft® SQL Server® 2008 Internals
by Kalen Delaney Conor Cunningham Paul Randal Kimberly TrippDelve 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 How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan--or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
Microsoft® SQL Server® 2008 MDX Step by Step
by Hitachi Consulting C Ryan Clay Bryan C SmithTeach yourself the Multidimensional Expressions (MDX) query language--one step at a time. With this practical, learn-by-doing tutorial, you'll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct and execute MDX queries Work with tuples, sets, and expressions Build complex sets to retrieve the exact data users need Perform aggregation functions and navigate data hierarchies Assemble time-based business metrics Customize an Analysis Services cube through the MDX script Implement dynamic security to control data access Develop MDX-driven reports in SQL Server Reporting Services CD features: Practice exercises Database and code samples Fully searchable eBook 's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server® 2008 MDX Step by Step
by Bryan Smith C. Clay Hitachi Consulting<div xmlns="http://www.w3.org/1999/xhtml"><p>Teach yourself SQL Server 2008 Multidimensional Expressions (MDX) language\u2014one step at a time. Work at your own pace through the practical, skill-building lessons and hands-on practice exercises on CD, plus get downloadable code samples.</p></div>
Microsoft SQL Server 2008 R2 Administration Cookbook
by Satya Shyam JayantyThis book offers practical, task-based, and immediately usable recipes covering a wide range of advanced techniques for administering a high-performance SQL Server 2008 R2 system. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in SQL Server and wants to improve. The book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order. Although the book is focused on specific Microsoft SQL Server 2008 R2, most of the concepts and explanations are also applicable to SQL Server 2008. If you are an experienced database administrator and database architect who wants to design, administer, and manage a scalable and high-performance SQL Server 2008 R2 system, then this book is for you. The book assumes that you have a good understanding of database management systems, specifically experience in Microsoft SQL Server 2008 administration.
Microsoft SQL Server 2008 R2 Master Data Services
by Tim Kent Jeremy KashelThis is a practical, step-by-step guide to managing and maintaining your master data and improving data quality with Microsoft SQL Server 2008 R2 Master Data Services, with practical examples on how to use each feature.If you are a business and systems analyst or database administrator who wants to manage and maintain your business master data and improve data quality with Microsoft SQL Server Master Data Services, then this book is for you. A basic understanding of Microsoft SQL Server is required. However, knowledge of Master Data Services is not necessarily required.