A First Look at PostgreSQL Monitoring in SQL Monitor

PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime.

Getting Started with Ensemble AI Models in SQL Server

In this article, we look at an ensemble AI model which can be considered a collection of two or more AI models that complement each other to arrive at an outcome for a set of historical data.

SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

• Printed book:
  • US
• Kindle book:
  • US

PASS Data Community Summit 2023 registrations are open!

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.

Retrieving MySQL data from within Python

The approach you take when accessing MySQL will depend on the programming language you’re using and the connector you choose for interfacing with the database. Whatever approach you take, the same basic principles generally apply to each environment. You must establish a connection to the database and then issue the commands necessary to retrieve or modify the data.

Cache SQL Server Data in a .NET Web Application

One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.

PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL

Join us for the second webinar in our PostgreSQL 101 series.

As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time.

Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL.

SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability

Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable.

• Printed book:
  • US
• Kindle book:
  • US

REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.

The Journey to Team-based Development with Flyway

This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database.