Raiders of the Lost ADX – dataminds connect 2023
I’m very excited for this year’s edition of dataminds connect. It’s the first time I’m going to co-present a live session. My fellow explorer is the amazing bearded Johan...
2023-09-08
6 reads
I’m very excited for this year’s edition of dataminds connect. It’s the first time I’m going to co-present a live session. My fellow explorer is the amazing bearded Johan...
2023-09-08
6 reads
I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The...
2023-09-08 (first published: 2023-09-07)
4 reads
The Future Data Driven 2023 virtual conference is coming on September 27. Register today and save a note in your calendar. I have been honored to speak at this...
2023-09-07
10 reads
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)
146 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
39 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)
492 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
24 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
15 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)
101 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
63 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers