Using the CheckSum Function - SQL School Video
There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.
Using the Service Audit Object in SQL Server 2008
Brian Kelley looks at auditing in this article about SQL Server 2008 and the enhancements made in this version. The new Audit Object allows you to more easily determine what is happening on your SQL Server instance.
Create Backups without Breaking the Database Backup Sequence
This article shows how the COPY_ONLY clause can be used to ensure that an ad-hoc database backup do not break the backup sequence
The Best Computer
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
The Best Computer
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
The Best Computer
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
Useful Dates: The Many Uses of Date Tables
Brandon Galderisi brings us a new article that looks at how a table of dates can be useful in a SQL Server application.
Advanced Troubleshooting with Extended Events
SQL Server DBAs the world over have a problem that never seems to go away: troubleshooting, with the vast majority of troubleshooting being done to find a performance problem of some kind. Even the most carefully architected and tested application system will experience changes over time that can lead to significant performance issues.
Tutorial: SSIS best practices
Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.
Bypassing a Trigger - SQL School Video
Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers