Can AI Rewrite Bad Queries in Seconds? Kinda.
When I see horrific code, stuff that would take a lot of manual labor to fix, I like […]
Sites anglophones
How to Install SSIS in Visual Studio 2019
The post How to Install SSIS in Visual Studio 2019 appeared first on SQLServerCentral.
Why Standards are Important
Throughout my career I have seen arguments as to which IT standard in a particular area, is the […]
Pop Quiz, 2025 Edition: What Do These Things Cost Today?
Price check on Aisle 2025. My main consulting job is a 2-day SQL Critical Care® where I help […]
Nostalgic Memory Loss
Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am […]
Loading Models from Source Data with dbt
The data transformation tool dbt (data build tool) has become more and more popular over the past […]
Influencing a Local AI
I set up a local AI LLM to run and then conducted some experiments. This post shows a […]
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real ...
The post Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD appeared […]
MySQL Shell and Basic Configuration Management (Part 2 – Memory ...
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a […]
Using Snyk for CI/CD Security Scanning
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of […]
I’m Coming to Croatia!
A few things lined up perfectly for a European trip this summer. I’m on a European cruise in […]
Fabric Copy Job: What’s new in it
At first sight, the new Copy Job may seem only one more redundancy: Why do we need […]
Does Separating Data and Log Files Make Your Server Faster?
I’ve already explained that no, it doesn’t make your database server more reliable – and in fact, it’s […]
Announcing the 2025 Data Professional Salary Survey Results.
We’ve been running our annual Data Professional Salary Survey for almost a decade, and I was really curious […]
FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent […]
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions ...
Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls […]
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, ...
The post Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines appeared first on […]
I Wrote a Book on How You Broke Your Database ...
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]
Customizing the Export and import of Parquet Files in SQL ...
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an […]
Resolving Access Denied Errors During SQL Server Database Attachment
Introduction Database administrators regularly detach and attach databases as part of their daily tasks. During this process, they […]
Comparing Groups for Similarities in Power Query – Using Cosine ...
The post Comparing Groups for Similarities in Power Query – Using Cosine Similarity appeared first on SQLServerCentral.
[Video] Office Hours: Long Answers Edition
Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: […]
I Feel Sorry for Untrained Developers Using Entity Framework.
Most of the time, I love Entity Framework, and ORMs in general. These tools make it easier for […]
A Use Case for Memory-Optimized Tempdb Metadata
I recently had an interesting production SQL Server issue that turned out to be very easy to […]
SQL Server OPTION RECOMPILE for Simple Queries
The post SQL Server OPTION RECOMPILE for Simple Queries appeared first on SQLServerCentral.
How to Load a Fabric Warehouse: Data Engineering with Fabric
The data warehouse in Microsoft Fabric was re-written to use OneLake storage. This means each and every table […]
Who’s Hiring in the Microsoft Data Platform Community? January 2025 ...
Is your company hiring for a database position as of January 2025? Do you wanna work with the […]
Data Documents and Common Sense
The post Data Documents and Common Sense appeared first on SQLServerCentral.
Why you should avoid Implicit Measures in your Power BI ...
Everyone who has dabbled around with Power BI knows probably the concept of measures (if not, here’s a […]
Improved RCSI Ghost Cleanup in SQL Server 2022
The post Improved RCSI Ghost Cleanup in SQL Server 2022 appeared first on SQLServerCentral.
Leveraging the “STUFF” Function for Enhanced Data Representation and String ...
Abstract In the realm of data management and business intelligence, effective data representation becomes crucial for deriving actionable […]
Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways […]
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very […]
[Video] Office Hours in Tokyo, Japan
For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on […]
Your Favorite Blog Posts & Videos from 2024
The year is coming to a close, so it’s time to look back on your favorite stuff from […]
Simple Talk 2024 Year in Review
Happy New Year to all of the Simple talk readers! What a year this has been. I […]
Updated First Responder Kit and Consultant Toolkit for December 2024
If there was ever a release you could skip, this is probably the one, because you could count […]
GUID in SQL Server
The post GUID in SQL Server appeared first on SQLServerCentral.
How to Attach and Detach Databases in SQL Server
Introduction Managing databases in SQL Server requires a solid understanding of various methods for transferring and maintaining data. […]
Introduction to MySQL Shell and Basic Configuration Management (Part 1)
The database is an important part of any application and setting it up correctly is key to […]
Working Today? Take a Break to Fill Out the Annual ...
Working today? You’re not alone. As a small business person, I tend to find myself working on emails, […]
SQL Server Forced Plans Overwite the Query Hash
The post SQL Server Forced Plans Overwite the Query Hash appeared first on SQLServerCentral.
How to Repair Corrupt MySQL Tables
In the modern world, the companies are not solely dependent on a specific database server platform. There are […]
[Video] Office Hours in Kyoto, Japan
My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the […]
Convert Excel Workbooks to CSV with Microsoft Fabric
The post Convert Excel Workbooks to CSV with Microsoft Fabric appeared first on SQLServerCentral.
The Ebb and Flow of AI
It’s the end of the year. Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, […]
Frappe’s Configuration vs Laravel’s Code-Centric Customisation
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database […]
Attaching an SQL Server database without Transaction Log Files through ...
Introduction In SQL Server, the transaction log file is essential for keeping your database reliable and durable. It […]