SQL ConstantCare® Population Report: Fall 2025
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter
2025-11-17
SQL Server
2024-11-06
199 reads
SQL Server to PostgreSQL Database Schema Conversion
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
2024-03-13
Free SQL Server
There are a number of ways to run SQL Server for free (or low cost) for development. Read a bit about how to do this.
2024-02-23
7,097 reads
Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
2024-01-08
3,180 reads
Creating a Hyperscale Database in Azure Using the Azure Portal
One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.
2023-12-22
2,195 reads
2023-11-10
245 reads
SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
2023-11-06
19,837 reads
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
2023-10-30
4,631 reads
Profiler and Server Side Traces
Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.
2023-09-29
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers 