Flyway with MariaDB for Those of a Nervous Disposition
This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
Working with SQL Server identity columns
SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.
Going Cloud Native
Lots of organizations are moving to the cloud, but having different levels of success. This change can be powerful and create tremendous opportunity, but it can also be a disappointment.
How to Enable and Disable Full Text Search for SQL Server Databases
Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.
Troy Hunt talks Security and compliance in estate monitoring
Troy Hunt joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance.
Connect to PostgreSQL as an External Data Source using PolyBase
PolyBase is a new feature of SQL Server that allows you to connect to relational and non-relational data. You can run queries on any external data sources you might have, such as Oracle, PostgreSQL, Salesforce, MongoDB, Hadoop, etc. When paired with the CData ODBC Driver for PostgreSQL, you get access to your PostgreSQL data directly […]
Growing and Keeping Up
Trying to keep up with technology is a losing game. Better to continue to grow and learn, balanced with the rest of your life.
What Is a Cost-Based Optimizer?
When you execute a query, the database server has to figure a lot of things out. For even the simplest queries, there are usually several possible ways to get the job done.
Learning Is Challenging, So, Forgive Yourself
In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]
To-do list: good, bad or indifferent?
Using a list to keep track of what you should work on is only as good as the plan or goal behind it.
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers