Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error

SSIS: Conditional File Processing in a ForEach Loop

by Tim Mitchell

SQLServerCentral.com

Blogs

I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...

Mutexes in SQL

by Toby Harman

SQLServerCentral.com

Mutex

This article shows you how to manage process control among multiple servers using a lightweight database utility

The DBA Financial Analyst

by Steve Jones

SQLServerCentral.com

Editorial

Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing.

Security Auditing Matching Up Logins And Users

by Brian Kelley

MSSQLTips.com

Security

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

The Semantics of NULL in SQL Server 2008

by Adolfo J. Socorro, Ph.D.

SQLServerCentral.com

T-SQL

Learn the basics of NULL, what it is, and how to query for it in your databases from Adolfo Socorro. What NULL means, how to account for it, and how are expressions involving NULL evaluated

Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile

by Press Release

SQLServerCentral.com

Exceptional DBA

An interview with the Exceptional DBA of 2010, Tracy Hamlin.

When To Touch

by Steve Jones

SQLServerCentral.com

Editorial

When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.

Executing SSIS Packages Using DTExec

by Additional Articles

Database Journal

Integration Services (SSIS)

Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.

DMVs: are they worth the effort?

by Tony Davis

SQLServerCentral.com

Editorial

Many of the SQL Server DMVs still have a wild, unfinished feel but they are an incredibly useful tool for DBA, well-worth the sweat and toil required to learn and query them effectively.

A deadlock was detected while trying to lock variables in SSIS

SSIS: Conditional File Processing in a ForEach Loop

Mutexes in SQL

The DBA Financial Analyst

Security Auditing Matching Up Logins And Users

The Semantics of NULL in SQL Server 2008

Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile

When To Touch

Executing SSIS Packages Using DTExec

DMVs: are they worth the effort?

Blogs

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

The Book of Redgate: Don’t be an a**hole

Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

Line number in error message doesn't match up with line number in code

Building a RESTful API with FastAPI and PostgreSQL

Question of the Day

A Common Split