Subscribe to this blog
Archives: March 2012
SQLSaturday #107 Houston
About 3 weeks to go until SQLSaturday #107 at YES Prep Public Schools - North Central Campus, 13703 Aldine-Westfield, Houston, TX, 77039! Register today if you haven't already!
Remember, in addition to traditional DBA topics, the event will have some topics of interest to developers that work with SQL…
Remember, in addition to traditional DBA topics, the event will have some topics of interest to developers that work with SQL…
0 comments, 409 reads
Posted in SQL Tact on 29 March 2012
FILESTREAM and Snapshot Isolation Mode in SQL 2008
FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.
In SQL 2008 R2 however...
http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot isolation has been extended to support FILESTREAM data. Under snapshot isolation mode, FILESTREAM data read by any statement in a transaction will be the transactionally consistent version of…
0 comments, 983 reads
Posted in SQL Tact on 20 March 2012
Security and Permissions presentation from the Baton Rouge SQL Server User Group Meeting, 3/14/2012
Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security. This is a ground-up look at SQL Server security principles and best practices surrounding them. The presentation also talks about application connectivity and authorization, stored proc and view security effects, ownership,…
0 comments, 239 reads
Posted in SQL Tact on 15 March 2012