Technical Article

Advanced Search Stored Procedure

The script finds occurrences of string(s) in stored procedures, triggers and views. You can use typical boolean logic as described in the script comments. Very useful.  It was found on the companion cd to [Gurus Guide to Transact-SQL] by Henderson.  I left in the original credits.  Excellent procedure.  Some may scoff but I place it […]

You rated this post out of 5. Change rating

2004-07-15 (first published: )

651 reads

Technical Article

CSV Lists of Columns in Different Formats

This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements.  The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]

You rated this post out of 5. Change rating

2002-12-26

198 reads

Blogs

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs

Forums

Planes, Trains, and Automobiles

By Ryan Booz

Comments posted to this topic are about the item Planes, Trains, and Automobiles

How do I get a certificate for a SQL Server database?

By Doctor Who 2

I'm working on a new application at home, using SQL Server 2019 Developer Edition....

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers