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 41 to 60 of 82    Older >>
 

The Chain of Data Responsibility

Earlier this week, Jeff Atwood suffered the sort of misfortune we all dread: hard drive failure and no backups. Tony Davis discusses what can be learned from this in terms of the chain of responsibility for an organization's data.  Read more...
By Tony Davis 2009/12/21 | Source: SQLServerCentral.com | Category: database weekly
Rating: |  Discuss |   Briefcase | 118 reads

How Oslo can you go?

Some developers have reacted with dismay to the recent news that Microsoft’s Oslo project is being integrated into the SQL Server platform and renamed SQL Server Modeling. The overwhelming feeling seems to be that their DSL dream is being snatched away.  Read more...
By Tony Davis 2009/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

The Rich Rewards of Tuning SQL

The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.  Read more...
By Tony Davis 2009/11/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 273 reads

A Wish list for the Microsoft Flying Squad

Microsoft is very willing to lend its ear to new feature requests, but sometimes forgets to finish off the ones we've got.  Read more...
By Tony Davis 2009/10/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

DBAs and the Fear of Maintenance Plans

The Maintenance Plan wizard offers a quick and simple route to make sure essential database maintenance tasks are performed and scheduled. However, it needs to be used with a lot of care, and is no substitute for the judgment, experience and common sense of a flesh and blood DBA.  Read more...
By Tony Davis 2009/10/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 332 reads

Did Oracle buy MySQL by accident?

The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?  Read more...
By Tony Davis 2009/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 150 reads

DBAs and the Art of Diplomacy

Tony speculates on how a good DBA knows when to be... diplomatic.  Read more...
By Tony Davis 2009/08/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 149 reads

The Busman's Holiday

It's a holiday weekend, but for some DBA's it's hard to escape the unwanted clutches of IT...  Read more...
By Tony Davis 2009/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 65 reads

Music for DBAs

Tony Davis explains his theory on why developers and DBAs listen to very different types of music, while working, and offers his list of "classic tracks" for all DBAs.  Read more...
By Tony Davis 2009/07/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 282 reads

What is the Best Way to Test SQL?

Over the past five or so years, encouraging progress has been made with regard to testing .NET application code...I wish I could say that the same progress had been made with testing SQL.  Read more...
By Tony Davis 2009/07/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 502 reads

Barriers to Virtualization

Virtualization, and use of the 'cloud', will be essential to the deployment of new applications, but will existing applications will be quite so amenable?  Read more...
By Tony Davis 2009/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 268 reads

Why Object Databases will always be Tomorrow's Technology

For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?  Read more...
By Tony Davis 2009/06/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 315 reads

The Real SQL Server Experts

T-SQL is not a language to be admired from a distance for its grace, sophistication and integrity. It is a tool designed to allow "normal" developers and DBAs to build database business applications as smoothly and efficiently as possible.   Read more...
By Tony Davis 2009/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 341 reads

Method to the Madness

Instead of piling on more, often increasingly complex, tools, Tony believes what is needed is a clear roadmap and methodology for systematically addressing SQL Server Performance issues.  Read more...
By Tony Davis 2009/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 138 reads

Staring you in the Face

Tools expand, some might say bloat, at an alarming rate and it's often the case that, in amongst all the clutter, the most valuable features somehow elude us.   Read more...
By Tony Davis 2009/05/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

The Next Frontier of Performance Troubleshooting

The number of tools for troubleshooting SQL Server performance problems has recently expanded at a dizzying rate. Is the latest one any reason to get excited?  Read more...
By Tony Davis 2009/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 525 reads

The Disappearing DBA

During a "difficult period", a developer often sinks from view. When things are going well, suddenly they are the gunslinger, the hotshot. The DBA often looks on wistfully. For him, the "fame trajectory" seems to work in reverse.  Read more...
By Tony Davis 2009/04/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 1,057 reads

Do DBAs Still Read Technical Books?

Despite my misgivings about the fall from favor of technology books, I was heartened to hear from the developers at Red Gate that the classic books on the art of programming are still important to them. What are the equivalent books for DBAs?  Read more...
By Tony Davis 2009/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 287 reads

Guest Editorial: Short Transactions

It is ingrained in many developers and DBAs to keep transactions in SQL Server "as short as possible". Why does this mindset exist? Does it imply a deep-seated lack of confidence in the scalability of SQL Server's locking and concurrency models?  Read more...
By Tony Davis 2009/03/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 152 reads

What comes first, the application or the database?

Many of the concepts behind Domain Driven Design are noble and valid but the silo-based approach to development that inevitably springs from this philosophy gives Tony Davis cause for concern.   Read more...
By Tony Davis 2009/03/09 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 89 reads
<< Newer    Items 41 to 60 of 82    Older >>