The TriPass group in Raleigh, NC has started a Special Interest Group on Advanced DBA Topics. This means we are looking for talks at a level 300 and above. Our group will normally meet the second Tuesday of the month at 6PM Eastern Standard Time. Our ambition is to have 50% female speakers. With PASS membership only being 20% female this will be a high bar to meet so we will need help to meet this goal. With the technical depth of the talks the group will be covering, we realize a lot of the speakers will be presenting remotely, which we fully set up to do. So if you are interested in speaking for this group (male or female) please email me.
To RVSP for these events join our Meetup group and watch out for the invites.
Events List Navigation
You already know a thing or two about tuning a SQL query on Microsoft SQL Server. You can read an execution plan and know the most significant red flags to look for. And you have also learned about the important metrics revealed by features like the SET STATISTICS statements. But you want to take it up another level! First, we will time using undocumented trace flags to look at the steps of parsing, binding, and query optimization. Second, we will…Find out more »
Microsoft is introducing a new family of adaptive query processing improvements that will enhance the performance of workloads that have historically been difficult to tune through classic methodologies. In this session we will cover three of the new improvements, including interleaved execution for multi-statement table valued functions, batch-mode execution adaptive joins, and batch-mode memory grant feedback. We'll cover how you can determine if your workloads will benefit from these improvements and discuss how these features fit into your existing SQL…Find out more »
SQL Server 2016 introduced Query Store, a new feature which tracks query metrics and can be used for troubleshooting, testing, and proactively monitoring a workload. Query Store also provides the ability to force a plan for particular query, which means you may no longer need to use those tricky plan guides. In the upcoming SQL Server 2017 release, not only is wait statistics information included in Query Store, but the Automatic Tuning feature has been added to help further stabilize…Find out more »
When an application is performing poorly, the database is almost always suspected to be the source of the problem. Not so fast! In this session, learn how to use Extended Events in three different ways. The traditional "long running query" identification. The "thousand paper cut" diagnosis. Reading BETWEEN the lines to determine what is missing. The final method, analyzing the space BETWEEN calls to the SQL Server is a non-traditional technique that can be used to identify where an application…Find out more »
A lot of DBAs use Powershell to help automate complex tasks or apply configuration changes to multiple servers. Many are writing their own functions, and some may even have packaged them up into a custom module. What about more advanced features? How many are using verbose output, pipeline parameters, or parameter validation? These are just some of the features of something called "Advanced Functions" in PowerShell. In this session, we will discuss these topics and more as we work through…Find out more »
Module Signing is the method of extending permissions that is preferred over using EXECUTE AS (i.e. Impersonation) and/or cross-DB ownership chaining and/or TRUSTWORTHY as it is more flexible and more secure. This approach uses Certificates and/or Asymmetric Keys to create the signatures. Unfortunately, due to a lack of thorough documentation on Certificates and Asymmetric Keys (especially with regards to SQL Server), they are perceived as being complex and mysterious. Come take a look behind the green curtain and learn about…Find out more »