GUID in SQL Server
This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.
Subscribing to a Great New Year
It is December 27, and the most significant day of the year for reviewing your life is quickly approaching. New Year’s Day is probably the most positive day of the year when people, in all manner of situations, think back to the previous rotation around the earth and decide what they will do better this […]
How to Repair Corrupt MySQL Tables
In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster recovery. MySQL is one of those database platforms which provides a lot of features and high performance. Just […]
On Looking and Acting the Part
Phil Factor's offers tips for longevity in the world of IT consultancy: listen well, humiliate no-one and convince others that it was their expertise that solved the problem.
SQL Server Forced Plans Overwite the Query Hash
A 16-year old SQL Server bug that means 'forced plans' have the query plan hash in place of the expected query hash. Includes an explanation and discussion of the term 'morally equivalent plan'.
Stairway to SSAS Tabular Level 5: Cleaning up Dimensions
In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.
Convert Excel Workbooks to CSV with Microsoft Fabric
For my new mission, I set out to convert a list of files from Excel to comma-separated values (CSV). We upload the original Excel files to a Data Lake in Fabric. We then need to convert a specific worksheet and move the CSV files to a different folder in Data Lake.
A gentle introduction to dbt
Over the past years, the tool dbt – short for data build tool – has become quite popular in the data engineering world for handling such an ELT process. dbt takes on the role of the “T”, meaning it’s responsible for transforming the data in a certain data store.
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
String Similarity I
Comments posted to this topic are about the item String Similarity I
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers