Database Checkups
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
2014-09-29
218 reads
Editorials
I am no Asimov
Rodney Landrum on finding the inspiration you need, somehow and from somewhere, to get yourself out of a tight corner.
2014-09-29
129 reads
Testing in Production
The Apple fall keynote recently didn't work as planned, and it seems as though their systems weren't tested well enough.
2014-09-23
213 reads
Automate Yourself to a Coffee Break
A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off 🙂
2014-09-22
292 reads
Watson Freemium
IBM has released a free version of its Watson service to help people perform analytics on their data.
2014-09-22
114 reads
No Compelling Reason
Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.
2014-09-19
119 reads
The 10 (.5) Commandments for IT Professionals
A list of the commandments, or at least suggestions, that Simon Holzman sees as important for IT professionals.
2014-09-18
510 reads
A Dearth of Comments
Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?
2014-09-17 (first published: 2009-01-05)
529 reads
The Need for Auditing
Is C2 auditing widely used? Should it be more widely used? Steve Jones talks about the subject of auditing in today's editorial.
2014-09-16 (first published: 2008-12-08)
666 reads
Swallowing the Camel
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
2014-09-15
187 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers