Future Data Driven is Coming Sept 27 for FREE
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
11 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
11 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)
636 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
63 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)
532 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
31 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
25 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)
119 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
120 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
102 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
29 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers