TSQL Challenge 72 - Calculate the Payroll Hours of Employees
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.
Administrating SQL Server Integration Services - Planning, Documenting and Troubleshooting
SQL Server Integration Services is an essential component of SQL Server, and designed to perform a variety of routine and occasional tasks. It majors on ETL tasks and for administrative jobs across servers. The DBA needs also to be aware of their role in optimising SSIS by planning, trouble-shooting, optimising performance, and in documenting installations.
All I want for Christmas
This Friday before Christmas, Steve Jones has a fun poll. What would you like for Christmas? Any fun, interesting, fascinating tech toys?
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Window Functions in SQL Server: Part 2 - The Frame
Fabiano Amorim continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented and when, and explaining the concept of the 'Frame' in a window function, with plenty of examples.
Display Complex Hierarchical Data with Server-Side Pagination
This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.
GOTO and T-SQL
Today we have a guest editorial from Phil Factor as Steve is on vacation. This piece looks at the complaints against GOTO and whether they are valid.
Backing Up a SQL Server Database Directly Onto a Remote Server
Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy
Red Gate Software announces DBA in Space competition winner
Find out who has been announced as the winner of Red Gate Software's DBA in Space competition.
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers