SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
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.
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.
William Shakespeare once wrote in the play Romeo and Juliet: “What's in a name? That which we call a rose, by any other word would smell as sweet.” It is a beautiful sentiment in that context, and even still you might say that there is some truth to this saying in a lot of ways. […]
This article will explain why and how you can easily move tables to new schemas if the need arisees.
Learn how you can configure an Azure Data Factory pipeline that is triggered by an email being sent to an address.
Today Steve looks at the case when one software developer finishes their work, but another doesn't. The challenge of reordering work is something that happens more and more as teams struggle to coordinate their efforts.
Read this article to find out if you still need to worry about SQL Server index fragmentation with modern hardware.
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers