Where in the world is Quacky?

Where in the world is Quacky?

Each year, Idera sponsors a variety of events worldwide to support education, training and networking opportunities for Microsoft IT professionals. Check out the list below to find events near you. We look forward to meeting you!

If you’d like Idera to sponsor an upcoming event, please contact us at sponsorships@idera.com

Webcasts

 
DATE & TIME LOCATION DESCRIPTION REGISTER
05/16/2018
9AM CT
Online
IDERA Live | Decode your Organization's Data DNA
Deoxyribonucleic acid (DNA) is the fundamental building block that specifies the structure and function of living things. The information in DNA is stored as a code made up of four chemical bases in which the sequencing determines unique characteristics, similar to the way in which letters of the alphabet appear in a certain order to form words and sentences.

Organizations can also be regarded as organic, with a need to adapt to changes in their environment. Every aspect of an organization also has a corresponding data representation, which can be regarded as its DNA. Without the correct tools and techniques, decoding that data structure can be extremely complex. Data modeling reveals that data in most organizations follows similar patterns. Once we recognize that, we can focus on the data characteristics that make each organization unique.

Establishing a data culture is vital to success, enabling a transformational breakthrough to translate data into knowledge and ultimately, strategic advantage. IDERA’s Ron Huizenga will explain how a business-driven data architecture enables you to leverage your data as a valuable strategic asset.

About Ron: Ron Huizenga is the Senior Product Manager of Enterprise Architecture and Modeling at IDERA. Ron has over 30 years of business and IT experience across many different industries including manufacturing, retail, healthcare, and transportation. His hands-on consulting experience with large-scale data development engagements provides practical, real-world insights to enterprise data architecture, business architecture, and governance initiatives.
Register
05/16/2018
10AM CT
Online
IDERA Live | Nuts and Bolts: Initial SQL Server Security Setup
You have a new SQL Server. What do you need to set up from a security perspective? What should be audited? What are the things you need to consider when building that initial security profile?

In this session we’ll look at the bare bones minimum things you need to secure and audit. Then we’ll look at the right questions to ask to determine where you go from there. Are there any regulations you’ll need to adhere to? Has your compliance officer specified other controls you must implement? What about, “Because it’s the right thing to do?” In response to these questions we’ll look at what some typical answers are with respect to security and auditing.

About Brian: K. Brian Kelley is a Microsoft SQL Server author, columnist, and Microsoft Most Valuable Professional (MVP) focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organization’s computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups. He is also the President of the Midlands PASS Chapter and of a Professional Association for SQL Server Chapter in Columbia, SC.
Register
05/16/2018
11AM CT
Online
IDERA Live | To Force Plans, Or Not to Force Plans, That Is The Question
We have new ways to force execution plans in SQL Server. In SQL Server 2017, you can even let SQL Server temporarily force query plans for you and test if it works well!

