Just a few weeks to PASS on Tour and the Redgate Summit
It’s just a few weeks until the PASS Summit on Tour in New York City. This is the first event in the series, and I’m excited to go back...
2025-08-06
12 reads
Blog Posts
PostgreSQL Database Optimization: Shrinking Tables and Indexes Explained
PostgreSQL is a powerful open-source relational database system, but over time, its tables and indexes can become bloated due to frequent updates and deletions. This can lead to inefficient...
2025-08-05
54 reads
What a Summer Camp Kitchen Still Teaches Me
(2025-Aug-04) Taking my last week of vacation and then volunteering at a children's summer camp has been part of my plan since last year, when I did the same thing....
2025-08-05
35 reads
Slide Decks
Hello everyone! Just a quick note. I’ve removed all my slide decks from SlideShare. I found they were inserting ads into the slides and I didn’t sign up for...
2025-08-02
45 reads
Step-by-Step SQL Server Migration Using SSMS: Best Practices & Use Cases
Introduction Migrating databases can be a complex task, especially when dealing with large-scale systems or transitioning to cloud environments. The SQL Server Migration component in SQL Server Management Studio (SSMS) offers...
2025-08-01
162 reads
Build and Deploy Dockerize Python Application to Azure Container Instances (ACI) using Azure DevOps
As a software Engineer, I would like to deploy my Dockerized Python Application to Azure Container Instance (ACI) using Azure DevOps so that I can automate my workflow and...
2025-07-29
71 reads
Communications: Three Questions
The better skilled we are communications, the more likely we will be understood. Whether we're talking work colleagues or our families and friends, being understood is more important than...
2025-07-28
76 reads
Comparing Top AI Tools for Image and Code Generation
The post explores various AI assistants, highlighting their strengths and weaknesses in areas like coding and image generation. It emphasizes the usefulness of tools like CoPilot and Gemini for...
2025-07-28
79 reads
Navigating Modern Data Architecture: DW, Lakehouse, and Lakebase Explained
The report outlines the evolution in data management systems, transitioning from traditional siloed structures to modern integrated platforms. It compares Data Warehouses, Data Lakehouses, and Lakebases, highlighting their roles...
2025-07-28
282 reads
Zero Downtime SQL Server Upgrade: Best Practices for Seamless Migration
Upgrading SQL Server is a mission-critical task for DBAs, especially when the goal is zero disruption to application connectivity. Whether you’re modernizing for performance, compliance, or supportability, choosing the right...
2025-07-28
138 reads
Blogs
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...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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