Going beyond basic database knowledge to understanding the whys and hows behind the administration process, this book takes the reader through job responsibilities and planning to implementation and performance monitoring. Checklists are included to guide the reader through various tasks.

Sybase SQL Server 11 Dba Survival Guide

Computers & Technology

Rankins, Ray

Solomon, David S.

Tretter, Brian

Software

Sams.

Configure, tune, and exploit the full power of the MS SQL Server. Create a database to fit your needs Write efficient SQL queries Master transaction management Design indexes for query optimization Learn remote server management Secure your server and your network Replicate your database and manage it on various platforms Back up and restore your server Implement continuous database logs Learn ODBC programming Companion CD-ROM includes demos from leading vendors of SQL Servers accessory products. Microsoft SQL Server 6 Unleashed gives you the knowledge you need to run an efficient system. Explicit details, included software, and complete source code provide the foundation for this comprehensive volume. You'll master database objects, advanced SQL programming techniques, database and server optimization approaches, database design, replication, and much more! So, out the power of MS SQL Server under your command with Microsoft SQL Server 6 Unleashed!

Microsoft SQL Server 6 Unleashed

McEwan, Bennett Wm.

Garbus, Jeffrey R.

Woodbeck, Daniel

Programming

This comprehensive reference details the steps needed to plan, design, install, administer, and tune large and small databases. In many cases, the reader will use the techniques in this reference to create and manage their own complex environment. Users of Microsoft SQL Server 6.5 Unleashed, Second Editon will learn to: write efficient SQL queries; master transaction management; design indexes for query optimization; learn remote server management; secure their server and network; replicate their database and manage it on various platforms; back up and restore their server; implement continuous database logs; learn ODBC Programmingp; administer very large databases; put their database on the World Wide Web; discover the Query Optimizer; explore the SQL Server Distributed Management Framework; and improve the efficiency and reliability of their databases with DBCC.
<ul><li>CD-ROM includes source code, libraries, and administration tools</li></ul>

Microsoft SQL Server 6.5 Unleashed

Microsoft SQL Server 6.5 Unleashed, Third Edition will still include previous topics like:SQL Server Architecture, Transact-SQL Programming, Performance and Tuning, System Administration, Open Client Programming, SQL Server and the WWW, Meeting the expanded needs of readers based on feedback from newsgroups, the Microsoft SQL Server 6.5 Unleashed, Third Edition will cover new topics, as well as updated information on existing topics, such as: Expanded Web Coverage, Scalability issues, Features of Microsoft SQL Server 6.5, Enterprise Edition, Replication, ODBC , ADO, OLE DB and RDS, OLTP, Clustering, Data Warehousing, Large Memory Configurations, Additional Security Issues, Quick Reference, Certification.
<ul>
<li>Past editions of this title are already known in newsgroups as "the generally accepted, authoritative, third-party text"</li>
<li>Perfect for the database adminisrator who needs to master the knowledge of key database connectivity tools such as ODBC, ADO and RDS, as well as critical enterprise/scalability issues such as OLTP, data warehousing and clustering</li>
<li>Shows readers how to avoid potential pitfalls and gives techniques for troubleshooting</li>
</ul>

Steinmetz, Jeff

Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE.

Microsoft SQL Server 2000 Unleashed

Bertucci, Paul

Jensen, Paul

This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. <ul>
<li>Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities </li>
<li>Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell </li>
<li>Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects—from tables and indexes to stored procedures and triggers </li>
<li>Increase availability with clustering, database mirroring, and other features </li>
<li>Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization </li>
<li>Use SQL Server Profiler to capture queries and identify bottlenecks </li>
<li>Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor </li>
<li>Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery </li>
<li>Make the most of Analysis Services, Integration Services, and Reporting Services—especially Microsoft’s new R2 reporting improvements </li>
<li>Improve data security using Column-level and Transparent Data Encryption</li> </ul>
 CD-ROM includes: <ul>
<li>15 additional chapters </li>
<li>Code samples, scripts, and databases utilized within the book </li>
<li>Free version of SQL Shot (performance &amp; tuning software)</li> </ul>

Microsoft SQL Server 2008 R2 Unleashed

Gallelli, Chris

Silverstein, Alex T.

Buy the print version of¿ Microsoft SQL Server 2012 Unleashed and get the eBook version for free! eBook version includes chapters 44-60 not included in the print. See inside the book for access code and details. ¿ With up-to-the-minute content, this is the industry’s most complete, useful guide to SQL Server 2012. ¿ You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and samples you’ll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, .NET Framework integration, and much more. ¿ Authored by four expert SQL Server administrators, designers, developers, architects, and consultants, this book reflects immense experience with SQL Server in production environments. Intended for intermediate-to-advanced-level SQL Server professionals, it focuses on the product’s most complex and powerful capabilities, and its newest tools and features. <ul>
<li> Understand SQL Server 2012’s newest features, licensing changes, and capabilities of each edition 
</li>
<li> Manage SQL Server 2012 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell 
</li>
<li> Use Policy-Based Management to centrally configure and operate SQL Server 
</li>
<li> Utilize the new Extended Events trace capabilities within SSMS 
</li>
<li> Maximize performance by optimizing design, queries, analysis, and workload management 
</li>
<li> Implement new best practices for SQL Server high availability 
</li>
<li> Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery 
</li>
<li> Leverage new business intelligence improvements, including Master Data Services, Data Quality Services and Parallel Data Warehouse 
</li>
<li> Deliver better full-text search with SQL Server 2012’s new Semantic Search 
</li>
<li> Improve reporting with new SQL Server 2012 Reporting Services features 
</li> </ul>
Download the following from informit.com/title/9780672336928: Sample databases and code examples ¿ ¿

Microsoft SQL Server 2012 Unleashed

Cotter, Hilary

The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and examples you’ll need to install, monitor, maintain, and optimize the most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions. Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server. Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features. Detailed information on how to… <ul>
<li> Understand SQL Server 2014’s new features and each edition’s capabilities and licensing </li> <li> Install, upgrade to, and configure SQL Server 2014 for better performance and easier management </li> <li> Streamline and automate key administration tasks with Smart Admin </li> <li> Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups </li> <li> Strengthen security with new features for enforcing “least privilege” </li> <li> Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements </li> <li> Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures </li> <li> Control workloads and Disk I/O with the Resource Governor </li> <li> Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery </li> <li> Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse </li> </ul>

Microsoft SQL Server 2014 Unleashed

Silverstein, Alex

Sams Publishing

See the best price to sell, buy, or rent books by Rankins, Ray. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Rankins, Ray

See the best price to sell, buy, or rent books by Rankins, Ray. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Sybase SQL Server 11 Dba Survival Guide

Microsoft SQL Server 6 Unleashed

Microsoft SQL Server 6.5 Unleashed

Microsoft SQL Server 6.5 Unleashed

Microsoft SQL Server 2000 Unleashed

Microsoft SQL Server 2008 R2 Unleashed

Microsoft SQL Server 2012 Unleashed

Microsoft SQL Server 2014 Unleashed