How to View SQL Server Object Code Easily with sp_showcode

sp_helptext has served SQL Server DBAs for years, but it has its very obvious – and many – limitations: broken lines, missing triggers, no help with encrypted objects, to name just a few. That’s where sp_showcode comes in…

Find Missing SQL Server Data with NOT EXISTS

After years of writing T-SQL a certain way, changing can be tough. When comparing tables for missing rows, developers often use LEFT JOIN.

URL Safe or Not?

The Long Name

Common SQL Server Problems: Invalid Object Name

Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them.

Encoding URLs

Fixing the Error

T-SQL in SQL Server 2025: Encoding Functions

Learn about these new binary encoding and decoding functions in SQL Server 2025.

Generating Shape Bound Random Points in SQL Server

Random number generation is vital in computer science, supporting fields like optimization, simulation, robotics, and gaming. The quality, speed, and sometimes security of the generator can directly affect an algorithm’s correctness, performance, and competitiveness. In Python, random number generation is well-supported and widely used. In this article, we will look how to we can use SQL to do this.

Encoding NULL