When Times are Tough, Do You Rise to the Occasion?
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
249 reads
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
249 reads
Brad worries that with the advent and growth of social media, has come an increasing concern that today's private conversation may turn into tomorrow's world-wide Tweet.
2010-09-06
151 reads
Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.
2010-07-05
267 reads
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
2010-04-12
512 reads
How many of you are taking full advantage of SQL Server tools? Brad McGehee thinks the answer is "Surprisingly few", and suggests you take the time to learn, and eventually master, the tools which already come with SQL Server.
2010-03-08
472 reads
A guest editorial from Brad McGeHee today talks about maintenance plans and his new book.
2010-02-04
573 reads
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
617 reads
The SSMS maintenance plan wizard is shunned by many DBAs, but Brad McGehee has come to view it as a perfectly valid and viable tool, especially for part-time or accidental DBAs, or those just finding their feet in the role.
2010-01-11
238 reads
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
59 reads
Brad suggests some tips on how to maximize your professional development in 2010. Get a plan together now, and you'll make your life a lot easier.
2009-11-23
204 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; GOSee possible answers