I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He points out that often times, a quest for perfection means we don't move forward. We...
2024-11-22 (first published: 2024-11-12)
373 reads
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL Server Disaster Recovery. It'll cover all the typical methods built-in to SQL Server, with a...
2024-11-18
4 reads
It tells us to take the time to master the foundational basics of whatever technology we're working with. If we have mastered the basics in the past, it behooves...
2024-11-13
150 reads
If you are an introvert like me, events like the PASS Summit can call forth your social anxiety. I know this past week, I definitely felt it, even though...
2024-11-11
54 reads
Let’s start with the keynote. The biggest take away was how having to support multiple data platforms is growing and becoming the norm. This has been my experience and...
2024-11-08
10 reads
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
153 reads
A common theme in the PASS Summits I've attended is community and that's definitely true this year. It's one of the reasons I have loved coming when I can....
2024-11-07
21 reads
The last data centric conference I attended was the PASS Summit in 2019. A few months later, much of the world went on lockdown due to COVID. Since then,...
2024-11-06
16 reads
I am able to head back to Seattle for the PASS Summit this year. I would love to meet up with friends and colleagues. I shouldn’t be too hard...
2024-10-29
6 reads
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that the professor mentioned on the first day of class, but which most students don't start...
2024-10-23 (first published: 2024-10-10)
210 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...
Hello I need help identifying all records that have consecutive hours (time in order)...
hi, I have a table called Rules Create table Rules ( Id int ,...
I am currently upgrading a very old database running SQL Server 2008 to SQL...
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers