Jeff Iannucci
Senior Consultant at Straight Path Solutions
Actions
Jeff Iannucci is a Senior Consultant with Straight Path Solutions. With over 20 years of experience with SQL Server development and administration, he enjoys sharing what he's learned by speaking, blogging, and creating video content. He has been a speaker at PASS Data Community Summit, a content author for Pluralsight, and is author of the upcoming book "Learn SQL in a Month of Lunches".
Links
Awards
Defending Your SQL Server: Practical Strategies against Ransomware
Recent studies show ransomware is a growing threat. Nearly 50% of organizations have been hit by it in recent years. Is your company next? Are you ready? As a SQL Server DBA, is there anything you can do to protect from a threat that is a matter of when, not if?
In this session, we will examine attack scenarios and identify several common vulnerabilities in your SQL Server instances. We will focus on problematic settings and permissions, use simple scripts to identify these vulnerabilities, and discuss actions to resolve any issues.
You will leave with a checklist of practical steps and tools you can use immediately to reduce the impact of ransomware attacks in your SQL Server databases.
Fixing Your Query Antipatterns
Even if you have heard of query antipatterns, do you know if you have any in your SQL? And if you find them, do you know how to fix them?
In this session, you will see several common query antipatterns – commonly used techniques that are unintentionally counter-productive. You will learn not only what makes them troublesome, but also better solutions to improve query performance.
Getting More from Query Store
Query store has been described as SQL Server’s “black box”, recording all sorts of information about executed queries. But is that what it is to you – a black box?
In this session, you will learn how to configure query store optimally, better ways to use the built-in reports, and simple yet effective ways to leverage this incredible feature to resolve several real-world query issues.
Performance Tuning Your Transactions
Is your nightly INSERT getting slower? Did your UPDATE use all the transaction log disk space? Has your DELETE blocked other queries?
In this session, you will see different database settings and query techniques that can affect the performance of INSERT, UPDATE, and DELETE statements in SQL Server. You will learn why theses settings and techniques are effective, and what use cases are best for each one.
Level Up Your Digital Communication Skills
“Excellent communication skills” shows up repeatedly as a job requirement, and in the age of remote work, all our conversations involve digital communications. So… are you really excellent at using email, chat, and video conferencing applications? Or do you often get confused responses, or no responses at all?
In this session, we focus on these modern methods of communication, when to use each type (hint: they’re not interchangeable), and most of all, how to deliver your messages for more effective interactions. You’ll leave with a stronger understanding of how to use these tools to communicate truly excellently.
Surviving SQL Server: Guidance for new or accidental DBAs
You don't have much (or any) experience as a Database Administrator, but you’re now responsible for the organization’s SQL Server databases. This means you might be the first person blamed for data corruption, excessive file growth, and ransomware. Does this keep you up at night?
In this session, you’ll learn how to properly prioritize your database tasks, what free tools available to make your job easier, and where to seek help for SQL Server issues. You'll leave with a better understanding of "how to DBA" and hopefully get some better sleep.
Unlocking the Power of WhoIsActive
For years many SQL Server professionals have been using the free, community-maintained stored procedure WhoIsActive to troubleshoot problematic activity. Unfortunately, most of us only use the default results instead of using this wonderful tool to its fullest capabilities.
In this session, you'll learn about helpful non-default options in the latest version of WhoIsActive, how to utilize them to quickly identify resource contention or blocking, and how to capture recurring data for later analysis. You'll leave with a better understanding of how to use WhoIsActive more effectively to resolve troublesome activity on your SQL Server instances.
Jeff Iannucci
Senior Consultant at Straight Path Solutions
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top