Power BI Dashboards, Reports, and Datasets with the SQL Chefs
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...
2018-10-11 (first published: 2018-10-02)
2,995 reads
Bert Wagner
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...
2018-10-02
4 reads
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...
2018-10-02
12 reads
Shortchanged with International Money in SQL Server
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with...
2018-10-03 (first published: 2018-09-25)
1,741 reads
Shortchanged with International Money in SQL Server
Watch this week's video on YouTube
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with looks something like this:
DROP...
2018-09-25
5 reads
Shortchanged with International Money in SQL Server
Watch this week's video on YouTube
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with looks something like this:
DROP...
2018-09-25
5 reads
Extracting JSON Values Longer Than 4000 Characters
A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process...
2018-09-18
1,317 reads
Extracting JSON Values Longer Than 4000 Characters
Watch this week's video on YouTube
A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process had been working great:...
2018-09-18
9 reads
Extracting JSON Values Longer Than 4000 Characters
Watch this week's video on YouTube
A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process had been working great:...
2018-09-18
6 reads
Faking Temporal Tables with Triggers
This post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way...
2018-09-26 (first published: 2018-09-11)
2,484 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers