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.
Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
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 […]
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.
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?
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.
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.
In this next level, learn how you can load data from Amazon S3 in Fabric.
Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.
By Steve Jones
A few years ago I stumbled on this video and loved it. That led...
I attended the PASS Data Community Summit held in Seattle in person this year...
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
I'm sure I've asked this question in either this forum, or another one, in...
I have made an empty DB called "HJEM_BB" I try to fill it from...
Comments posted to this topic are about the item How to Avoid Incorrect Results...
What happens when an AG secondary receives a log record from the primary?
See possible answers