Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
SQL Schema Comparison with Visual Studio 2010
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?
Individual Contributions
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.
A deadlock was detected while trying to lock variables in SSIS
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
I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...
Mutexes in SQL
This article shows you how to manage process control among multiple servers using a lightweight database utility
The DBA Financial Analyst
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
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
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
An interview with the Exceptional DBA of 2010, Tracy Hamlin.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers