My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

Managing Change Data Capture T-SQL Tuesday #74

by James-Anderson-The-Database-Avenger

The Database Avenger

T-SQL Tuesday is here again. This month the host is Robert Davis (b | t)
The topic for T-SQL Tuesday #74 is...

2016-01-12

370 reads

Blogs

A New Word: Ghough

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By Matthew McGiffen

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By Meagan Longoria

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

ASCII value of certain column is null

When ASCII(Column) is null, what does it represent? Is this some kind of special/control...

Need to output table data into multiple CSV files

Hello, I created the below script to output 999 rows from SQL Server table...

Changing Database page Verify on a Database in an AG

I have a database on SQL 2019 in an Availability Group (AG) and I...

Visit the forum

Question of the Day

Backing Up a Restoring Database

See possible answers