I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.
The post Don’t use DISTINCT as a “join-fixer” appeared first on SQLServerCentral.

This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
The post SQL Server and Python Tutorial appeared first on SQLServerCentral.

Speed of delivery and protecting data can often feel incompatible, but there are industry-proven database DevOps practices that bring them together in harmony.
Across each of these five key practices, there’s a theme of removing barriers and cognitive load for teams; but crucially, they are also putting safeguards in place to reduce the risks to production environments.
The post Five database DevOps practices for boosting team productivity appeared first on SQLServerCentral.

This article will explain why and how you can easily move tables to new schemas if the need arisees.
The post Efficient Table Migration to a New Schema in T-SQL appeared first on SQLServerCentral.

Read this article to find out if you still need to worry about SQL Server index fragmentation with modern hardware.
The post SQL Server Fragmentation Impact with Modern Hardware appeared first on SQLServerCentral.

Microsoft will be presenting a number of sessions at the PASS Data Community Summit 2023. Read about their plans for the event and register to come if you can.
The post Microsoft at the PASS Data Community Summit 2023 appeared first on SQLServerCentral.

There are good reasons why business leaders should care about their databases—and hidden costs for neglecting them. Our CMO, Kate Duggan, wrote about the risks and potential costs in this article on Bloomberg.
The post Why Database Discussions Have Moved From the Backroom to the Boardroom appeared first on SQLServerCentral.

The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
The post SQL Server Central Is Upgrading Our Servers appeared first on SQLServerCentral.