Mapping Database File Objects and Fragmentation
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
When Do You Pull Your Hair Out?
Another adventure in the real world. Steve Jones tracks down a problem with locks on a live system. Read along and see how he works through the issues.
Terminal Services - A Couple Tips
We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.
Review of SQLDiff by Lockwood
Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.
Fixed Database Roles
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
Cluster That Index - Part 2
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
xSQL Object Public Beta
xSQL Object for Microsoft SQL Server has been designed with the DataBase Administrator in mind. Scripting, Comparing and even Synchronizing different objects like tables, views, stored procedures etc. is fast and easy.
Auditing DTS Packages
In this follow up article, Haidong explains how to audit DTS packages. While parts of it are specific to DTS, the general technique has many useful applications.
SQL DMO Poster in PDF!
Last year we did a project with Lumigent to create a DMO poster. Part of the agreement allows us to now distribute the PDF version to our readers. It's about a 400k file, print size is 24x36. We hope you DMO users will find it useful.
White Board, Flip Chart, or Notepad?
Andy discusses the low tech tools he uses at the office to convey problems and describe solutions. He also provides some interesting links you will want to browse.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
URL Safe or Not?
Comments posted to this topic are about the item URL Safe or Not?
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers