As I was browsing Twitter today, I noticed a tweet from the Colorado Department of Transportation about their anti-DUI campaign. Shown below, it contains a bar chart that appears...
2021-09-08 (first published: 2021-08-19)
243 reads
Each resource type in Azure has a naming scope within which the resource name must be unique. For PaaS resources such as Azure SQL Server (server for Azure SQL...
2021-07-29
31 reads
In week 26 of Workout Wednesday for Power BI, I asked people to calculate the age of Nobel laureates at the time they received the award. I provided some...
2021-07-21 (first published: 2021-07-09)
361 reads
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data stored in the table at any point in time by storing an effective dated version...
2021-05-07 (first published: 2021-04-22)
168 reads
Control Flow activities in Data Factory involve orchestration of pipeline activities including chaining activities in a sequence, branching, defining parameters at the pipeline level, and passing arguments while invoking...
2021-04-06 (first published: 2021-03-25)
183 reads
I’ve been working on a project for the last few months with a client who has chosen to implement Dremio in Azure. Dremio is a data lake engine that...
2021-03-23 (first published: 2021-03-18)
98 reads
Question: When an activity in a Data Factory pipeline fails, does the entire pipeline fail?Answer: It depends In Azure Data Factory, a pipeline is a logical grouping of activities...
2021-02-25 (first published: 2021-02-18)
235 reads
Have you ever tried to use your browser to zoom in on a visual in a Power BI report? If you simply published your report and then zoomed in,...
2021-02-18 (first published: 2021-02-11)
437 reads
It’s common that users only have access to certain folders in an Azure Data Lake Storage container. These permissions are provided not through Azure RBAC (role-based access control) roles...
2021-02-09 (first published: 2021-02-04)
169 reads
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at a Time Video Series. It’s an effort to expand readers’ graphic literacy through short videos...
2021-02-03 (first published: 2021-01-27)
545 reads
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Hi Folks, I have been tasked with reviewing all the activity on a...
Comments posted to this topic are about the item The World of Data Science
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Ask SSC