SQLUG-möte med Rob Sewell och Kevin Kline

Corona-pandemin fortsätter och därför fortsätter vi med online-möten tills vidare.

När: Tisdag 2 juni, 18:00, cirka två timmar
Var: Onlinemöte, länk skickas ut i bekräftelsen efter anmälan
Anmälan: https://www.eventbrite.com/e/sql-server-usergroup-sweden-with-rob-sewell-and-kevin-kline-tickets-105940990354

Rob Sewell – dbackechs, SQL Server configuration validation

Be-Whiskered PowerShell Ninja

Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConfEU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.

He has a fabulous beard

Abstract: As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method using PowerShell and you can get the results in PowerBi or embedded into your CI/CD solution

Details such as:

  • How long since your last backup?
  • How long since your last DBCC Check?
  • Are your Agent Operators Correct?
  • Is AutoClose, AutoShrink, Auto Update Stats set up correctly?
  • Is DAC Allowed?
  • Are your file growth settings correct, what about the number of VLFs?
  • Is your latency, TCP Port, PS remoting as you expect?
  • Is Page Verify, Data Purity, Compression correctly set up?

And many more checks (even your own) can be achieved using the dbachecks PowerShell module and all configurable so that you can validate YOUR settings

We are adding a new PowerBi dashboard, the ability to easily store the results into any format that you want including a database, come and take a walk though the new dbachecks

Kevin Kline – Query Tuning internals for the advanced SQL Developer

Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server, as well as the author of popular IT books like SQL in a Nutshell.

Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends magazine. He tweets at @kekline and blogs regularly. Kevin is a Principal Program Manager at SentryOne, a leading vendor of database tools.

Abstract: Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the processes controlled by the algebrizer, including associative, commutative, and transitive transformations. We will examine a variety of everyday queries whose performance can be greatly improved by apply a deeper understanding of these internal behaviors. Lots of examples and demos!

  • Goal 1: Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, and query optimization.
  • Goal 2: Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.
  • Goal 3: Walk through several examples of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.

Skriv något snällt om den här artikeln!

Fyll i dina uppgifter nedan eller klicka på en ikon för att logga in:

WordPress.com Logo

Du kommenterar med ditt WordPress.com-konto. Logga ut /  Ändra )

Google-foto

Du kommenterar med ditt Google-konto. Logga ut /  Ändra )

Twitter-bild

Du kommenterar med ditt Twitter-konto. Logga ut /  Ändra )

Facebook-foto

Du kommenterar med ditt Facebook-konto. Logga ut /  Ändra )

Ansluter till %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.