John Morehouse
Principal Consultant
Louisville, Kentucky, United States
Actions
John Morehouse is a Principal Consultant with Denny Cherry & Associates Consulting living in Louisville, Kentucky. Honored to be a Microsoft Data Platform MVP & VMWare vExpert, having over 2 decades of technical experience, John now focuses on solving crucial business problems with Microsoft SQL Server oriented solutions. John has a passion around speaking, teaching technical topics and giving back to his community whenever possible. He is a blogger, avid tweeter, and a frequent speaker at conferences and user groups whenever possible. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, http://sqlrus.com.
Awards
Area of Expertise
Topics
Accelerated Database Recovery - A Deep Dive Behind the Magic
We have all heard the stories. Horror story after horror story being regaled from database administrators all over the world of waiting for hours or sometimes days for a rollback operation to complete. DBA's hoping beyond hope that the rollback finishes soon before someone else gets the notion to reboot the server.
With the release of SQL Server 2019, a new talisman was conjured that will save us all from hearing about future horror stories. Accelerated Database Recovery or also known as "ADR". This new mystical feature changes the way transaction rollback performs and will undoubtedly prove invaluable in your arsenals of magical tricks!
In this session, we'll show you the secret behind it!
You will -
• Learn about new components of the transaction log
• Discover the magic behind ADR
• Determine when you wouldn't want to implement it
Don't be the protagonist in a rollback horror story! After all, the time you save might be your own!
Understanding the Magic of Indexes
Microsoft SQL Server is a large data ecosystem with many facets that can affect how your queries perform. Facets like what kind of hardware are you using, how much memory, CPUs. Many of these facets cost money and there are many things about them that can be turned on, tweaked, or implemented to help improve performance. Did you know that you can implement a low-cost solution of proper indexing? Proper indexes can help not only improve query performance but also help save money on hardware! In this session we'll examine the foundation of how indexes work, what the moving parts are and why they are important. We'll examine some real-world examples of where queries were falling short but then were successful with proper indexing. You'll walk away with techniques on how to know where and how to add indexes to help you start to save money!
Optimizing Query Performance in Azure SQL Database
Many think that moving to the cloud will solve all of your poorly performing queries stemming from bad coding practices. If it's done correctly, implementing Azure SQL Database can help with that, kind of, by masking it well, but it only hides it. The best solution is to fix the bad code. However, as we know, sometimes that isn’t an option. In this hour-long session, we will examine several different methods that you can utilize to help bad performance starting with methods to find where bottlenecks are residing. Next, we will evaluate possible ways to fix them through properly configured underlying infrastructure. Lastly, we will interrogate which native SQL Server enhancements that exist within Azure SQL Database that can really help solve ongoing performance issues. You'll leave this session with a solid understanding of how to trouble shoot performance issues in Azure SQL Database and what you might be able to do to help fix them with minimal code changes.
Understanding Modern Data Encryption Offerings for SQL Server
Every second of every day, sixty-eight data records are stolen. Is your data next?
Implementing proper data security is one of the most critical things a data professional can do. There are several ways of implementing data security in today's world. SQL Server comes with several native data encryption methods that you can deploy, including methods that leverage cloud technology. In this session, we will delve into understanding data encryption and how to implement them to help ensure your data stays safe.
You will-
• See how native SQL Server encryption methods work
• Examine incorporating Azure Key Vault into SQL
• Discover how to take advantage of Always Encrypted
You will leave with a clear and concise understanding of implementing modern encryption technology into your SQL Server ecosystem.
Elevating Your Career with Social Media
Whether it is LinkedIn, Twitter, or some other platform, social media continues to be prevalent daily and shows no signs of slowing down. If you have no tweeps or need help figuring out where to start with LinkedIn, this session is for you! With practice and proper technique, social media can improve your career. It can even provide ways to solve production issues for free! During this session, we will review topics such as how to get started, things to avoid, and helpful free tools. You will walk away from this session with newfound knowledge of how social media can help propel you into your next opportunity. The next exciting chapter in your career could be one tweet away!
Surviving a Disaster in Azure SQL DB & Managed Instance
Even in Azure, you need disaster recovery.
A database is often the heart and soul of any application. The data it contains is the business so ensuring that it is protected against unexpected events should be goal for all IT professionals, even in the cloud. Often organizations will move their databases to Platform as a Service (PaaS) offerings such as Azure SQL Database or Azure SQL Managed Instance without considering how to recover from a disaster.
What happens if you need to restore a database? Can you do a failover? In this session we will examine those exact questions and more to ensure you know how to recover from a disaster for Azure SQL Database as well as Azure SQL Managed Instance.
You will -
• Learn about the different methods for disaster recovery
• See how to configure various options to ensure recoverability
• Determine which solution is a better fit for your organization
You are -
• Wanting to understand how to implement a DR solution for Azure SQL PaaS offerings
• Looking to move to Azure SQL PaaS and want to ensure business continuity
• Verifying it was done right and to see if there's something that was missed
Don't be caught off guard just because things are in the cloud. Let's make sure you know how to recover when catastrophe strikes.
Banishing Slow Queries with SQL Server 2022
Slow queries can be the bane of any data professional's existence. Let's face facts. No one likes it when query performance is abysmal. We continuously strive to tweak things to ensure query execution is as fast as possible. What if we could magically make things faster by pushing a button or two? Now we can.
Originally reborn from SQL Server 2017 Adaptive Query Processing (AQP) to Intelligent Query Processing (IQP) with SQL Server 2019, now SQL Server 2022 continues to bring forth even more enhancements making the query optimizer an efficient learning machine. With this newfound knowledge, SQL Server can generate better-optimized queries with minimal effort.
We will -
See what's new with SQL Server 2022
Examine how IQP works behind the scenes
Discover how easy it is to implement with minimal effort
We all like quick and efficient queries. The faster, the better. Take advantage of these new features in SQL Server 2022 and watch those queries fly.
Azure SQL Fundamentals
In today's modern world of the cloud, Azure provides a chance to expand your knowledge and skills for just about anything data related, including SQL Server. We should all jump at this opportunity to learn to avoid being left behind. In this session, we'll cover some fundamental knowledge and terminology of Azure and how easy it is to incorporate Azure into your environment. This newfound knowledge will help propel your career forward into the cloud.
You will:
• Learn about some Azure SQL fundamental concepts
• See various Azure SQL offerings
• Discover hidden pitfalls & ways to help save costs
Don't let this opportunity slip by you. Take your first step into the cloud with Azure SQL and ensure you stay caught up!
Mastering SQL Server's Core: A Deep Dive into Internals
Are you the type who enjoys dismantling gadgets like toasters or alarm clocks to uncover their inner mechanisms? Are you intrigued by the internal operations of SQL Server databases? In this session as we delve into the intricate workings of a SQL Server database, peeling back the layers to reveal its secrets.
We will-
• Examine how rows are physically structured
• Explore the role of pages and extents
• Discover why database design matters
If you've ever been curious about how SQL Server works at its core level, this is the session for you. You will better understand how SQL Server stores data, allowing you to build better and faster databases.
Data Migration to Azure SQL Made Easy
When you decided to move to any cloud provider, the thought about how to migrate all of your data can seem like a daunting task. Thankfully, it isn't as daunting as you might think thanks to some native tools as well as tools offered by Microsoft. In this session we'll examine these methods and tools that will help you to migrate your data to Azure in a safe, secure, cost effective and successful manner. We will also look how these migrations work when working with three of the Azure data platform products, namely virtual machines, SQL DB, and Managed Instances. By the end of this session you will have gained newfound confidence to help you get your data up into the cloud!
Enforcing Data Integrity using Ledger
Validate everything. Trust nobody.
If you have ever worked in a field requiring absolute trust in the data, this should be familiar. In today's world, trust in the data is paramount, yet it can be challenging to achieve in SQL Server databases. With the release of Azure SQL Database Ledger in 2019, it has all changed, thanks to blockchain. With the introduction of blockchain into Azure databases and immutable Azure blob storage, we can now digitally certify the data to ensure its integrity.
Furthermore, SQL Server 2022 helps facilitate ongoing defense against bad actors by providing this incredible feature in the complete installation of SQL Server. In the cloud or on land, you can guarantee data integrity.
Integrity equals trust. Trust equals security.
You will learn -
• What blockchain is at a high level
• How to configure a Ledger database
• About the limitations
If you need to ensure data trustworthiness, Ledger might be your solution.
Thwarting Disaster for SQL Server on Azure VM
Failing to plan is planning to fail.
Azure offers a robust ecosystem where you can run SQL Server pretty effortlessly. Yet, disasters affect data centers, even ones belonging to Microsoft. Natural events, like tornadoes or hurricanes, can cause entire data centers to be lost. Even human error, like a heavy equipment operator cutting the power to a data center by mistake, can only cause an entire outage if you do not take steps to protect it.
Several options are available to ensure disaster recovery when running SQL Server on an Azure Virtual Machine. Sometimes it can be challenging to determine which option is the best for your use case and fit into your organization's grand scheme. In this session, we'll walk through some available options so that you can see first-hand the benefits and pitfalls of each one.
You will -
• Learn about the various options available for your Azure VM running SQL Server
• See where shortcomings may exist in each solution
• Leave with a solid idea of what would work best for your environment
Disaster recovery is vital in Azure. Let's ensure you've everything in place to recover successfully, regardless of what comes your way.
Top 5 Reasons to Move to SQL Server 2022
Why should we upgrade SQL Server?
This is a common question that gets asked often. Let's face it, you have most likely read that this new version of SQL Server is an absolute game changer in a multitude of areas including performance, security, scalability, and manageability. So, in this presentation, we will examine my top 5 reasons organizations should evaluate moving to SQL Server 2022 sooner rather than later.
We will -
* Dive into a brief overview of what's new with SQL Server 2022
* Check out new cool management features
* Discover new performance enhancements
We could spend days investigating all the new things, but instead, we'll cut to the chase and talk about a few that just might help convince management to make the leap!
Exploring Optimized Locking in Azure SQL Database
When updating data in SQL Server, operators run the gambit of incurring issues if not done correctly. Sometimes, they manifested as lock escalation, the dreaded blocking, disastrous deadlocks, or poor performance. With the release of Optimized Locking in Azure SQL Database, issues are mitigated while helping to enhance performance and transactional concurrency.
In this session, we'll embark on a journey into this new capability, designed to revolutionize concurrency control and improve transaction throughput. We'll examine the underlying mechanism while providing insights into its architecture, implementation, and best practices for maximizing performance.
You will -
• Learn how optimized locking works
• Discover what it requires to function
• Some Gotchas to be aware of
Whether you're a seasoned database professional or a curious developer, this session offers a more profound understanding of the new Azure SQL Database's optimized locking feature.
dataMinds Connect 2023 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top