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 …
2024: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been enjoying it so I did it every year afterward until 2019 and then restarted for 2023 (see 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, …
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, …
[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 my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I’ve wanted to do for decades. Let’s bring you al …
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 this year. 2024 Blog Posts with the Most Comments What’s Your Biggest Database Regret? Query Exercise: Fix This Computed Column Query Exercise: Find the Be …
Simple Talk 2024 Year in Review
Happy New Year to all of the Simple talk readers! What a year this has been. I just read a list of the things we did last year for an internal report, and I wanted to share some of the pertinent stats. This year we went through a project we called “Sim …
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 this release’s changes on just one hand! Well, assuming you were an alien with six fingers. I won’t even recap the most important changes – …
GUID in SQL Server
The post GUID in SQL Server appeared first on SQLServerCentral.