Data Science Sanity Checks
Phil Factor on three "sanity checks" that any data scientist must perform in order to prevent businesses from interpreting data analysis errors, or fraudulent activity, as real trends.
2013-05-13
158 reads
Editorial
Better Coding, More Savings
The way we write code impacts our users, but it can also impact our wallet, especially in cloud computing. Steve Jones wonders how many people bother to profile and test their code.
2016-12-19 (first published: 2013-05-13)
379 reads
Visualizations
A picture can express a thousand words. That's a phrase that many of us understand well, and one we embrace when we try to present large amounts of data in reports and dashboards. This week Steve Jones asks you what visualizations you use.
2013-05-10
164 reads
A Broken Data Model
After a recent trip, Steve Jones noted a problem somewhere with the way airlines are handling passenger data.
2013-05-09
161 reads
Our Race with Machines
A future world where the machines rule, as shown in films like Terminator and the Matrix, isn't what most people want. However the fears of machines taking over much of our world are very real. Steve Jones thinks it's not as bad as you might believe.
2013-05-08
119 reads
Small Data
With all the talk about Big Data recently, Steve Jones looks at some of the issues with Big Data and how small data might be more important to you.
2013-05-07
183 reads
Microsoft Research
Research in industry can help a company leap ahead of it's peers. Steve Jones thinks this is a good idea for many companies to engage in and highlights some of the great work being done at Microsoft Research.
2013-05-06
97 reads
The State of the Cloud
The state of cloud computing is confusing and unstable. Steve Jones has a few thoughts about the good and bad things in this industry.
2013-05-06
114 reads
If you're confident about a change in your DB, triple check
Even planning allows for failure, sometimes you can't see everything else where you're standing.
2013-05-01
166 reads
2013-04-30
689 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
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