Join me for Dashboards in a Day
Seats are limited – act fast!
This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...
2015-02-23
1,244 reads
SQLDownSouth
Implementing Tabular Data Models: Microsoft Virtual Academy
Implementing Tabular Data Models
Date: November 11, 2014
Time: 9am?5pm PST
Where: Live, online virtual classroom:
http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models
Cost: Free!
Register today! (linkto: http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models)
What will you do...
2014-11-03
1,992 reads
2014-04-16
658 reads
2013-11-14
659 reads
Parameterizing an Excel Spreadsheet
I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...
2013-05-16
2,963 reads
The Tale of One Tabular Model and Excel 2013 with Multiple Power View Reports
SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...
2013-05-16 (first published: 2013-05-13)
3,434 reads
SSRS 101 – Your First Report
I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL...
2013-05-06
1,380 reads
Configuring PerformancePoint in SharePoint 2013
Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following...
2013-04-29
1,886 reads
Creating a Shared Dataset with Report Builder
I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically,...
2013-04-29
2,900 reads
SQL Lunch – GeoFlow: 3D Geospatial Visualization
Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.
Lunch Details
#75-GeoFlow:...
2013-04-25
1,427 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
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...
Fun with JSON I
Comments posted to this topic are about the item Fun with JSON I
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