Technical Article

sp_DBCompare

This simple script make a comparison between two given database. It compare: The table present in both database            The data type, lenght, nullability, precision for each table.            The object present in both database. The StoredProc is able to compare database across different server, simple make […]

You rated this post out of 5. Change rating

2002-10-31

809 reads

Blogs

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

By

Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...

The Book of Redgate: Don’t be an a**hole

By

This was one of the original values: The facing page has this text: No...

Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise

By

For decades, enterprises have thought about data like plumbers think about water: you build...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Line number in error message doesn't match up with line number in code

By water490

Hi everyone I have a 1000 plus line query and I am getting an...

Building a RESTful API with FastAPI and PostgreSQL

By sabyda

Comments posted to this topic are about the item Building a RESTful API with...

Visit the forum

Question of the Day

A Common Split

What happens when I run this code:

DECLARE @s VARCHAR(1000) = 'apple, pear, peach'
SELECT *
FROM STRING_SPLIT(@s, ', ')

See possible answers