Down Tools Week
Sometimes it's important for a developer or DBA to be given the opportunity to 'shake up their brain'. What falls out is almost always worth having.
2010-04-05
256 reads
Tony Davis
- Interests: football, modern literature, real ale
Double-Entry Bookkeeping for SQL Programmers
All defensive programmers should, in general, avoid unsupported techniques. However, there is a balance to be struck between adherence to 'best practice' approaches to SQL programming, and the need to get the job done. Perhaps certain critical code would benefit from use of the age-old practice of double entry bookkeeping?
2010-03-22
938 reads
Democratizing the Microsoft MVP Award
Tony Davis believes that it's time for a little more openness and democracy in the MVP award. In short, it's time to introduce community voting.
2010-02-08
131 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.
2009-11-30
82 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.
2009-10-19
53 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.
2009-10-05
349 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?
2009-08-17
325 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.
2009-07-07
309 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...
2009-07-06
71 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.
2009-07-01
535 reads
Blogs
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Forums
Networking Devices in Ellington, CT | Legacy Technology, Inc
In today’s connected world, a reliable network is the backbone of any successful business....
Cannot install development version.
A while into install I get a Microsoft OLE DB Driver for SQL Server....
More Funny SELECTs
Comments posted to this topic are about the item More Funny SELECTs
Question of the Day
More Funny SELECTs
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers