Click here to monitor SSC

Author Profile

Tony Davis

Tony Davis is an Editor with Red Gate Software, based in Cambridge (UK), specializing in databases, and especially SQL Server. He edits articles and writes editorials for both the Simple-talk.com and SQLServerCentral.com websites and newsletters, with a combined audience of over 1.5 million subscribers. You can sample his short-form writing at either his Simple-Talk.com blog or his SQLServerCentral.com author page.

As the editor behind most of the SQL Server books published by Red Gate, he spends much of his time helping others express what they know about SQL Server. He is also the lead author of the book, SQL Server Transaction Log Management.

In his spare time, he enjoys running, football, contemporary fiction and real ale.

Questions About SQL Server Transaction Log You Were Too Shy To Ask

You can give a deep-dive presentation about SQL Server's transaction log, and round it off by inviting questions. Your audience will stare awkwardly at their boots. Afterwards, to your surprise there will be a queue of questioners, and the questions are the ones they were too shy to ask out loud. Tony Davis answers these apparently simple, yet tricky questions. Read more...

Database Branching and Merging Strategies

Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free. How, from the practical perspective, can the database developer support the rapid development and delivery of features in an application? Versioning, branching and merging is part of the solution, but what about the rest of the solution? Read more...

Rapid SQL Server Database Deployment

With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software. Tony Davis explains. Read more...

Backup to the Cloud: The Silver Lining

Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery. Read more...

Eight Steps to Effective SQL Server Monitoring

If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly. Read more...

Performance Tuning with SQL Server Dynamic Management views - eBook Download

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. Read more...

SQL Server, PostgresSQL and Fish Curry

An interview with Adam Machanic, discussing hot new features of SQL 2005, stored procedures, fish curry and more Read more...

Editorial: a Guided Tour of the new Simple-Talk

A whirlwind tour of some of the Simple-Talks's new features, including article commenting, blogs and forums. Read more...

SQL Bundle 5: the developer's perspective

Last month saw the release of the SQL Bundle 5. Here, some key members of the Red Gate development team offer insight into some of the major new features, and the technical challenges they faced in implementing them. Read more...

Editorial: a new Simple-Talk

By the end of May we will have launched a brand new version of the Simple-Talk web site. In this article, I explain my vision for the new site, and talk about the process I went through to get it to the brink of launch. Read more...

On Microsoft CTPs and long release cycles

Microsoft’s CTP program can result in higher quality, more usable, and more secure products— but when badly managed, it can also cause confusion and fuel doubt. Read more...

Blog Talk

Tony Davis The Art of the Author

When tidying out an old cupboard a few weeks ago, one after another I casually tossed outdated, dusty technical books into a recycling box. I paused however, when I reached one particular book, on “ASP for Databases” with which I’d had some editorial involvement. At the time, it had seemed just another book, albeit a […] Read more...

 View the blog

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.