Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Guest Columnist: Tony Davis
SQLServerCentral.com profile
Items 1 to 20 of 40
Next 20 >>
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
|
89 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
|
37 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
|
90 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
|
108 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
|
110 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
|
49 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
|
148 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
|
381 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
|
90 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
|
179 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
|
274 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
|
92 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
|
64 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
|
345 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
|
984 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
|
224 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
|
81 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
|
43 reads
Instrumenting Code - Database Weekly (Feb 23, 2009)
In the Oracle world, great importance is attached to "instrumenting" your application code. However, it seems not to be an issue that is much discussed in SQL Server. Tony Davis wonders why...
Read more...
By
Tony Davis
2009/02/23
|
Source:
SQLServerCentral.com
|
Category:
Editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
121 reads
SQL Server Crib Sheet Compendium
As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.
Read more...
By
Tony Davis
|
Source:
SimpleTalk
|
Category:
books
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,135 reads
Items 1 to 20 of 40
Next 20 >>
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use