Flawed Data Integration
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
Power BI Report Builder Expressions - Date Functions
Learn about expressions and date functions in the Power BI Report Builder.
[Re-post] The 10 Benefits of Monitoring for Leaders
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
Recover Recently Closed Tab in SSMS
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
Building a PC
Steve has a few thoughts on building your own PC to help you with work or your career.
The benefits of database change management
Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.
One or Many Databases
When you have multiple clients in your application, do you want one or many databases?
Optimizing my.cnf for MySQL performance
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
Why Database Monitoring Tools are Important for Senior Leaders
Matt Gordon is a Microsoft Data Platform MVP and the Director of Data and Infrastructure at Rev.io. In this short video, he talks us through the 3 key reasons database monitoring tools are essential for him as a Director, and how they help him to lead a team successfully and productively.
Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers