2007-05-07 (first published: 2007-04-20)
265 reads
Scripts
Default Constraints with PRINT or DROP
To Retreive List of Default Constraints from current database with PRINT or DROP
2007-05-04 (first published: 2007-04-20)
573 reads
Quickly Reveal DB Recovery Model on all Databases.
I wrote this little tool out of the frustratingly slow process one must endure to find out what database Recovery Model your SQL 2000 databases are currently set to. This tool will quickly reveal whether your database Recovery model is set to either "Simple", "Full", or "Bulk-Logged." Who has time to manually pull up "Properties" […]
2007-05-03 (first published: 2003-03-06)
847 reads
An old and new way to query Hierarchical data
This script uses an old mathematical way of doing hierarchical queries. The most common way of showing hierarchical data in SQL Server is by creating a stored procedure that calls itself. This is not a recent problem, in fact this programming technique has been around since the first programming languages. By using stacks, you can […]
2007-05-02 (first published: 2004-02-17)
615 reads
2007-04-30 (first published: 2007-04-03)
1,710 reads
2007-04-27 (first published: 2007-04-03)
1,303 reads
Find the database by table name
Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]
2007-04-26 (first published: 2007-04-04)
527 reads
2005 Clean Indexes For All Databases on a Server
Check Indexes on all databases and rebuild/reindex based on fragmentation
2007-04-25 (first published: 2007-04-05)
1,490 reads
2007-04-24 (first published: 2007-04-05)
485 reads
Script to generate replication procs for article
This script is basically a front-end for the sp_"scriptproc" stored procedures that ship with MSSQL. This will allow you to create ALL of your procs (INS, UPD and DEL) on the fly using the article name instead of having to first search for the article ID. It also uses sp_scriptdynamicupdproc where appropriate. This facilitates quick […]
2007-04-23 (first published: 2007-03-27)
1,777 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers