Storage 101: RAID
RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.
Stairway to SQLCLR Level 6: Development Tools Intro
This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).
The Ease of Containers
Containers have changed how to develop and deploy software. They haven't caught on with databases as much, but Steve thinks this will change.
Getting Data In and Out of SQL Server Flyway Builds
Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing.
T-SQL Tips and Tricks
In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server
Distributed SQL Databases
There are new platforms out there that promise a distributed SQL relational database. Steve talks about a few today.
Reading a Specific File from an S3 bucket Using Python
This article shows how you can read data from a file in S3 using Python to process the list of files and get the data.
How to become a data scientist: A data-driven approach to careers in data science
Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches up skills to job titles.
Disclosing the How
As we use more Artificial Intelligence and Machine Learning tools in our applications, we need to understand how they work.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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...
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