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.
Importing a CSV into SQL Server Shouldn't Be This Hard
A frustrating time importing CSV files leads Steve to test the different options.
Improving DevOps Automation
Steve notes that his employer is re-evaluating their build and release process, in a true DevOps fashion to improve the way they build software.
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.
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.
An Introduction to Power BI
Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]
Enterprise Software
Building software in an enterprise is hard, and often, large organizations don't quite know how to do it.
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.
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.
Do We Need to Learn Linux?
An announcement on Windows containers has Steve noting that Linux might be a more desired skill in the future for SQL Server professionals.
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers