First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst.
2025-12-22
Learn about a free inventory tool to help you keep track of basic information on your servers.
2025-07-04
5,621 reads
Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your DevOps pipeline and processes risks application performance, data security and integrity. With Flyway, Redgate solves this challenge in one complete solution that sits inside your existing DevOps platform and processes. Find out the 10 reasons why organizations worldwide choose Flyway.
2023-08-28
Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud.
2023-08-25
Database monitoring is an essential part of database development and testing because it will reveal problems early and allow you to drill down to the root cause, as well as look for any worrying trends in behavior of the database, when under load. If you are delaying doing this until a database is in production, you're doing it wrong.
2023-08-21
Migrating to the cloud has many advantages… until you’re the one tasked with making it happen. There are a lot of considerations, and the key is to break it down into four steps, not one. Find out how you can manage the challenge of migrating to the cloud.
2023-08-14
Are you looking to modernize and migrate your data but have questions about the complex organizational challenges? We recently hosted the webinar: Overcoming Organizational Challenges in Data Modernization and Cloud Migration: A Guide for Senior IT Leaders. This blog post summarizes the conversation into 7 key points.
2023-08-07
This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like SQL Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users.
2023-07-17
If treated well, the database can be a major accelerator in your business’s efficiency. It can be the star performer in your migration to the cloud, in your move to micro services and other change initiatives. Find out how the database can be the hero in your digital transformation or change initiative.
2023-07-10
To get the most out of your PostgreSQL database, find out the six performance metrics that ought to be central to your PostgreSQL monitoring strategy.
2023-07-03
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers