Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
222 reads
drsql@hotmail.com
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
104 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
128 reads
What Counts for a DBA: Baselines
It is very difficult to pinpoint what ails a server, just by looking at a single snapshot of the data, or to spot retrospectively what caused the problem by examining aggregated data for the server, collected over many months. The answer? Baselines.
2013-07-22
518 reads
What Counts for a DBA: Laziness
Louis Davidson is willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined.
2013-03-25
279 reads
Blogs
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Forums
Break string into SQL column regarding a specific character
Hi all, I want to separate string within a table column, accordint to a...
Importing Flat Files
Comments posted to this topic are about the item Importing Flat Files
The Fabric Modern Data Platform
Comments posted to this topic are about the item The Fabric Modern Data Platform
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers