New Azure VMs that perform close to on-prem servers?!
Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...
2025-06-12
5 reads
ReviewMyDB
- Skills: Microsoft SQL Server, Microsoft Fabric, DevOps, C#
- Twitter: @ReviewMyDB
- Website: https://jefftaylor.io
- LinkedIn: https://www.linkedin.com/in/reviewmydb/
- Bluesky: https://bsky.app/profile/reviewmydb.bsky.social
Getting Started with SQL Server 2025 Public Preview: A Step-by-Step Installation Guide
A step-by-step guide to installing SQL Server 2025 Private Preview.
2025-06-04
3 reads
Uninstall PolyBase from SQL Server
If you have SQL Server 2019 or SQL Server 2022 installed with PolyBase and you try to install SQL Server 2025, it will fail during...
2025-05-24
40 reads
SQL Server Autogrowth Settings Changes
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
2024-02-01
3 reads
Testing Microsoft Fabric - Part 4
After several discussions with the Microsoft team and chatting with Sunil Sabat about the testing I was conducting, the conclusion was...
2024-01-03
4 reads
Testing Microsoft Fabric - Part 3
Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...
2023-11-30
3 reads
Testing Microsoft Fabric - Part 2
To quickly summarize where we are, we started testing Microsoft Fabric with a 10GB tar file, which took over 20 hours to extract, and now...
2023-11-24
4 reads
Testing Microsoft Fabric - Part 1
Shortly after Microsoft Fabric came out a few months ago, I created an account and started playing around. I love to push technology to...
2023-11-14
4 reads
Data Types - Does size really matter? - nvarchar vs. varchar
How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...
2023-08-18
6 reads
How To Identify The Grain
Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...
2023-08-16
4 reads
Blogs
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers