Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
Thanks to everyone who attended today's MSDN webcast on Authorization, Privilege, and Access Control in SQL Server 2005. There were a lot of really great questions, and it was fun to be able to share a few insights into how to protect your data!
Several people asked for the code, so it is attached to this post. Feel free to leave me a comment if you have any questions or need some help with it.
For those who did not attend the webcast, you can still view it on demand, here.
And finally, thanks to all who entered into the raffle for a free copy of "Expert SQL Server 2005 Development!" Congrats to the winners, Kong Li, Igor Deck, and Steve Horth. For those who did not win, no worries--I'll be doing another contest next week in my MSDN webcast on Errors and Exceptions in SQL Server 2005. See you there!
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Adam Machanic
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.