Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag books Rss

Search for any content tagged books

<< Newer    Items 21 to 40 of 55    Older >>
 

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.  Read more...
By Gail Shaw, Tony Davis 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 3,118 reads

SQL Server Execution Plans, Second Edition by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.  Read more...
By Grant Fritchey 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 13,669 reads

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.  Read more...
By Jacob Sebastian, Sven Aelterman 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 321 reads

Free eBook: SQL Server Hardware

A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.  Read more...
By Press Release 2012/11/06 | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 5,405 reads

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.  Read more...
By Press Release 2012/12/25 (first published: 2012/10/30) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 17,521 reads

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,878 reads

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.  Read more...
By Kalen Delaney 2012/10/02 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 2,315 reads

SQL Server Backup and Restore

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Shawn McGehee 2012/03/26 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 11,305 reads

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Jonathan Kehayias 2011/09/29 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 20,752 reads

What SQL Server Books Do You Recommend

Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server  Read more...
By Brad McGehee 2011/08/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 342 reads

Free ebook: SQL Server Execution Plans

This free book is brought to you by Red Gate Software and Simple Talk Publishing. Why my query is running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this essential topic.  Read more...
By Press Release 2011/07/11 | Source: SQLServerCentral.com | Category: execution plans
Rating:  Rate this |   Briefcase | 5,971 reads

SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Glenn Berry 2010/12/03 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 9,921 reads

The Red Gate Guide to SQL Server Team-based Development

This book shows how to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possible to "normal" development.  Read more...
By Grant Fritchey 2010/10/21 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 4,480 reads

Performance Tuning with SQL Server Dynamic Management Views

This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements.  Read more...
By Tim Ford 2010/06/14 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 7,457 reads

Defensive Database Programming

Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.  Read more...
By Alex Kuznetsov 2010/02/19 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 7,559 reads

Exchange 2010 - A Practical Approach

Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use guide to this latest platform, full of useful examples and top tips for SysAdmins, both new and experienced.  Read more...
By Jaap Wesselius 2009/11/19 | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 1,031 reads

The Best of SQLServerCentral, Vol.7

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.   Read more...
By Steve Jones 2009/11/12 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 5,583 reads

Brad's Sure Guide to SQL Server Maintenance Plans

Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds.  Read more...
By Brad McGehee 2009/10/05 | Source: Red-Gate | Category: books
Rating: |  Discuss |   Briefcase | 7,032 reads

Protecting SQL Server Data

This book holds the key to "encryption without fear". In it, John Magnabosco sweeps away some of the misconceptions surrounding SQL Server's encryption technologies, and demonstrates that, when properly planned and implemented, they are an essential tool in the DBA's fight to safeguard sensitive data.  Read more...
By John Magnabosco 2009/09/03 | Source: Red-Gate | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 2,430 reads

SQL Server Tacklebox

Inside the SQL Server Tacklebox you'll find day-to-day tools and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster.  Read more...
By Rodney Landrum 2009/07/14 | Source: Red-Gate | Category: books
Rating: |  Discuss |   Briefcase | 6,406 reads
<< Newer    Items 21 to 40 of 55    Older >>