The Invisible Disk
Steve sees disk drives as shrinking to the point of being invisible to most of us.
2024-09-09
186 reads
Hardware
2024-06-17
189 reads
Portable Data Storage
Today Steve wonders if the technology for storage and data transfers has superseded the need for portable drives.
2024-01-15
125 reads
Building a PC
Steve has a few thoughts on building your own PC to help you with work or your career.
2022-06-10
230 reads
2021-04-28
101 reads
Will You Touch a Server Again?
Steve doesn't think he will ever work on server class machine again in terms of hardware. He wonders how many of you feel the same.
2021-02-17
127 reads
The Database Server Upgrade for Let's Encrypt
Let's Encrypt upgrades their database servers and publishes the details.
2021-02-01
113 reads
Data Analysis Without a Server
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
2020-08-25
123 reads
2020-08-12
256 reads
2020-07-25
368 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
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