SQL Server 2012 Build List
A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU8 for SP3.
How to Resolve Merge Conflicts in Git for SSIS Projects
In this part of the tip, we'll show you how to simulate a merge conflict when using Git for an Integration Services project.
Optimize SQL Server estate monitoring with Redgate's SQL Monitor
How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?
Analyze Azure Cosmos DB data using Synapse Link and Power BI
Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]
Reassess Your Configuration
It's a good idea for anyone managing systems to periodically check them and see if anything needs to change.
Database version control: Getting started with Flyway
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works
How to Check SQL Server Version When Service is Not Running
In this article we look at several ways to find the version of SQL Server that is installed when the SQL Server service is not running.
Data Element Names and Scoping Rules in SQL
How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]
The Responsibility for Bugs
Today Steve wonders who should be responsible for software bugs, something of which we have no shortage of in our industry.
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers