Real-life SQL Server Performance Troubleshooting at SQLSaturday Columbus

Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus at Otterbein University Campus Center in Columbus, OH. Register for SQLSaturday Columbus before it fills up, and check out the early bird pricing for the pre-conference sessions the day before. Description: Tired of talking about theory and want to hear about real production SQL Server issues and the methods I used to troubleshoot them? We’ll take a look at real
read more

24 Hours of PASS: Security: Session Files

Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of the event was wholly focused on security, and my presentation was Securing SQL Server Processes with Certificates. If you missed it, the sessions were recorded and will be posted on the PASS website soon. In the meantime, the slide deck and demo code can be downloaded below. Slide deck: SecuringSQLServerProcessesWithCertificates_final.pptx (801 KB) Demo code: SecuringSQLServerProcesses_demo.zip (2KB)
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

DBA: Guardian of the Data

I was asked recently by Idera to take a look at the things that could cost a DBA their job. This has lead to a new whitepaper I wrote about the 5 mistakes that DBAs make that can cost them their jobs. Watch Idera’s Resource Central or follow @Idera_Software on Twitter to see when the whitepaper is released. In addition to the whitepaper, I have been taking a new look at this topic and providing some additional and supplemental information
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

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

Here we are at day 4 in my series focusing on disaster recovery. It’s Friday, so this will be a quick one for today. I want to talk about the importance backing up everything that needs it and point out some of the often overlooked things that you should be backing up. If you missed any of the earlier posts in the series, you can check them out here: 31 Days of disaster Recovery Does DBCC Automatically Use Existing Snapshot?
read more

Cross-database Queries by Contained Users

Cross-database Queries by Contained Users I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on the subject of contained databases. The slide deck and demo code from my presentation, Implementing Contained Databases, can be downloaded below or will be uploaded to the User Group site in the near future, if not already. the presentation showed the basic implementation and administration tasks as well as covering the pitfalls and gotchas that you need to
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

Troubleshooting Database Mirroring Error 1418 Updated

Troubleshooting Database Mirroring Error 1418 Updated Last night I was helping someone with a database mirroring setup problem via email. It has been a long time since I came across a new cause for the infamous 1418 error for database mirroring. This time the error was accompanied by an error in the SQL Log on the mirror partner that said teh following: Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not
read more

Auditing Users in a Failover Partner Database

Auditing Users in a Failover Partner Database I read a question on a discussion list today asking if it is possible to audit SELECT queries on a log shipping secondary in stand-by mode. His attempts to set it up had obviously failed because the database is read-only and you cannot create a database audit in the database (nor anything else). Wanting to modify the secondary database is actually a pretty common question with a simple solution though I had never
read more