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 …
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 model
Everyone who has dabbled around with Power BI knows probably the concept of measures (if not, here’s a good refresher). Measures are calculations using the DAX formula language (which kinds of resemble Excel formulas, at least the easy calculations do) …
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 Manipulation
Abstract In the realm of data management and business intelligence, effective data representation becomes crucial for deriving actionable insights. This is true specially when dealing with raw data, where inconsistencies and scattered information acros …
Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but understanding where Oracle has been and where it’s going is essential to us building the best products to support this ent …
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 few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, …