Denali AlwaysOn – Finally, A usable ‘mirror’!

I’ll be presenting at this months SQL Server User Group (UG) meeting of CACTUSS Central (www.cactuss.org) this upcoming Monday 9/19/2011. The location of the presentation is here. The abstract is below. Abstract In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not […]

POSSE Formed

We just had our formation board meeting for POSSE (sqlposse.com). Wes, Richard and Mike K. met in person since they arrived early to the monthly user group meeting, while I was conferenced in via phone. We did set the initial executive committee in this first meeting: President – Wes Brown Secretary – Richard Heim Treasurer […]

Best Practices for Database Schema Design (Beginners)

In this article, we will discuss a few common design decisions when defining a Schema. We’ll focus on the planning stage. There are many opinions about what is ‘best’. Here we discuss some basic guidelines which may or may not be best for your specific needs. There are two primary ways a database is used. One is Online Transaction Processing (OLTP) and the other is […]