Presentations

Below is a listing of the various presentations that I am currently giving. If you would like for me to present something to your group or company, please feel free to contact me. I would love to have the opportunity to present! Depending on location, I am more than willing to do a remote presentation or be on site.  I’ve also included my speaker bio for easy retrieval.

Speaker Bio

John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. John lead the Omaha SQL Server user group for 7 years and is now a leader of the Louisville SQL Server/Power BI user group. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador.  He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences.  In his spare time, you can usually find John on Twitter (@sqlrus) as well as chasing his two young sons around the house.

Session Topics

 

Database Continuous Delivery & Your Salvation!

Continuous Integration & Delivery isn’t a new concept.  Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up.  Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I’ll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments.   We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.

10 Things Every DBA Should Know!

Are you new to the world of Databases? Are you a developer wanting to improve your SQL Skills? If you answered ‘Yes’ to either of those questions, then this is the session for you! John will be reviewing things that he’s seen in his experiences working with databases that every DBA should know and understand. He will demonstrate and\or explain every day things like Auto Shrink, SELECT *, Index Basics and 7 others! You will leave this session walking away with knowledge you can implement right away.

Only You Can Prevent Database Fires!

Do you find yourself constantly putting out “fires”? Can’t take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as “fire prevention” to stop the “fire fighting”.  We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!

Social Media Is Alive!!!

Social Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter? Can you believe Susie moved to that company? Do any of those sound familiar? No?  Never heard of Twitter or LinkedIn? Have no fear, this is the session for you!  Social networking can be a very confusing and intimidating place. What makes it even worse, is when you have no clue even where to start.  In this session, we will go over different facets of Social Networking and Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. For example, did you know you can get help from some of  the top minds in the SQL Server profession by using the #SQLHELP hash tag for free? We will show you how! We’ll be covering that and more using Facebook, LinkedIn and Twitter.

Backups & Restores: You’re Not In Kansas Anymore!

There is no place like home, there is no place like home!  When a database crashes and you have to recover it, this may be what you’re saying to yourself over and over. It can feel like a house just landed on you if you’re not prepared. Ok, not really, but recovering a database from an unexpected event is often just as terrifying!  If you aren’t prepared for it, it’s really going to hurt. So what do you do?  You prepare. You plan. You practice.  We’ll talk about how the backup & restore process works in SQL Server and how it can help you to prevent a Wizard of Oz situation!

SQL Server Databaseology: A Deep Dive Into Database Internals

Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level.  You will walk away with a better understanding of how SQL Server stores data and that knowledge that will allow you to build better and faster databases.

Azure Basics for the DBA

It’s not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA’s and we should all strive to learn it. In this session we’ll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new found knowledge will help propel your career into the new landscape.

SQL Server Data Encryption 101

It seems more lately than not, there are daily stories of a data breach somewhere. Data security is one of the most critical things a data professional should be aware of. Now, there are several ways of implementing data security in today’s world. SQL Server comes with several native data encryption methods that you can use.  In this session, we will explore the basics of data encryption, how to implement some of them, some gotchas as well as some of the newer features of data encryption in newer versions.

Being a SharePoint DBA – Epic Collaboration

SharePoint is a popular for many organizations. It has several different facts such as document management, file storage, and collaboration. These facets while enabling productivity and collaboration with end users can cause serious concerns for the database administrators. In this session we’ll look at how SharePoint works with Microsoft SQL Server including performance issues, configuration, database management, security and disaster recovery. This will help you to collaborate with your SQL Server DBA to ensure your SharePoint environment is running as best as possible.

Temporal Tables – The New Hotness in Data Auditing

A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.