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,801 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,219 reads
Blogs
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
[Video] Azure SQL Database – Import a Database
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
Forums
Inflow / outflow report per day
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
If SQL Agent Job takes longer than @X minutes, get notified.
If Agent Job takes longer than @X minutes, we want to be notified. What...
Unable to create report in VS 2017
I have downloaded and installed Visual Studio 2017 and can connect to SQL Server...
Ask SSC