Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON
This article will demonstrate how to migrate via JSON, key-value pairs from a Python dictionary object to a SQL Server table.
2021-07-16
Additional Articles
Autoscaling in Microsoft Azure
The ability to scale up and down without maintaining extra hardware is one of the best cloud computing features. In this article, Mahendran Purushothaman explains autoscaling in Microsoft Azure.
2021-07-14
Mergers and acquisitions in Insurance
The insurance sector has seen a marked rise in mergers and acquisitions over the past 12 months, and although these can be an excellent way to leap beyond organic growth, M&As can result in challenges with technology. In this blog, COEO's James Boother provides some tips on how, with good planning, technologies can be a real advantage in your next acquisition.
2021-07-14
Best of Summit 2020
The Best of Summit 2020 series is now live! This curated series features a selection of the most-viewed content from PASS Virtual Summit 2020 to help you find relevant data platform training related to this year’s conference tracks. Best of Summit 2020 includes sessions from some of the top speakers in the data industry including Erin Stellato, Andy Yun, Melissa Coates, Pinal Dave, Hamish Watson, and many others.
2021-07-12
SQL Server Restore Database Options and Examples
In this article we look at different SQL Server backup types and schedules and the steps to take to properly restore a database.
2021-07-12
SQL Server and hyperconvergence
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
2021-07-09
The key to great database CI is disposable databases
Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.
2021-07-09
But we've always done it this way?
This statement can be the biggest hurdle in changing software development and deployment processes. So, the question comes up pretty frequently: How do you overcome it? Grant Fritchey explores techniques to understand and coach others towards change.
2021-07-07
Embed Power BI in Jupyter Notebooks
Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres demonstrates how to do that and also asks why.
2021-07-07
Testing Flyway Migrations Using Transactions
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it?
2021-07-05
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
ALAMAT BCA KCP Jatimakmur Telp:08218154393
WA:08218154393 Jl. Raya Jati Makmur, RT.001/RW.007, Jatimakmur, Kec. Pd. Gede, Kota Bks, DKI Jakarta...
ALAMAT KONTAK BCA KCP Cikarang Telp:08218154393
WA:08218154393 Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blk B, RW.6, Cikarang, Kec. Cikarang...
ALAMAT BCA KCU CIKARANG Telp:08218154393
WA:08218154393 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu, Cikarang Selatan,...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers