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
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers