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/
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 make several recommendations for how to get started in SQL Server with the installation.
SQL Server Developers Edition: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Installing SQL Server: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup?view=sql-server-2017
SQL Server Management Studio 17: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
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'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
I read this article in the New York Times:
It made me think of PASS: http://www.pass.org/
And the PASS Summit: http://www.pass.org/AttendanEvent/Conferences/PASSSummit.aspx
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/
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
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"
Created 5 months, 3 weeks ago.
|Category||Science & Technology|
Primarily focused on the Microsoft Data Platform, Redgate Software, DevOps and lots of things related to IT.