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
DataOnWheels
Power BI DAX Dynamic Measures
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
Data On Wheels – Merging Two Great Minds
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
Starting and Stopping SQL Server with PowerShell
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
Power BI, Dataflows, CDM, and Dynamics 365 – My Journey
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
Power Platform Conference – 7/23-24/2019
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
It’s Been a While …
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
SQL Saturday #796 – Minnesota, 2018
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
Walmart Chose Azure, How About You?
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
Azure IP Advantage
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
Blogs
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using Docker Volumes for SQL Server in Linux
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Forums
Pintable into cache
Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented...
stored procedure to delete user and login
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Ask SSC