pointers, solutions and scripts for the SQL DBA
not intended to replace common sense

3/29/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 Server. We also have a full slate of BI sessions (Data Warehouse, Reporting, Integration Services, etc.) as well as several sessions which will focus on the newly released SQL Server 2012.

I will be giving my SQL Admin Best Practices with DMV's presentation in the DBA Track at 9:45 AM.

3/20/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 the data that existed at the start of the transaction.

3/15/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, the new Consolidated Databases in SQL 2012, and a ending bit on hashbytes vs checksum.

Click here to download the presentation and its accompanying lab