Database migrations are where great product ideas go to die—unless you plan for SQL Server’s quirks and the realities of…
Browsing: SQL
It can be tedious to check what visual interactions have been configured in a Power BI report. If you have…
Introduction User Defined Functions is a new feature in PowerBI currently in public preview. There is a lot of buzz…
What if you could bring the power of AI into SQL Server without sending a single byte of data to…
There are some fundamental boxes that your reporting system must tick. The figures must be accurateA good reporting solution can…
When it comes to managing complex database environments, having the right monitoring solution is critical. That’s why I’ve relied on…
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation.…
Trust is the currency of the data economy. Without it, even the most advanced platforms and the most ambitious strategies…
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This one surprised me. This is part…
Indexes are fantastic when you’re reading data—and a tax when you’re writing it. Every INSERT/UPDATE/DELETE has to maintain each affected…