Tag Archives: T-SQL

SQL Prompt Quick Access to Helper Code

Posted on October 2, 2023 by way0utwest

We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post looks at quick access to snippets. This is part of a … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Prompt Quick Access to Helper Code

Quickly Creating a tsqlt Test for a Query

Posted on August 28, 2023 by way0utwest

One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if a chance or enhancement has broken anything. This usually requires a … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

ADS Copilot Experiments with XML

Posted on August 23, 2023 by way0utwest

I sent some code to a customer recently to help them decrypt some stored procedures. I sent a quick and dirty set of code, noting at the bottom that the results were in XML and needed to be extracted. The … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on ADS Copilot Experiments with XML

Decrypting Stored Procedures The Cumbersome Way

Posted on August 14, 2023 by way0utwest

I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to do this one. This post shows how I sent them some … Continue reading →

Posted in Blog | Tagged , , | 1 Comment