The goal of the Pensacola Data Professionals user group is to provide free training on a variety of topics surrounding the Microsoft Data Platform for local DBAs and Data professionals. We'll be hosting nightly meetings typically every other month, as well as, hosting a PASS SQLSaturday event that is held one time per year. The monthly meetings will consist of volunteer speakers, both experienced and those wanting to get into technical presenting; good eats provided by our sponsors; open forum discussion and networking time. Meetings will be held the last Thursday of the month.
Ever wonder how somebody else does it? Watch over the virtual shoulder of Microsoft Certified Master Brent Ozar as he walks you through the Stack Overflow public database export, shows you two queries, and then tunes them to make them dramatically faster. Along the way, you'll see several free tools in action that help make the process easier.
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.
Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?
SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:
- Document your database schema objects such as procedures, functions, tables, columns and indexes
- Investigate performance and look for bottlenecks and tuning opportunities
- Discover metadata to administer your databases backups, index maintenance, and security
- Apply your own metadata using extended properties
We will also cover the official Microsoft documentation on these features and other resources on how to use them.