Add a new year partition before January data arrives by checking boundaries, preparing NEXT USED, splitting an empty range, and scheduling the work.
SQLAuthority News – Thank You to Blog Readers
Thank you very much to all my blog readers for reading SQLAuthority.com through 2007. I wish you the very best for the year 2008.
Setting Up Database Mail for Alerts
Setting up Database Mail for alerts means creating an account and profile, testing delivery, linking Agent, and checking the queue when mail stops.
Working With an Outsourced Database Team
An outsourced database team needs a clear scope, controlled access, useful reporting, and a plan to keep operational knowledge in house.
SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
ACID stands for Atomicity, Consistency, Isolation and Durability, the four properties every reliable database needs. Each one explained in a line or two.
SQL SERVER – Q and A with Database Administrators
My Q and A with Database Administrators from interviews in India: the technical questions we discussed and my opinion on each, with a link to the full article.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.