Different Ways to Populate the List of Tables

This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.

How Effective Is Your Data Load Monitoring in SQL and Python?

Learn how you can use monitor your data warehouse load process with Python code and a structured process.

The New DBA is a Developer

Today Steve Jones says the lines between developers and DBAs is blurred.

Using SQLite with Flutter

Learn how you can build a basic Flutter application that interacts with a SQLite database.

Power BI Workspace Permissions and Roles

What are the Power BI workspace permissions and roles and how are they used?

Building Bonds with Entertainment

Over the years I've had the chance to work in a lot of companies, and I've seen a lot of different team-building attempts take place. In restaurants, these were often nights out with too many adult beverages. At a power station, we had some large outdoor BBQs, where again, sometimes there were too many adult […]

Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.

Analyze and Tune SQL Server Statistics

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that?

New Amazon X2iedn High-Memory Instances

Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and more memory per core than you can get in Azure’s managed SQL offerings.

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:

How to navigate PostgreSQL documentation
The essential things you need to know about PostgreSQL documentation
Other useful learning resources to help make your journey to using PostgreSQL easier

Please register to watch the recording.