How to grant PowerBI Service Workspace access using PowerShell
Learn how to more easily manage permissions in the Power BI service using PowerShell.
Database Testing in a Flyway Development
If you can test and evaluate databases, and database objects, at every phase of the database development lifecycle, then you are much more likely to be able to adopt continuous delivery. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix.
Working with MySQL stored functions
Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert Sheldon explains how to create and use a MySQL stored function.
Azure Data Factory Interview Questions and Answers
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
PostgreSQL Springboot Integration Using JDBC Template
Learn how you can use Springboot to automatically make data changes for a new database in an application.
The Nightmare Letter
The GDPR may bring nightmare letters like the one linked to from the editorial.
10 Benefits of Database Monitoring for Business Leaders [Video]
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of your business in ten key ways. Here's how a tool like Redgate SQL Monitor can save you money, time and assist with security and compliance concerns.
Advanced Databricks Lakehouse Capabilities
Learn about several different aspects of Databricks Lakehouse such as encryption, row level security, visually viewing query plans, SQL merge, change data capture and more.
Production Subsets
Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.
Stairway to SQLCLR Level 8: Using Visual Studio to Work around SSDT
In the final installment of this three-Level series, we use another automation-related feature to do what SSDT doesn't handle natively.
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