Power BI Meets Programmability – TOM, XMLA, and C#
For anyone who read the title of this and immediately thought, “Oh no, I can’t do C#! Since when do I need to be in app dev to do...
2021-10-27 (first published: 2021-10-15)
280 reads
DataOnWheels
Power BI: Adding Columns to a Published Data Model using the XMLA Endpoint & TMSL
Goal of this demo: Update a Power BI model schema by adding a column to the data model without opening a PBIX file and ensure the scheduled refresh still...
2021-10-13 (first published: 2021-10-01)
155 reads
Last Non-NULL Date in SQL Server
The simplest of requests are often the most difficult to execute. For example, a finance team needs to know every time a customer did not invoice for 90 days...
2021-09-06 (first published: 2021-08-11)
498 reads
Connecting to Azure Blobs in Power BI
The step-by-step process below walks through connecting to data housed in Azure Blob Storage from Power BI using a SAS token. There are many ways to grab your data...
2021-08-11 (first published: 2021-07-26)
414 reads
Moving Synapse Databases Between Subscriptions – Practical Guidance
One of the tasks, we often do with migration projects is move large volumes of data. Depending on how you are configured, you may need to do the migration...
2021-06-16 (first published: 2021-06-01)
707 reads
Power BI: Making Date & Time Keys
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be done with built in functions in the Power Query editor. Quick call out, if you...
2021-01-26 (first published: 2021-01-18)
347 reads
Power BI: Data Model Optimization
Saving the Day from Delay Part 1 Optimizing your data model can be a daunting task. If you read the intro to this series, you know one of the...
2021-01-19 (first published: 2021-01-13)
528 reads
Saving the Day from Delay: Recap & Series Kick-Off
Ironically, I’m a few months behind on a recap for my presentation on building and using a sustainable, dynamic date query in M code – Saving the Day from...
2021-01-12 (first published: 2021-01-05)
133 reads
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
38 reads
Welcome to 3Cloud …
A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....
2020-10-30 (first published: 2020-10-23)
211 reads
Blogs
Daily Coping 28 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The DBA as a helpdesk.
Every one and again you will see people asking What skill do you think...
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Update table FirstName & LastName from Email addresses
I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...
SQL Instance Aliases - Urgent assistance needed please
I have a migration problem. I cannot get my SQL Server instance aliases to...
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
Ask SSC