SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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…

Read more

0 comments, 1,182 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...

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…

Read more

0 comments, 2,019 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,…

Read more

0 comments, 541 reads

Posted in SQL Tact on 15 March 2012