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

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
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

Hardening SQL Server

Hardening SQL Server My new article for SQL Server Magazine on Hardening SQL Server has been posted online and will appear in an upcoming print issue. This article is a brief explanation of how to secure SQL Server against malicious attack or invasion. This article can serve as a guide for preventing your SQL Servers from being compromised. Excerpt from Article Hardening SQL Server SQL Server applications rely on data, and protecting that data has never been more important than
read more

When Does Trustworthy Get Reset on a Mirror?

When Does Trustworthy Get Reset on a Mirror? When I’ve done sessions on automating database mirroring processes and in my book, I talk about incorporating steps to set properties that get reset during the restore process in the mirroring setup such as database owner and the Trustworthy property. When you perform the initial restores of the database to set up mirroring, the database owner is set to the account of the person performing the restore, and if Trustworthy is enabled,
read more