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
2 reads
Jeff Taylor
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
3 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
2 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
2 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
2 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
4 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
3 reads
Disable Activity is Finally Available in Azure Data Factory!
Since I first used Azure Data Factory, I looked for the 'disable' option on an activity, and it wasn't there! I quickly went to the ideas...
2023-08-02
2 reads
Have You Reviewed Your Azure Storage Bill Lately?
At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the...
2023-06-16
2 reads
If You Can't Clone Yourself, Be Professional
This is going to be a rant. I'm just a bit frustrated. When organizers work hard to assemble an event, and speakers submit to speak, we...
2023-04-05
2 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers