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)
291 reads
DataOnWheels
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)
497 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)
123 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
29 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)
198 reads
Azure SQL Database Elasticity – Presentation Notes
This blog covers the content and points to the code used to create the demos in my Azure SQL Database Elasticity presentations. As of today, I have presented this...
2020-10-27 (first published: 2020-10-20)
212 reads
New Logo, More Family Contributions
Kristyna and I were looking for an update to our logo prior our sponsorship and speaking at the Minnesota SQL Server User Group (PASSMN) in September 2020. I had...
2020-09-03
11 reads
Your First Databricks Notebook
On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series. You can view that presentation here. As part of that presentation, I committed to give...
2020-08-26 (first published: 2020-08-13)
703 reads
Congratulations to Pragmatic Works – Microsoft Partner of the Year Finalists, Again
Pragmatic Works has done it again. Microsoft has recognized us for our work this year with two finalist awards — Power BI and PowerApps and Power Automate. This recognizes...
2020-07-14
28 reads
PASSMN June 2020 – Data Classification with SQL Server and Azure
I presented at the virtual Minnesota SQL Server User Group meeting on June 16, 2020. The topic was data classification with SQL Server 2019 and Azure SQL Database. Data...
2020-06-17
3 reads
Blogs
Snowflake in Azure
By Arun Sirpal
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that...
Regression Testing SQL Saturday Naming
By Steve Jones
I started a poll today on the naming for future SQL Saturdays. You can...
Daily Coping 9 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Kick starting Extended Events
We have no prior experience of using XE. Yes, our DBA group uses server...
Easing Back to the Office
Comments posted to this topic are about the item Easing Back to the Office
Ask SSC