A regression of the art of database development
Recent experts in Development techniques don't seem inclined to study the history of programming; There isn't that much that's new in the art of Unit Testing database development work
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
Exploring SQL Server table metadata with SSMS and TSQL
Phil shows how to start squeezing powerful magic from SSMS for doing a detailed exploration of the metadata of your routines and tables, In this third part to the series on exploring your database schema with SQL.
Be Your Own Expert
Learning to be the expert yourself might be the best support decision that you can make for your career and company.
Precompiling LINQ Queries
Did you know that by precompiling LINQ queries you might actually be degrading your app’s performance if you’re not careful? Julie Lerman explains how to ensure you’re not re-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.
Five Things to Trim From SQL Server
With a SQL-meme going through the SQL Server community this week, Steve Jones comments on the various suggestions and offers a way to get your voice heard.
Precious Ideas
Steve Jones talks about encrypting stored procedures and why it's a bad idea. And that it's a feature that should be removed from SQL Server.
The SSIS File Sweeper
Moving files around is a task that many DBAs need to accomplish. Whether as part of an import or export process, or just for administration purposes, this new article from JD Gonzalez can help you solve this problem.
Handling SQL Server Errors
This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions.
TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers