Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Collapse
Featured Categories
1-16 of 16 Items < Prev | 1 | Next >
1. |  SQL Server Transaction Log Management By: Tony Davis; Gail Shaw Publisher: Red Gate Books Publication Date: 21-DEC-2012 Insert Date: 23-MAY-2013 Slots: 1.0 | Overview: SQL Server Transaction Log Management
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.
...
|
2. |  Under the Hood of .NET Memory Management By: Chris Farrell; Nick Harrison Publisher: Red Gate Books Publication Date: 19-DEC-2011 Insert Date: 23-MAY-2013 Slots: 1.0 | Overview: Under the Hood of .NET Memory Management
This book starts with an introduction to the core concepts of .NET memory management and garbage collection, and then quickly layers on additional details and intricacies. Once you're up to speed, you can dive into the guided troubleshooting tour, and tips for engineering your application to maximise performance. And to finish off, take a look at some more sophisticated considerations, and even a peek inside the Windows memory model.
...
|
3. |  SQL Server Execution Plans, 2nd Edition By: Grant Fritchey Publisher: Red Gate Books Publication Date: 12-OCT-2012 Insert Date: 21-MAY-2013 Slots: 1.0 | Overview: SQL Server Execution Plans, 2nd Edition
Every day the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? My response is the same in each case: have you looked at the execution plan? An execution plan describes what's going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the various tables defined in the query, which indexes it used, if any, how it performed any aggregations or sorting, and much more. It also estimates the cost of all of these operations, in terms of the relative load placed on the system....
|
4. |  SQL Server Concurrency: Locking, Blocking and Row Versioning By: Kalen Delaney Publisher: Red Gate Books Publication Date: 11-SEP-2012 Insert Date: 21-MAY-2013 Slots: 1.0 | Overview: SQL Server Concurrency: Locking, Blocking and Row Versioning
If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one process wait, sacrificing concurrency and performance, in order that in order that all can succeed, without destroying data integrity. Your application can have world-class indexes and queries, but they won't help you if you can't get your data, because another application has it locked. That's why...
|
5. |  The Art of SQL Server FILESTREAM By: Jacob Sebastian; Sven Aelterman Publisher: Red Gate Books Publication Date: 31-AUG-2012 Insert Date: 21-MAY-2013 Slots: 1.0 | Overview: The Art of SQL Server FILESTREAM
Storing large object data in the database offers a number of benefits, but introduces performance challenges. Conversely, storing large object data in the file system has overriding performance advantages, but fails to offer some of the basic data integrity, security and manageability features that are required for business data, and which SQL Server provides. Up to now, most people have adopted file system storage by necessity, and often struggled to overcome the associated shortcomings. This is exactly where SQL Server's new FILESTREAM feature fits in. We hope this book will get you...
|
6. |  Troubleshooting SQL Server: A Guide for the Accidental DBA By: Jonathan Kehayias; Ted Krueger Publisher: Red Gate Books Publication Date: 25-JUL-2011 Insert Date: 08-FEB-2012 Slots: 1.0 | Overview: Troubleshooting SQL Server: A Guide for the Accidental DBA We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we've been exposed to a few weird-and-wonderful SQL Server issues but, mainly, we've seen the same problems and the same misconceptions about how SQL Server works crop up time-and-again. This book is our attempt to describe, diagnose, and solve some of the most common problems associated with the currently-supported versions of SQL Server: SQL Server 2005, 2008, and 2008 R2....
|
7. |  Exchange 2010 SP1: A Practical Approach By: Jaap Wesselius Publisher: Red Gate Books Publication Date: 25-JUL-2011 Insert Date: 07-FEB-2012 Slots: 1.0 | Overview: Exchange 2010 SP1: A Practical Approach Exchange Server 2010 Service Pack 1 is the latest incarnation of Microsoft's Messaging and Collaboration platform, and is has a lot of new, compelling features. It is the seventh major version of the product, and it rolls out some important changes and plenty of small improvements. Even better, a lot of complex issues from previous versions have seen solved, or simply removed, making the administrator's life much easier! As a trainer and consultant, Jaap knows exactly how chaotic and frustrating major platform upgrades can be, especially when they need to happen seamlessly. Having watched...
|
8. |  By: Glenn Berry Publisher: Red Gate Books Publication Date: 06-JUN-2011 Insert Date: 11-AUG-2011 Slots: 1.0 | Overview: SQL Server Hardware
Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware. Many medium-to-large companies have completely separate departments that are responsible for hardware selection, configuration, and maintenance, and the DBA with no knowledge of hardware is often completely at their mercy. Likewise, many DBAs are also...
|
9. |  Inside the SQL Server Query Optimizer By: Benjamin Nevarez Publisher: Red Gate Books Publication Date: 07-MAR-2011 Insert Date: 11-AUG-2011 Slots: 1.0 | Overview: Inside the SQL Server Query Optimizer
The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to database developers and administrators alike. A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book...
|
10. |  The Red Gate Guide to SQL Server Team-based Development By: Grant Fritchey; Alex Kuznetsov; Mladen Prajdicm Publisher: Red Gate Books Publication Date: 15-OCT-2010 Insert Date: 02-MAR-2011 Slots: 1.0 | Overview: 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.
...
|
11. |  Performance Tuning with SQL Server Dynamic Management Views By: Louis Davidson; Tim Ford Publisher: Red Gate Books Publication Date: 01-SEP-2010 Insert Date: 02-MAR-2011 Slots: 1.0 | Overview: 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.
...
|
12. |  Defensive Database Programming with SQL Server By: Alex Kuznetsov Publisher: Red Gate Books Publication Date: 21-MAY-2010 Insert Date: 06-SEP-2010 Slots: 1.0 | Overview: Defensive Database Programming with SQL Server
The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings. 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.
...
|
13. |  Exchange 2010: A Practical Approach By: Jaap Wesselius Publisher: Red Gate Books Publication Date: 13-OCT-2009 Insert Date: 06-SEP-2010 Slots: 1.0 | Overview: 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.
...
|
14. |  By: John Magnabosco Publisher: Red Gate Books Publication Date: 21-SEP-2009 Insert Date: 02-SEP-2010 Slots: 1.0 | Overview: 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.
...
|
15. |  SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA By: Rodney Landrum Publisher: Red Gate Books Publication Date: 03-AUG-2009 Insert Date: 02-SEP-2010 Slots: 1.0 | Overview: SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA
Inside the SQL Server Tacklebox you'll find day-to-day tools, scripts 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.
...
|
16. |  Brad's Sure Guide to SQL Server Maintenance Plans By: Brad McGehee Publisher: Red Gate Books Publication Date: 18-JAN-2010 Insert Date: 27-JUN-2010 Slots: 1.0 | Overview: Brad's Sure Guide to SQL Server Maintenance Plans
In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer.
...
|
1-16 of 16 Items < Prev | 1 | Next >
©2013 Safari Books Online