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
132 reads
Hardware
2020-08-12
261 reads
2020-07-25
380 reads
Better Laptop Life
Intel is building hybrid processors, combining the power of the regular CPUs most of us use with Atom power saving technology.
2020-07-08
123 reads
Secure Enclave Concerns
A new security flaw in Intel SGX is found by researchers. This may or may not be a problem, but you should be aware.
2020-03-14
122 reads
Better Protection from Hardware
Today Steve looks at a research project from Microsoft that provides some better protection from firmware security issues.
2019-12-17
160 reads
2019-10-18
392 reads
Grounded
Some laptops are being banned from flights. This could be a hassle, but more, how can anyone tell if you have a banned one?
2019-08-29
410 reads
Lots of data in RAM
I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]
2019-08-17
245 reads
Changing Hardware
AMD has new chips coming out and Glenn Berry changes his recommendation against using AMD in SQL Servers.
2019-07-20
192 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers