How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.
Simple(r) Coffee
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
The Weather Outside Is Frightful
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
Resolving Access Denied Errors During SQL Server Database Attachment
Learn how to resolve access denied errors when attaching databases in SQL Server. This guide explores file permission settings, focusing on the differences between Windows and SQL logins, and provides a step-by-step solution to prevent common attachment issues.
The Lesser Used Functions
There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?
Comparing Groups for Similarities in Power Query – Using Cosine Similarity
Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.
Adding the Right Value
Are you doing the things at work that your boss cares about or the things you care about? Steve has a few thoughts on this.
How to Load a Fabric Warehouse: Data Engineering with Fabric
In this next level, learn how you can load data from Amazon S3 in Fabric.
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.
Blogs
Grinding Away: Mary Spender
By Steve Jones
A few years ago I stumbled on this video and loved it. That led...
PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year...
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
Forums
How do I fix the, "Unable to process the existing user settings" error message?
I'm sure I've asked this question in either this forum, or another one, in...
Cannot restore new DB
I have made an empty DB called "HJEM_BB" I try to fill it from...
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item How to Avoid Incorrect Results...
Question of the Day
The AG Secondary Logs
What happens when an AG secondary receives a log record from the primary?
See possible answers