Tuesday, November 6, 2018
PASS Summit - Day 1
Starting My Day
After my workout I met up with a fellow Rochesterian, Chris Sommer, and headed to Lola's for breakfast. It's a destination that is an absolute must when coming to Seattle and I'm always excited to go with someone who is experiencing Lola's for the first time. After sharing Lola's world famous fresh donuts and enjoying a solid hot breakfast, Chris said it was "the best breakfast I've ever had". Mission accomplished!
Today I attended Denny Cherry's full day pre-con session on SQL Server Security. Denny did a great job organizing and presenting the session content. We initially covered security outside of the database (vLANS, Firewalls, ACLs, etc..) which filled in several knowledge gaps I had (which is why I'm here!). Then we dove into database level security such as encryption, contained databases, AG group security, and more. I was very pleased with the quality of this pre-con and I'm grateful my company was generous enough to send me here.
There seemed to be a reoccurring theme that is somewhat disheartening.... securing your data the right way goes beyond what a DBA can do alone and getting the resources you need to secure your data the right way is near impossible. Also, the biggest threat of a breach in security is our users and there is nothing we can do to stop it. Sounds like a losing battle to me..... How dreary!!!
Again, this was a fantastic session. Denny is a fantastic presenter and I learned a lot.
The Night Life
PASS is community focused and is great at planning events for people to enjoy in the evening. Today was the Networking dinner at Yard House. I was able to reconnect with a couple of people that I had met at SQL Saturdays as well as previous Summits. I also had the chance to talk to a first timer, Monica, who wasn't familiar with our #SQLFamily. It's always exciting to introduce someone new to the community! Chris and I changed venues and continued an evening of socializing with more SQL friends until the east coast clocks starting weighing on my eyelids.
Overall my first day at PASS Summit was awesome and I can't wait to do it all again on day 2!
Wakey Wakey My very last morning waking up in Seattle and I finally sleep until my alarm goes off. It was a bitter sweet morning. On one...
Oracle has built-in reports that can give vital information on the performance of your database. Today I will show you...
What is JBGE? ' J ust B arely G ood E nough', or JBGE, is the idea that there is a sweet spot for task completion in terms of effo...
Last, but not least, I will show how to generate an AWR (Automatic Workload Repository) report within SQL*Plus. The AD...