This Data Saturday Event is being jointly developed by the Albuquerque Data Platform Users Group, Arizona Data Platform Users Group, and the Santa Fe Data Platform Users Groups. This event will include sessions on many Microsoft Data Platform related topics. Join us on May 15, 2021.
2024-01-09 (first published: 2021-05-14)
Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.
2024-01-09 (first published: 2020-12-01)
Our annual mental health and wellness day is slated to happen on 8th April 2022. We have a fantastic lineup,schedule as below. For more details on speakers and sessions refer to our blog post here.
2024-01-09 (first published: 2022-04-08)
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
2024-01-09 (first published: 2022-10-10)
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
2024-01-09 (first published: 2023-09-08)
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
2024-01-09 (first published: 2023-06-19)
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
2024-01-08
Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.)
2024-01-05
Learn how to pivot and analyze data in Power BI like you can do in Excel for fast and easy data analysis.
2024-01-05
I have published videos and articles before about Lakehouse maintenance. In this article I want to address a missing point for a lot of Fabric administrators: How to do maintenance on multiple lakehouses that are located in different workspaces.
2024-01-03
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item I Love Editorials
Hi everyone I have a 1000 plus line query and I am getting an...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers