Magarity Kerns


Technical Article

Source system pre-integration analysis

Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, […]

5 (1)

2005-06-07

438 reads

Blogs

Daily Coping 7 Feb 2023

By

Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Creating a Flyway Desktop Shadow Database in PostgreSQL

By

In order to generate migrations, we need to configure Flyway to use a shadow...

Read the latest Blogs

Forums

Converting nested Json document to SQL data

By mandavli

I have response from a API that look like { "responseCode": 200, "message": "success",...

Converting nested Json document to SQL data

By mandavli

I have response from a API that look like { "responseCode": 200, "message": "success",...

To Drop or Not to Drop (the temp table question)

By Brandie Tarvin

So here's a thing that I've been told several times over the past few...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers