Session Materials for dataMinds Connect 2022
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
17 reads
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
17 reads
Yesterday I was facing an annoying issue. I have two Power BI datasets. Both connect to the same Azure SQL database, but with different SQL users (they have both...
2022-09-28 (first published: 2022-09-13)
187 reads
The summer holiday is almost over, and this means conference season will be back in full swing again. I’ll be speaking at a couple of events in the second...
2022-08-23
8 reads
I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was...
2022-08-17 (first published: 2022-08-04)
1,191 reads
I’m giving a free webinar for MSSQLTips.com at 11th of August 2022. The abstract: When building a data warehouse (DWH) in the Microsoft Data Platform stack, you typically have...
2022-08-02
28 reads
I was reading a SharePoint List using the “Get Items” activity in an Azure Logic App. I explain how you can create such a Logic App in the blog...
2022-07-15 (first published: 2022-06-27)
105 reads
Power BI field parameters are a new feature in Power BI Desktop, and it’s one of the best of the past months. In short, Power BI field parameters allow...
2022-06-17
113 reads
I’m very excited to announce I’ll be giving a session at the 15th edition of dataMinds Connect (in the beginning it was called SQL Server Day(s)). It will be...
2022-06-17 (first published: 2022-06-16)
13 reads
… with this one weird little trick 🙂 Sorry for the clickbait, but you can actually save a lot on ADF pricing if you design your pipelines carefully. And...
2022-06-01 (first published: 2022-05-11)
654 reads
At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into...
2022-05-25 (first published: 2022-04-20)
301 reads
In a previous post we went through how to use Docker Build Cloud to...
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
Comments posted to this topic are about the item Creating Statistics on XML
Comments posted to this topic are about the item Managing SQL Agent in Azure...
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers