Grant Fritchey

gfritchey

Learn how to use the Live Data window with Extended Events to do more with the information you capture using Extended Events in SQL Server and Azure SQL Database. There's more functionality there than is immediately apparent.

When you need to make our fantastic tools do just a little more, why not go to university to learn how. Redgate University: https://www.red-gate.com/hub/university/

The first thing you need to understand about databases is that they are just files. I explain the types of files and information about how best to manage them.

Understanding the different join types and where they apply is an important part of reading and understanding execution plans in SQL Server. I introduce the four joins; nested loops, hash, merge and adaptive.

For more on adaptive joins, here's another video I made: https://youtu.be/Oxj3HilCnko

Redgate is hosting a live, in-person event in New York City, London and Chicago in October. Watch this video to learn what it's all about. Follow this link to get learn more and get registered: https://www.red-gate.com/hub/events/redgate-events/sqlinthecity-summit/

I've just started reading the details of the new California Consumer Privacy Act and I'll share them with you as I find them.

With the new laws out of California and New York, The California Consumer Privacy Act (CCPA) and Stop Hacks and Improve Electronic Data Security (SHIELD), the types of privacy and protection defined under the General Data Protection Regulation (GDPR) over in the EU is now directly applicable here in the US. Redgate Software wants to help you with your data classification. Go here to take part in our EAP of a new product: https://www.red-gate.com/products/dba/sql-data-catalog/eap

The importance of ensuring that you know which service pack or cumulative update you have installed can't be over emphasized. I discuss why this important and how Redgate is trying to help.

Go here to learn more: https://monitor.red-gate.com/estate/versions

I teach an all-day course on SQL Server Query Tuning Tools. This video explains some of the topics that you'll learn in the course and why you should attend.

You can find my full schedule of courses, their location and dates, here: https://www.scarydba.com/upcoming-speaking-engagements/

I was asked what I think a DBA has to do to survive in the current environment, so here are a few suggestions.

I'm looking for feedback on whether or not you would find videos targeted at SQL Server fundamentals useful. Please answer in the comments. For examples of the types of topics, please look here: https://www.scarydba.com/category/database-fundamentals/

Redgate Software, my employer, has launched a beta for our next generation data masking tool. If you'd like to try it out, please follow this link: https://www.red-gate.com/products/dba/data-masker/entrypage/projectfigleaf

Let's take a look at the execution plan of a recursive Common Table Expression to see exactly how it works.

Keeping an eye on your SQL Server instances is all about ensuring that you have configured the alerts correctly. This video shows how to use Redgate SQL Monitor to get this done.

I've put a new page on my blog just to list all my speaking engagements so you can easily track down an opportunity to talk with me live, if you're so inclined. Just go here: https://www.scarydba.com/upcoming-speaking-engagements/

Almost 30 days in to GDPR enforcement and there is still lots of bad information out there. Don't panic. Do what is necessary and right.

Trace Flag 7412 introduces new abilities to capture performance metrics on execution plans without capturing the execution plans themselves. Trace Flag 7412 also opens up new functionality with Live Execution Plans. Read more about it here: https://www.scarydba.com/2018/06/11/plan-metrics-without-the-plan-trace-flag-7412/

On May 10th, 2018, I'll be presenting for the first time in Indiana while teaching an all day seminar on query performance tuning tooling. Please follow this link to learn more: https://www.eventbrite.com/e/grant-fritchey-sql-server-tools-for-query-tuning-tickets-44638946290

Trust me when I tell you, being the "Scary" DBA isn't good for your career. Watch this video to understand why.

My wife makes an appearance as I work on a video. A funny little blooper.

I am going to be hosting a full day seminar in Sioux Falls on August 18th, 2018. The seminar will be all about query tuning tools and how they can improve your queries. Go here for more details and to sign up: https://www.eventbrite.com/e/sqlsaturday-sioux-falls-pre-conference-tickets-45947239430?aff=utm_source%3Deb_email%26utm_medium%3Demail%26utm_campaign%3Dnew_event_email&utm_term=eventname_text#tickets

Did you know that you can use the Extended Events system_health session to look at long running queries? Well, you can. Watch this video to learn more.

For more on Extended Events, follow this link: https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-system-health-session?view=sql-server-2017

-~-~~-~~~-~~-~-
Please watch: "SQLSaturday Sioux Falls, August 18, 2018"
https://www.youtube.com/watch?v=ZZRqLkje71E
-~-~~-~~~-~~-~-

I'm very excited to be able to announce that I'll be taking part in SQLDay in Poland in 2019. Go here to learn more about the event: https://sqlday.pl/

SHOW MORE

Created 5 months, 3 weeks ago.

46 videos

CategoryScience & Technology

Primarily focused on the Microsoft Data Platform, Redgate Software, DevOps and lots of things related to IT.