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

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

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 | 199 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 | 228 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 | 70 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 | 8,307 reads

Stairway to Transaction Log Management in SQL Server, Level 4: Managing the Log in Simple Recovery Mode

Tony describes in more detail the SIMPLE recovery model, and the way it works, its advantages and disadvantages.  Read more...
By Tony Davis 2011/11/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,304 reads

Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery

This article discusses the different types of backup and recovery models and gives the essential facts that will guide you to being able to achieve a recovery of a database to a point in time.  Read more...
By Tony Davis 2011/09/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,749 reads

Stairway to Transaction Log Management in SQL Server, Level 2: A Brief Overview of Transaction Log Architecture

In order to make it easier to understand truncation, space reuse and fragmentation in the log file, Tony gives a brief explanation of how the transaction log works.  Read more...
By Tony Davis 2011/08/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,664 reads

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.  Read more...
By Tony Davis 2013/10/30 (first published: 2011/06/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 19,732 reads

DBAs on ACID

Any DBA who has been bitten by these subtle data integrity issues, or reports that erratically produce the wrong results, will know how much careful testing is involved in mitigating them.   Read more...
By Tony Davis 2011/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 241 reads

Let the optimizer drive

For many, there is something disconcerting in the idea of the Query Optimizer; they crave control, but it really is best to take a back seat and let the Optimizer do its job.  Read more...
By Tony Davis 2011/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 169 reads

Is hyper-threading still relevant for SQL Server?

There still seems to be a lot of fear, uncertainty and doubt, in the community, with regard to use of Hyper-threading (HT) with SQL Server workloads. So, how and when should it be used?   Read more...
By Tony Davis 2011/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 436 reads

RAID 5 and SQL Server

Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?  Read more...
By Tony Davis 2011/01/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 630 reads

How will SSDs change SQL Server storage arrays?

If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?  Read more...
By Tony Davis 2010/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 402 reads

Can I really drop that index?

You believe that an index is unused and so could be removed, and yet, your finger hovers nervously over the metaphorical "delete" button. You can't quite bring yourself to do it. Is it really safe to drop this index? Tony wonders if "invisible indexes" might solve this dilemma.  Read more...
By Tony Davis 2010/11/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 331 reads

DMVs: are they worth the effort?

Many of the SQL Server DMVs still have a wild, unfinished feel but they are an incredibly useful tool for DBA, well-worth the sweat and toil required to learn and query them effectively.   Read more...
By Tony Davis 2010/08/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 417 reads

Clustered Indexes? Sedimentary, my dear Watson

There is much sound advice suggesting that every table should have a clustered index, and that narrow, integer, ever-increasing columns, such as afforded by an IDENTITY column are the best choice. But is the sedimentary approach really the natural order of the day?  Read more...
By Tony Davis 2010/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 401 reads

Down Tools Week

Sometimes it's important for a developer or DBA to be given the opportunity to 'shake up their brain'. What falls out is almost always worth having.  Read more...
By Tony Davis 2010/04/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 143 reads

Double-Entry Bookkeeping for SQL Programmers

All defensive programmers should, in general, avoid unsupported techniques. However, there is a balance to be struck between adherence to 'best practice' approaches to SQL programming, and the need to get the job done. Perhaps certain critical code would benefit from use of the age-old practice of double entry bookkeeping?  Read more...
By Tony Davis 2010/03/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 318 reads

Democratizing the Microsoft MVP Award

Tony Davis believes that it's time for a little more openness and democracy in the MVP award. In short, it's time to introduce community voting.  Read more...
By Tony Davis 2010/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 125 reads
<< Newer    Items 21 to 40 of 82    Older >>