Archive | SQL Server Presentations RSS feed for this section

S3OLV User Group Presentation – AlwaysOn

When I was at the PASS Summit 2012 last November, a friend of mine Jason Brimhall (b|t SQL MCM and a lead author of this book) asked me to present my AlwaysOn – Finally, A Usable ‘Mirror’ presentation at the S3OLV SQL Server Users Group in Las Vegas in April 2013. I accepted. Fortunately, they [...]

Read full story Comments Off

Red Gate SQL in the City Austin

I am happy to announce that Red Gate invited me to speak at their multi-city, US tour of SQL in the City to provide free training to the SQL community. The event will be held on Monday October 1st, and I will be giving my popular AlwaysOn presentation. AlwaysOn is a kind of ‘super-mirroring’ for [...]

Read full story Comments Off

Denali AlwaysOn – Finally, A usable ‘mirror’!

I’ll be presenting at this months SQL Server User Group (UG) meeting of CACTUSS Central (www.cactuss.org) this upcoming Monday 9/19/2011. The location of the presentation is here. The abstract is below. Abstract In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not [...]

Read full story Comments Off

DBCC loginfo, VLFs and SQL2000 and earlier.

I was reading Paul Randall and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL [...]

Read full story Comments Off