Site Owners

SQLServerCentral.com site owners.


SQLServerCentral Article

Modifying MySQL data from within Python

In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.

2023-08-04

292 reads

External Article

Capturing the business value of Compliant Database DevOps

You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.

2019-10-14

External Article

SQL Clone for Unit Testing Databases

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.

2019-06-04

External Article

Safely Deleting Clones and Images during Database Development and Testing

Whenever you’re ready to refresh a test cell with the latest database version, you need a safe way to drop the current set of clones, and the parent image, without losing any unsaved work. Phil Factor provides a PowerShell script that automates this process so it runs in the time it takes to grab a coffee, after which can quickly deploy the new clones.

2019-04-19

Blogs

Elastic Jobs for Azure SQL DB

By

I know if you are a SQL Server DBA using Azure SQL DB, you’ve...

Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module

By

Full documentation on the Undercover Catalogue can be found HERE It’s been a while...

Familiar Sights

By

Yesterday was a long day in London. I arrived late in the am, and...

Read the latest Blogs

Forums

Find the problematic Sql Query Caused Application Crash

By RCRock

Hi, Is there anyway I can find out the sql script ran on a...

Full vs. Incremental Loads – Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Full vs. Incremental Loads –...

Restoring the Resource Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring the Resource Database

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers