SQLSaturday 461: Join Me For a Full Day of Performance Training in Austin

Join me Friday, January 29, 2016 for a full day of performance tuning training as part of SQLSaturday 461 in Austin, TX. Then stick around for the main event on Saturday where I will be among the many great presenters at the SQLSaturday event. My regular session on Saturday in the last slot of the day will be Strategies for Working with Texas-sized Databases. Learn more about the event: SQLSaturday 461 Register for the pre-con: Performance Tuning Like a Boss
read more

PASS Summit 2015 and SQLSaturday Oregon Sessions

PASS Summit 2015 is over and of course, no PASS Summit is complete without also attending SQLSaturday Oregon. Below are my session files from my half-day session on DBA’s Guide to Administering BI Systems at PASS Summit and Who has What to Which (The Permissions Superset) at SQLSaturday Oregon. PASS Summit Session Files: Demo code and slide deck: RobertDavis_DBAsGuidetoAdministeringBISystems_09012015.zip (1.9 MB) SQLSaturday Oregon Session Files: Demo code and slide deck: WhoHasWhattoWhich_ThePermissionsSuperset_Demo.zip (4 KB) Swag in my PASS Summit Session: Nerds
read more

Performance Tuning Pre-con and More at SQLSaturday 277 RVA

Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and 22, 2014. I will be delivering an all-day pre-con session, Performance Tuning and Troubleshooting Like a Pro, on Friday, March 21. The session is only $99 if you sign up before February 20. On February 20th, the price goes up to $125. Title: Performance Tuning and Troubleshooting Like a Pro Level: All levels Description: Do you wish you could turbo
read more

T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!

It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the greatest assemblage of geeks since the Tri-Lambda and Alpha-Mu mixer … this week. T-SQL Tuesday #41, hosted this month by Bob Pusateri (Blog|@SQLBob). You are invited to visit his blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme:
read more

SQL Saturday #198, Vancouver, BC Session Files

This past weekend was SQL Saturday #198 in Vancouver, B.C. It started off with a leisurely drive up to Vancouver on Friday and getting settled in to my hotel room. I was in the first slot of the day, and had a decent turnout despite the early hours. Whenever I have the first or last slot of the day (once I had both the first and the last slot of the day), I am always grateful that people get up
read more

SQLSoldier World Tour Kicks Off in 1 Week

The SQLSoldier World Tour kicks off this next Friday when I head up to Vancouver, in British Columbia, Canada. I will be doing 1 session on Saturday called Implementing Contained Databases. If you haven’t worked with this feature yet, I think I have quite a few things to tell you that you weren’t aware of (including 1 bug I files that’s supposed to be fixed in a future release). The MVP Summit is in Redmond, WA, right after the event,
read more

Recent Presentation Session Files

Recent Presentation Session Files I’ve been a little tardy about getting my session files posted, and I’m a little behind. So I’m going to try to catch up in one blog post. So here are my session files for SQL PASS Summit 2012, various recent SQL Saturdays, and 24 Hours of PASSe. Please let me know if I’m missing anything I promised to get posted. SQL PASS Summit 2012 Lightning Talk: Man Vs Machine: ManVMachine.zip (599 KB) Regular Session: Tempdb:
read more

Session Files from SQL Saturday #107 Houston

Session Files from SQL Saturday #107 Houston SQL Saturday Houston was a great event hosted by the Houston Area SQL Server Users Group. The event did not have a very large attendence, but those who traded in a beautiful Saturday for some free training were very engaged and we had very productive sessions. My session Files Strategies for Working with VLDBs: StrategiesforWorkingwithVLDBs.zip (5.3 MB) Replication Magic: Initializing from Backup: ReplicationMagic.zip (5.04 MB)
read more

SQL Saturday #107 in Houston, TX

SQL Saturday #107 in Houston, TX SQL Saturday #107 in Houston, TX is almost here. I will be leaving for Houston on Friday, April 13, and I’ll be spending the entire week preceeding SQL Saturday #107 in Houston visiting the headquarters of my new employer, Idera. One of the coolest parts of this trip is that I’ll get to see the other Idera ACEs (Advisors & Community Educators) and some of the new ACEs for next year’s program (starting in
read more

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 (Redmond, WA) Session Files Session files are now available for download. The zip file contains the PowerPoint slide deck and demo code. Zip file: ReplicationMagic.zip (5.2 KB) Included files: Demo: Initializing replication from a log backup InitializeFromLogPub.sql InitializeFromLogSub.sql Demo: Initializing replication from a filegroup backup using named filegroups FGByNameBackup.sql FGByNameRestore.sql Demo: Initializing replication from a filegroup backup using read-write and read-only filegroups (not demoed during session) ReadWriteFGBackup.sql ReadWriteFGRestore.sql Slidedecks PowerPoint 2010: ReplicationMagic.pptx PowerPoint 2003-2007: ReadWriteFGRestore.sql
read more