Dynamic measures are an effective way to avoid crowding your report with different versions of the same visual without using bookmarks. No disrespect to the versatility of bookmarks, but...
2020-06-29 (first published: 2020-06-16)
430 reads
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
I am very excited to announce that my daughter, Kristyna Hughes, will be joining the Data On Wheels team. Our fates and paths to this point seem parallel though...
2020-06-08
8 reads
Have you ever had this issue? You are trying to explore new features of SQL Server or you want to install the latest version for some testing, but SQL...
2020-02-17 (first published: 2020-02-10)
639 reads
My company, Pragmatic Works, is working through a Dynamics 365 migration. As part of that migration, we need reports. We have made the decision, seemingly obvious given who we...
2019-08-14
86 reads
Pragmatic Works is hosting a 2-day Power Platform online conference. If you are unable to get out to onsite conference but need some help with Microsoft Flow, PowerApps, or...
2019-07-15
14 reads
Last Post – SQL Saturday MN 2018 When last I wrote, it was after I spoke at SQL Saturday in Minnesota. I co-presented a pre-con with Josh Owen. Prior...
2019-04-30
11 reads
First, many thanks to the SQL Saturday and MNPass team for putting on another great event and letting me participate.
I...
2018-10-08
293 reads
Another major corporation has announced their decision to move to Azure. Perhaps you’ve heard of them? Walmart—yes, Walmart and Microsoft...
2018-10-05
281 reads
In today’s Azure Every Day post, I’d like to talk about something a little different from our normal posts, and...
2018-10-04
193 reads
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented...
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Ask SSC