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.
2009-05-20
155 reads
Tony Davis
- Interests: football, modern literature, real ale
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.
2009-05-18
88 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?
2009-05-04
573 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.
2009-04-06
1,125 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?
2009-03-23
444 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?
2009-03-18
177 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.
2009-03-09
401 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...
2009-02-23
510 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.
2009-02-10
12,266 reads
Guest editorial: Reasons to be Cheerful
The furore surrounding the recent release of MySQL 5.1 makes Tony Davis wonder if more than a few web 2.0 developers might be peering over the SQL Server Express fence and wondering if the grass doesn't look slightly greener over here.
2009-02-04
195 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers