- Table View
- List View
Microsoft SQL Azure Enterprise Application Development
by Jayaram KrishnaswamyEach chapter starts with a general overview reviewing the software architecture related information or the underpinning programming concepts followed by an example of working with specific examples. This is then followed by a description of the specific software used in the chapter. The topics that require you to write code are fully explained using annotations and the code is presented in both VB and C# (in most cases). If you are a .Net developer, an architect, or a DBA who wants to develop enterprise applications and projects and extend your on-site skills with SQL Azure, then this book is for you. This book does not assume experience in Windows Azure or SQL Azure, nor is a high level of competency in SQL Server or the .NET Framework and associated technology required. However, a basic understanding of Visual Studio, C#, VB, SQL Servers, XML, web and WCF is required. If you decide to work with SQL Azure, then this book will provide you with the most up to date and practical information.
Microsoft SQL Server 2000 Database Administrator's Guidebook
by Carl H. SpeshockThis isn't just a start-to-finish guide to Microsoft SQL Server 2000 database administration. It's a practical guide for those migrating from Oracle® or Sybase®plus an indispensable resource for managers who must hire and supervise SQL Server DBAs. Carl H. Speshock defines the SQL Server DBA role by covering every DBA skill required to administer and manage robust, secure, and scalable SQL Server environments-- both technical and managerial.
Microsoft® SQL Server™ 2000 High Availability
by Allan Hirt Cathan Cook Frank Mcbath Kimberly TrippGet the definitive reference to maximizing the availability of your critical, SQL Server 2000-based business systems. Developed by Microsoft field consultants who create and support high availability solutions every day, this practical guide explains how to plan, design, implement, and support highly available SQL Server 2000-based systems for both 32-bit and 64-bit environments. You get in-depth, end-to-end guidance--from evaluating availability requirements and capacity planning to implementing failover clustering, log shipping, replication, system backup and restore, system recovery, and other technologies and processes. Real-world scenarios illustrate the book's best practices in action. You also get a CD featuring evaluation software, planning worksheets, scripts, and other on-the-job resources. Discover how to: Evaluate technical, staffing, and budget requirements Plan and configure disk subsystems for performance and availability Configure Microsoft Windows® 2000 Server or Microsoft Windows ServerTM 2003 to optimize SQL Server 2000 availability Plan, implement, and maintain a base server cluster and Network Load Balancing Plan and configure failover clustering Use built-in log shipping features or code your own Create comprehensive backup and restore plans Choose replication methods for high availability--and expose replication architecture Develop prevention and disaster recovery strategies; sample runbook and scripts included on CD Minimize downtime for server upgrades and service pack installations Baseline performance and use availability-monitoring tools and techniques CDs feature: 120-day evaluation version of SQL Server 2000 Enterprise Edition Scripts for custom log shipping, backup and restoration, system monitoring, and other administrative tasks Sample disaster-recovery runbook Worksheets, checklists, and templates 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™ 2000 High Availability
by Microsoft CorporationEnsuring 24/7 database availability is crucial to your company's success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000-based systems up and running and secure with this in-depth guide, straight from the source.
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