Magarity Kerns


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

437 reads

Blogs

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Installing missed items in SQL Server

By itmasterw 60042

Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...

Redesign of old Table

By bobski

Hi, I am working on an old database table which stores emails, including From,...

Deploy SSIS Package Error: "The selected folder does not contain package..."

By MattieG72

Hi All It seems TFS is not behaving itself! When I deploy a package...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers