Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
208 reads
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
208 reads
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
149 reads
2014-11-24
155 reads
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
97 reads
Louis Davidson on why DBAs ought to do one thing, every day, that is scary.
2014-07-07
196 reads
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
112 reads
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
157 reads
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
121 reads
Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.
2013-09-02
123 reads
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
506 reads
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
You can find the slides for my session at Future Data Driven summit at...
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Good afternoon! Is there any type of documentation or process for failing over a...
Hi all, I have an SQL database table with events, and within it a...
Hi All, I have been trying to download a csv file which is produced...