2015-12-21
309 reads
drsql@hotmail.com
Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
222 reads
What counts for a DBA: Responsibility
Whose fault is it if a database is hacked and its contents appear on a hacker’s site? Louis Davidson suggests that, regardless of limitations, the DBA always bears some responsibility.
2014-12-22
154 reads
2014-11-24
158 reads
A DBA at the Opera
In opera, tragedy or absurdity happens because the characters are incapable of standing back, and making a difficult decision. Instead, at every stage, they just drift towards their fate by taking the easy option. Don't let the same fate befall you, as a DBA.
2014-08-04
105 reads
DBAs and the Fear Factor
Louis Davidson on why DBAs ought to do one thing, every day, that is scary.
2014-07-07
206 reads
Just Enough know-how
As a professional, our knowledge of a given task should extend, at a minimum, one level deeper than is strictly necessary to perform the task. Anything deeper can be left to the ridiculously smart, or obsessive, or both
2014-05-12
113 reads
DBA Dreams
Louis Davidson on the small dreams that DBAs can nurture, each day, to elevate the drudgery of a seemingly banal task into a celebration of purpose.
2014-03-03
160 reads
What Counts for a DBA: Deduction
Like Sherlock Holmes, a DBA needs the sound deductive reasoning to pinpoint the root cause of a crime, in amongst a thousand interesting but irrelevant details.
2013-11-18
127 reads
What Counts for a DBA: Patience
Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.
2013-09-02
129 reads
Blogs
Why India’s NEW Tax Regime is a GAME CHANGER for the Job Market
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Forums
How to Choose the Right Tool for MS SQL to PostgreSQL Migration
Comments posted to this topic are about the item How to Choose the Right...
Adding Defaults
Comments posted to this topic are about the item Adding Defaults
Multiple Monitoring Tools
Comments posted to this topic are about the item Multiple Monitoring Tools
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers