Mala's Data Blog

Data dictionary script

I restarted speaking with New Stars of Data today – I gave a talk on Database documentation. Below is the script I created to pull metadata into an excel...

2021-03-16 (first published: )

599 reads

Old but not gone…

I am part of a weekly talk show we run at the TriPASS user group, called ‘Shop Talk’. Shop Talk was the brainchild of Kevin Feasel, our key user...

2021-02-25 (first published: )

344 reads

Azure SQL Championship

There is no doubt that this is a time when we all have to be extra aware and work towards keeping our skills aligned with market needs. During this...

2020-10-13 (first published: )

280 reads

PASS – Meanderings

As most people reading this would know…the PASS organization is in a state of crisis now following the decision to go virtual. We are in a place where we...

2020-07-03 (first published: )

176 reads

Blogs

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021

By

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

Read the latest Blogs

Forums

Columnstore or not to columnstore?

By VoldemarG

Should we think about compressing tables like MyHugeTbl 200 million rows table which during...

How to check latency for user database.

By sizal0234

Hi, One of the user databases was in Not synchronizing / In recovery mode....

How to map out multi-level Supervisor/Employee relationship

By YSLGuru

No doubt this has already been answered and probably detailed many ways so I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers