SQL Server OPTION RECOMPILE for Simple Queries
Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.
The Change Failure Rate
The number of times that you have a failure when deploying changes is a good metric to watch.
The Rise of Data Centers
There is still a huge demand for data centers, both from cloud vendors and private enterprises.
Why you should avoid Implicit Measures in your Power BI model
Learn about the differences and challenges with implicit and explicit measures in Power BI.
Data Documents and Common Sense
What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to get improved into unusable complexity, I’ll need to explain a bit of background.
Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation
Learn the basics of the T-SQL STUFF command.
Improved RCSI Ghost Cleanup in SQL Server 2022
An example of poor update performance under RCSI as compared with locking read committed. Details of an improvement in SQL Server 2022 that can help avoid the worst effects.
Blogs
How-To Convert Excel Date & Time to SQL
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
SQL in 2025: Still the King of Data
Data's the new oil, and SQL is your refinery. It's still the go-to language...
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Is it possible to create a parameter and use different datasets?
Hello, I have an SSRS report, version 2019, that has two parameters, which will...
Calculating Numerator and Denominator
Good evening, I have a rather peculiar issue while trying to calculate Numerator and...
Question of the Day
The AG Synchronous Replicas
In a SQL Server 2022 Enterprise Edition AG, how many replicas can be configured with synchronous commit mode?
See possible answers