With many companies trying to do more with less, it’s not uncommon for a database administrator (DBA) to find out they’ve just been...
Help – I’ve inherited yet another database!
read more
Bert Scalzo
Agile + Data Modeling = Greater Success
Let me start by saying that agile development is fundamentally sound and has serious merit. In may in fact be the best development methodology there...
Data Proximity for Data Warehousing Performance
Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs...
Data Modeling: Common Mistakes and Their Impact
“Dew knot trussed yore spell chequer two fined awl yore mistakes.” – Brendan Hills Although data modeling has been around for over 30 years, it...
What is NoSQL and Why Should I Care?
Many database professionals have historically worked with traditional relational database management systems (DBMS) such as Microsoft SQL Server,...
Does Database or Version Matter?
I’m sure you’ve heard the saying, “Never discuss politics or religion in polite company”. That’s good advice. This...
Simple Worthwhile Database Security Practices – Part IV
Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed...
Simple Worthwhile Database Security Practices – Part III
Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed...
Simple Worthwhile Database Security Practices – Part II
Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed...
Simple Worthwhile Database Security Practices – Part I
Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed...
Indexes: Friend or Foe?
No matter what database you’re working with, at some point performance becomes an issue which may require further investigation into possible...
What Happened to My Database?
Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common...
TEMP is A Four Letter Word
It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming...
Database Execution Plans Can Lie
Quote: Do not put your faith in what statistics say until you have carefully considered what they do not say. ~William W. Watt. I started this...
The Evolution of Database Tuning Approaches
Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per...
Managing Mountains of Data with the Cloud
When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was...