Category Archives: standards

Dealing with DBMS Complexity

The Database Management Systems we use are becoming more complex – there can be no denying this basic fact of life. Each and every new version of your favorite DBMS adds new features, functions, and options that further complicate database … Continue reading

Posted in DBA, SQL, standards | Tagged , | Leave a comment

DBA Roles & Responsibilities: Constantly Changing

One of the biggest challenges I see these days for DBAs is the ongoing redefinition of their job roles and responsibilities. Oh, most people know the rudimentary aspects of the job, namely keeping your organization’s databases and applications running up … Continue reading

Posted in DBA, standards | 1 Comment

Web Resources for Data Management Professionals

The web offers a plethora of useful data- and database-related information… if you just know where to look for it. Continue reading

Posted in DBA, information, standards | 2 Comments

What Does a DBA Do?

There are many tasks that database administration (DBA) must perform to keep databases — and the applications that rely upon them — available and efficient. Continue reading

Posted in change management, DBA, SQL, standards | 30 Comments

Book Review: SQL Antipatterns (2010, Pragmatic Bookshelf)

SQL Antipatterns helps you to avoid the pitfalls of database programming. Continue reading

Posted in book review, SQL, standards | 8 Comments

Bad Database Standards, Part 7

Can you ensure that your software works together with all the pieces it should — even as you upgrade to new versions and releases? Continue reading

Posted in standards, tools | Tagged | 2 Comments

Bad Database Standards, Part 6

What’s In A Name? Today’s installment in the continuing saga of bad database standards revolves around naming conventions. I’d like to thank James Koopmann for giving me the idea to blog about this topic. James writes an interesting blog of … Continue reading

Posted in Naming Conventions, standards | 17 Comments

Bad Database Standards, Part 5

None Shall Pass! Rigidly adhering to a standard, any standard, without being reasonable and using your ability to think through changing situations and circumstances, is itself, a bad standard. If you happen to be a fan of Monty Python, then … Continue reading

Posted in DBA, standards | Leave a comment

Bad Database Standards, Part 4

…we need to create standards that control, prohibit, and limit the mass duplication of data… Continue reading

Posted in data integrity, standards | 4 Comments

Bad Database Standards, Part 3

Limiting The Number of Tables in “Online” Joins Today’s entry continues our on-going series on “bad” database standards. And the “bad” standard we’ll discuss tonight is a particularly nasty one. Although the general idea behind this standard might seem to … Continue reading

Posted in SQL, standards | 3 Comments