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 […]
Archives de l’année : 2025
The year ahead for SQL Server: Ground to cloud to ...
As we begin a new year in 2025, many of you are looking at new projects, new applications, […]
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 […]
2024: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read […]
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 […]