Remote Remote Work
Working remotely can be more than working at home, which Steve thinks helps the work-life balance.
2022-10-21
144 reads
Telecommuting
2020-10-02
124 reads
The New Normal Annoyances
Steve talks a bit about the new challenges of working in a different environment and the challenges you might face.
2020-09-22
96 reads
2020-09-02
162 reads
The Benefits and Detractions of Remote
Working from home during the pandemic is likely to change many things, and Steve discusses a few today.
2020-06-11
118 reads
The Challenges of Working Under Quarantine
It's been nearly two months since the Redgate Software offices closed. I am not normally in the office, but I did cancel a trip that I normally would have taken to touch base with a number of teams. That's a minor change for me, but a still a change. It's much less than the disruption that […]
2020-05-28
117 reads
A Remote Work Guide
This week Steve talks a bit about working remotely, which is something more of us are doing these days.
2020-04-24
212 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
MediCopia Mobile Specimen Labeling Solution | Data Capture Solutions Ellington
The MediCopia Bedside Mobile Specimen Labeling Solution uses existing barcoded patient wristbands, Zebra ZQ610...
funny character shows in one hdg name in ssis flat file connector
hi, i spent some time today in an existing pkg replumbing 5 flat file...
Automating DAX Studio...
Still trying to figure out options for automating the export the result of a...
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