The Professional Student
This week Steve Jones talks about the need for people working in technology to be professional students. Get a few ideas of what you can learn this week from Database Weekly.
TSQL Challenge 46 - Remove leading occurrences of the first character
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
Using INSERT / OUTPUT in a SQL Server Transaction
Frequently I find myself in situations where I need to insert records into a table in a set-based operation wrapped inside of a transaction where secondarily, and within the same transaction, I spawn-off subsequent inserts into related tables where I need to pass-in key values that were the outcome of the initial INSERT command. Thanks to a Transact/SQL enhancement in SQL Server, this just became much easier and can be done in a single statement... WITHOUT A TRIGGER!
Connection Strings 101
This article introduces connection strings and suggests using MDAC to easily write efficient connection strings for those new to SQL Integration.
Call in the Experts
Today we have an editorial from Feb 1, 2006 that is being reprinted as Steve Jones is on vacation. Steve talks about the need to call in a friend to check on the performance of the SQLServerCentral servers.
FREE! SQL Scripts Manager – a Christmas gift from Red Gate
Red Gate has released SQL Scripts Manager, a free tool containing over 25 scripts written by SQL Server experts, to help you automate common troubleshooting, diagnostic, and maintenance tasks.
Queries for SSC Community Participation
Bill Nicolich uses T-SQL to look at the community participation of people at SQLServerCentral.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers