Power BI encoding is a powerful optimizing option that is often overlooked because it’s not visible in neither the Power BI Desktop tool nor in Power BI Service. Natively,...
2023-09-07 (first published: 2023-09-06)
464 reads
The buzz around Microsoft Fabric has been growing steadily since its announcement. This game-changing platform unifies several critical Azure services, including Data Factory, Synapse, and Power BI, all under...
2023-09-07
61 reads
How to check if powershell is running as administrator with elevated privileges
In case it's not clear from the title, I am referring to...
2023-09-06 (first published: 2023-08-14)
515 reads
Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...
2023-09-06
28 reads
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...
2023-09-06
23 reads
This week, I was working with a client who requested I use the Segoe UI font in their Power BI report. The report contained a mix of core visuals...
2023-09-06 (first published: 2023-08-17)
106 reads
I ran across an interesting gotcha while trying to run a Flyway command from PowerShell. Specifically, the snapshot command and providing a parameter that is the snapshot.filename parameter. Someone...
2023-09-06
102 reads
One of the advantages of being on the Database Docs team at Microsoft is that I get to work with amazing people, which means we can respond quickly to...
2023-09-05
92 reads
Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...
2023-09-05
25 reads
Another option is coming to gain extended support for SQL 2012
If you still have SQL 2012 servers, you are probably aware that support...
2023-09-04 (first published: 2023-08-17)
261 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...