We should get help from vendors, as well as support, but what about innovation? Today's guest editorial from Brad McGeHee asks if the third party tool vendors for SQL Server are doing enough to provide value for the cost of their tools.
2009-10-06
50 reads
The next update for SQL Server has had a major release with the CTP of SQL Server 2008 R2. Brad McGehee is wondering if you've seen some of the enhancements that have been added to this new version.
2009-09-02
183 reads
With the proliferation of high availability & specialist online Backup companies, do we really have any excuses left to NOT have an offsite backup location, even if it is in the Cloud? Brad things not...
2009-08-10
136 reads
Brad reflects on the characters of the DBAs he's met in his life, and suggests a common thread running through them all.
2009-07-27
244 reads
Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...
2009-06-29
348 reads
Are user groups dying out in the age of the Internet? It seemed that way for awhile, but Brad McGehee gives some reasons why you should think about attending a meeting.
2009-06-09
221 reads
MVP Brad McGegee spends a lot of time talking to people at Microsoft. He's learned how to interpret thier language, and understand what they mean when using certain terms.
2009-05-27 (first published: 2009-05-26)
132 reads
MVP Brad McGehee explores the education of the typical DBA and what they have studied in the past.
2009-05-05
265 reads
A guest editorial by Brad McGehee talks about physical fragmentation and asks if you are concerned about it on your servers.
2009-05-01
532 reads
The advent of social networking has excited many DBAs, but is that a good thing? Does social networking help or hurt you in your career?
2009-03-30
164 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Comments posted to this topic are about the item More Funny SELECTs
Comments posted to this topic are about the item Reducing the Cycle Time
I've set up replication in my SQL 2019 environment in attempt to migrate SQL...
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