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 84    Older >>
 

SQL Server Source Control Basics

Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.  Read more...
By Tony Davis, Rob Sheldon 2014/11/11 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

Swallowing the Camel

By Tony Davis 2014/09/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 136 reads

Mongo Jumbo Backups

Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.   Read more...
By Tony Davis 2014/02/03 | Source: SQLServerCentral.com | Category: database weekly
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Fighting Tooth and Nail for Performance

You need a SQL Server-based application that will work with huge amounts of data and must perform calculations of startling complexity. How far will you go to deliver the required performance?  Read more...
By Tony Davis 2014/01/06 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 116 reads

Relationally Divided over EAV

A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.  Read more...
By Tony Davis 2013/12/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 302 reads

Escape from ETL Hell

What often starts out as a simple, quick process, gradually expands over time, as developers use SQL Agent to schedule new data feeds, add more complex transformations...   Read more...
By Tony Davis 2013/10/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads

Great DBAs do <blank>

We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?  Read more...
By Tony Davis 2013/06/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 235 reads

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 | 26 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 | 5,546 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 | 5,283 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 | 60 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 | 102 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 | 79 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 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 3,118 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 | 7,896 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 | 4,186 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 | 290 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: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 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 | 170 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/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 153 reads
   Items 1 to 20 of 84    Older >>