we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?
Each person on a team, or even in a company, can contribute something. Steve Jones reminds us not to assume we are better than others because of our job.
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
I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...
This article shows you how to manage process control among multiple servers using a lightweight database utility
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.
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?
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
An interview with the Exceptional DBA of 2010, Tracy Hamlin.
When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers