A DBA's Look at the Data Catalog
A data catalog is a way of classifying and adding metadata about the information in your database for compliance purposes. Take a look at how one DBA is using Redgate's Data Catalog.
2019-07-11
3,897 reads
Steve Hall
Explicit Transactions
There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.
2018-07-13 (first published: 2015-12-30)
10,910 reads
Blogs
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Daily Coping 3 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Forums
Installing missed items in SQL Server
Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...
Need to do it
Hi everyone! The inner world is very difficult, but you need to step over...
Redesign of old Table
Hi, I am working on an old database table which stores emails, including From,...
Ask SSC