DataModels
131 views | +0 today
Follow
DataModels
Database models and database design
Curated by Tony Catalano
Your new post is loading...
Your new post is loading...
Scooped by Tony Catalano
Scoop.it!

Why NoSQL Does Not Mean NoDBA

Why NoSQL Does Not Mean NoDBA | DataModels | Scoop.it

Whether you like it or not, NoSQL is changing the world. Granted, it’s not even clear what NoSQL means sometimes, but there is no doubt that, for better or worse, we are in a renaissance of non-relational database systems right now. For me personally, I tend to ignore the hype, study these systems with a critical eye, and then deploy them where traditional RDBMS software struggles.

more...
No comment yet.
Scooped by Tony Catalano
Scoop.it!

SQL Server Perfmon Counters Tutorial | Brent Ozar PLF

SQL Server Perfmon Counters Tutorial | Brent Ozar PLF | DataModels | Scoop.it
Simple tutorial on how to use Performance Monitor to tune Microsoft SQL Server. I explain which processor, memory, and physical disk Perfmon counters matter.
more...
No comment yet.
Scooped by Tony Catalano
Scoop.it!

SQL Server 2005/2008 Setup Checklist | Brent Ozar PLF

SQL Server 2005/2008 Setup Checklist | Brent Ozar PLF | DataModels | Scoop.it
Best practices for SQL Server 2005 installation and SQL Server 2008 configuration covering service accounts, local security policy, partition alignment, more.
more...
No comment yet.
Scooped by Tony Catalano
Scoop.it!

Using NULLIF() To Prevent Divide-By-Zero Errors In SQL

Using NULLIF() To Prevent Divide-By-Zero Errors In SQL | DataModels | Scoop.it
To prevent this sort of error from being thrown, author Hugo Kornelis suggests using a NULLIF() in the divisor of the equation. NULLIF() takes two arguments and returns NULL if the two values are the same and can be used to turn the divisor from a zero into a NULL which, in turn, will force the entire equation to become NULL.
more...
No comment yet.