In this session, you'll learn how forcing plans with Query Store compares with the older technology of Plan Guides. You'll learn how to tell when a plan has been forced, what "morally equivalent plans" are (and why they're a good thing), how to see if a query has a high variation in performance, and how to decide, "Should I force this plan?" and "Should I let SQL Server force plans for me?"

About Kendra: Kendra Little teaches database administrators and developers how to speed up their Microsoft SQL Servers consistently. She is a Microsoft Certified Master in SQL Server, a Microsoft Most Valuable Professional (MVP), and one of the few artists in the world to draw both dinosaurs and databases.
Register
05/16/2018
12PM CT
Online
IDERA Live | Defend Your Database Against Disasters
Having proper backups for your SQL Server databases is your last line of defense when things go wrong. The most important job of a DBA is to be able to recover the data in the event of a disaster, whether that is a user deleting a record or a hardware failure. To come up with a good backup and restore strategy, a DBA will need to define a Service Level Agreement (SLA) for each system.

Join Tracy Boggiano as she explains the different types of backups and restores that are available: full, differential, log, compression and encryption, and more. She will also walk through partial database backups and restores. Smart backups are new to SQL Server 2017 - Tracy will walk through how to implement this new type of backup. Attending this session will help determine you have what you need for your SQL Server database backups.

About Tracy: Tracy Boggiano is the Database Superhero for ChannelAdvisor. She has spent over 20 years in IT and has used Microsoft SQL Server since 1999. Tracy covers all aspects of administration. She deals heavily with performance tuning, high availability, and disaster recovery. She is certified in Microsoft Certified Solutions Expert (MCSE) Data Management and Analytics. Tracy is a co-organizer of a Special Interest Group (SIG) dedicated to advanced database administrator topics in her local user group TriPass. She is currently serving as a 2018 IDERA ACE and just received the PASS Outstanding Volunteer Award for November 2017.
Register
05/16/2018
1PM CT
Online
IDERA Live | The Ever Growing Science of Database Migrations
Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database migrations. In the old days to share files across systems, then to move files into relational databases, then to load into data warehouses, and finally now we're moving to NoSQL and the cloud. In the presentation we'll delve into the ever growing and increasingly complex world of database migrations. Some of these considerations include what issues must be planned for and overcome, what problems are likely to occur, and what types of tools exist.

Database expert Bert Scalzo will cover these and many other database migration concerns.

About Bert: Bert Scalzo is an Oracle ACE, author, speaker, consultant, and a major contributor for many popular database tools used by millions of people worldwide. He has 30+ years of database experience and has worked for several major database vendors. He has BS, MS and Ph.D. in computer science plus an MBA. He has presented at numerous events and webcasts. His areas of key interest include data modeling, database benchmarking, database tuning, SQL optimization, "star schema" data warehousing, running databases on Linux or VMware, and using NVMe flash based technology to speed up database performance.
Register
05/16/2018
2PM CT
Online
IDERA Live | Databases Don't Build and Populate Themselves

Databases are often like the big bang, suddenly they just exist, right? Well, not really, someone had to do the due diligence and design them conceptually then come up with a physical model for implementation. If it’s a transaction database, then we're done and the application connects and, voila, data starts filling our database. But in other situations such as business intelligence, analytics, conversions, etc. we must move data from other systems into the database.

In this session we are going to discuss these two key aspects: database design patterns and Extract, Transform and Load (ETL). We will talk about the role of data modeling and SQL Server Integration Services for data migration.

About Stan: Stan Geiger is a Senior Product Manager at IDERA with over 25 years using Microsoft SQL Server. Stan has worked in various industries from fraud detection to healthcare. He has held several positions including database developer, DBA, and BI Architect, and has experience building Data Warehouse and ETL platforms, BI Analytics and OLTP systems.

Register
05/22/2018
2PM CST
Online
Quickly Fix Application Performance Problems for the .NET Technology Stack with Precise

Multiple tier applications using the Microsoft .NET framework are ubiquitous, and they power mission-critical organizational processes. When performance problems occur, the blame usually falls on the .NET tier that supports such applications. However, such performance problems are often a symptom of difficulties in other tiers (such as the database or the web tier). Stop the finger pointing by correlating end-user transactions with their user sign-on IDs, URLs, application calls, databases, and storage devices. End the blame game by identifying class contention, reporting on exceptions thrown, diagnosing memory leaks, and drilling down to view relevant details (such as application availability, average response time, number of invocations and SLA compliance status).

IDERA Precise for .NET connects application transactions to SQL statements across the tightly coupled IIS, .NET, and SQL Server technology stack. Discover how to separate the trees from the forest by quickly isolating the cause of problems, and viewing the slowest executing service requests, SQL statements and web services.

Join Patrick O'Halloran to learn how Precise for .NET can help you resolve application problems before they affect the organization.

Register
06/19/2018
2PM CST
Online
Quickly Fix Index and Query Performance Problems with SQL Diagnostic Manager

Everyone wants their SQL queries to run faster, but how can you achieve that? Executing resource-intensive queries requires a significant amount of processor time, memory, and bandwidth, and storage. Queries preventing each other from using these resources can eventually lead to blocking. Common causes of blocking are a lack of proper database indexes, poor execution plans, poor application design, and misconfigured SQL Servers. Accurately identifying problematic indexes and queries is required to resolve potential performance issues in early stages before they cause severe problems for the organization.

Join Doug Walsh to learn how to monitor and diagnose the performance of indexes and queries multiple different ways (such as viewing query signatures, query statements, query history, query waits, query execution plans, worst offenders, and prescriptive workload analysis) in a SQL Server environment with IDERA SQL Diagnostic Manager.

Register