TSQL Challenge 76 - Identify the sequence of accounting transactions
The challenge is to identify the sequence of accounting transactions.
How to Kill a Company in One Step or Save it in Three
The majority of companies that suffer a major data loss subsequently go out of business. Wesley David remembers vividly the day when the organisation he worked for found that they couldn't restore their data, and the subsequent struggles that ensued. Shoulda-woulda-coulda.
SQL Saturday #108 - Redmond
Come to a free day of SQL Server training on Feb 25, 2012 in Redmond, WA.
Create, Alter, and Drop Indexes: Stairway to SQL Server Indexes Level 12
Options and impacts when creating, altering and dropping an index
Programmers v Salespeople
This Friday Steve Jones asks whether you think the salespeople or the technical people are more important to the success of a company. And if they should be better compensated.
Use Dynamic SQL to Improve Query Performance
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
Solving a Problem Importing Integers Using Format Files
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
PASS Data Architecture VC presents On Beyond Zebra AdventureWorks OR where did I go wrong?
On Thursday February 16th at 12PM noon Central, Steve Simon will discuss “No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
Use Your Tools
It's easy to get stuck in a rut and not learn to use the new features and capabilities of your tools are they evolve. Steve Jones reminds you it's worth a little time investment to learn about your tools.
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers