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

Regular Columnist: Tony Davis

SQLServerCentral.com profile

   Items 1 to 20 of 77    Next 20 >>
 

BACPACs be gone: Managing real backups in Azure

While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.  Read more...
By Tony Davis 2013/04/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 23 reads

Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.  Read more...
By Tony Davis 2013/04/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,537 reads

Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput

This level takes a deeper look at how log fragmentation can affect the performance of operations that need to read the log, such as log backups, or the crash recovery process.  Read more...
By Gail Shaw, Tony Davis 2013/04/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,411 reads

Deploying Databases to the Azure Cloud: an extended plea

Is there a sound technical reason why SQL Azure can't support extended properties?   Read more...
By Tony Davis 2013/02/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 30 reads

DBA Hypochondria

It is easy to become overwhelmed by server symptoms (aka metrics), in the forlorn hope that the more we collect, the clearer a picture we'll assemble of what ails the server. We should, of course, be looking at the whole patient.  Read more...
By Tony Davis 2013/02/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

Password Insecurities

Tony Davis argues that the Standards and best practices exist to avoid being hacked, but implementing them requires time and investment and often there simply doesn't seem to be the will to do it.  Read more...
By Tony Davis 2012/11/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

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 2013/06/19 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 2,040 reads

Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth

This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.  Read more...
By Gail Shaw, Tony Davis 2012/11/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,678 reads

Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log  Read more...
By Gail Shaw, Tony Davis 2012/11/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,375 reads

Fragmentation Fear

Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?  Read more...
By Tony Davis 2012/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 247 reads

Replace existing Database? JFDI!

Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…  Read more...
By Tony Davis 2012/04/02 | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Data Compression Double Take

A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.  Read more...
By Tony Davis 2012/03/05 | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 168 reads

Data Compression Double Take

A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.  Read more...
By Tony Davis 2013/06/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 119 reads

Testing times

Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.  Read more...
By Tony Davis 2012/01/23 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Virtualization and the existential angst of the DBA

Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.  Read more...
By Tony Davis 2011/12/19 | Source: SQLServerCentral.com | Category: virtualization
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Gold in the Execution Plan hills

There's more information hidden behind those graphical plans than you might first suspect.  Read more...
By Tony Davis 2011/10/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 172 reads

Where are all the MVBs?

Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?  Read more...
By Tony Davis 2011/09/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Being an extremely productive DBA

In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.  Read more...
By Tony Davis 2011/07/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 221 reads

Cloud Barriers

I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of moving applications and databases into the clouds. How many DBAs work for companies that have done it or are seriously considering it? What are the deepest concerns?  Read more...
By Tony Davis 2011/07/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode

In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved  Read more...
By Tony Davis 2012/01/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,465 reads
   Items 1 to 20 of 77    Next 20 >>