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 to see what the results would hold this year. How would inflation and layoffs impact the database world? Download the raw data here and sl …
FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent particulièrement, c’est probablement la raison pour laquelle l’article est plus long que prévu ! 1 – Introduction …
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in the standards is to make it behave as much like a base table as possible. Creating a View The syntax of course uses the CREATE keyword because it is pers …
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls that can lead to incorrect results. These issues may not always be immediately apparent, but understanding their causes will he …
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines
The post Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines appeared first on SQLServerCentral.
I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about optimizing all kinds of queries, tutorials on how to back up your database, tutorials on index internals, or even speaking at conferences. If you’re …
Customizing the Export and import of Parquet Files in SQL Server
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an ideal format for storing analytic data when it does not already reside in a native analytic data store, such as a data lake, data warehouse, or an Azure man …
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 often face challenges, particularly with file permissions.. One common error is the « Access Denied » error when one admini …
Comparing Groups for Similarities in Power Query – Using Cosine Similarity
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: What is table partitioning, and can it improve performance? Does its effectiveness depend on the un …
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 companies to ship applications. Are the apps perfect? Of course not – but they’re good enough to get to market, bring in revenue to pay salaries, …
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 fix. The fix doesn’t fit every workload or server, but for the limited use cases described below, it’s a simple configuration change. The general best practice …
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 in the warehouse is based on the Delta file format. Staying away from single transactions will keep the warehouse performing at its best. W …
Who’s Hiring in the Microsoft Data Platform Community? January 2025 Edition
Is your company hiring for a database position as of January 2025? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must in …