Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level. If you are familiar with any aspect of system administration, database roles are similar to groups in the world of Windows system administration. Just like a Windows group, when a user is [...]
SQL Server
Best practices for taking on the DBA role as a developer – Armando Prato covers the basics of what it takes to go from developer to DBA. This is a good article and one that’s very near and dear to my heart since I’m pulling myself away from the development world and into the [...]
SQL Server
Cloud Computing and me – TJay Belt delivers the best look at cloud computing that I’ve read yet.
Some interesting affects of Table Partitioning – Kent Tegels discusses some interest side effects of partitioning tables and indexes.
The N pillars of a well built database? – Louis Davidson is in the process of re-working his book [...]
I stole this from TJay Belt. It seemed like a nice change of pace from the SQL shenanigans to
1. Who was your FIRST prom date?
Didn’t go to prom (they don’t have them in Scotland), but I went to my high school dance with a girl named Ashley.
2. Do you still talk to your FIRST [...]
A few weeks after the PASS conference finished up, Blythe Morrow (the community coordinator for PASS) contacted me and asked if I would like to help form a chapter special interest group (SIG). I didn’t even need to think about it for a minute, I immediately agreed and am itching to get started.
The focus of [...]
