Speaking in Code

Sunday, April 10, 2011

SQL Saturday #68 and Other SQL Server info I've recently come across

Arie Jones gave two presentations at SQL Saturday that could really accelerate some better database management practices, especially in Change Data Capture:

Toshi Watanabe gave a nice presentation on how to implement row-level security in a relational data warehouse by using AD groups accessed through CLR integration. It puts the security maintenance burden in the hands of Application Admins and AD administrators. Beautiful.

Buck Woody explained that Azure is Platform-as-a-Service...as a developer/dba you only should have to care about code and data. This is not the same as Infrastructure-as-a-Service.

Chuck Lathorpe opened my eyes to some of the capabilities of transactional replication. Now I want to increase the amount of replication we're using at work. And, I want to try out initialization of the snapshot through restore.

Not part of SQL Saturday...although her name did come up as a valued resource....
I want to read and re-read this post by Kimberly Tripp....It's giving me a sinking feeling about some of the GUID-based data that has been pouring into my environments lately....:|
http://www.sqlskills.com/BLOGS/KIMBERLY/category/GUIDs.aspx

0 Comments:

Post a Comment

<< Home