Soluções de gerenciamento de banco de dados SQL Server

SQLBits is coming to London, 29 September through 3 October. 

In the meantime, you can learn expert techniques to streamline your cloud database journey in a special SQLBits preview webcast on 9 April. 

One of the challenges of cloud deployments is choosing the correct sizing for your cloud database environment.

Organisations commonly make the mistake of mimicking the on-premise server specs in the cloud, diluting the considerable cost-saving advantages that could be gained.
But when it comes to sizing an environment users can struggle to know what resources are required to ensure there is no impact on performance when migrating to the cloud.

Cloud database expert Denis O' Sullivan will discuss:

• How to choose the correct size for your cloud databases
• Why you shouldn’t mimic your on-premises server specs in the cloud
• How to achieve considerable cost-savings in the cloud
• What you can do to avoid performance impact when migrating to the cloud 

Speaker: Janis Griffin

Query tuning is key to peak performance in SQL Server databases. However, lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time trying to fix them. In this session, I will share my tried and true best practices for tuning SQL statements and other issues by utilizing Wait Time Analysis, reviewing execution plans and using SQL diagramming techniques. In addition, I’ll go over several case studies to demonstrate these best practices. 

Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct SQL performance tuning path with no guessing, saving countless hours of tuning queries and optimizing performance of your SQL Server databases. 

You’ll learn how to: 

• Effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approach 
• Quickly identify inefficient operations through review of query execution plans 
• Easily apply SQL diagramming techniques to find the best execution plan 

Databases serve a critical function in the banking world. Maintaining SLA compliance and avoiding risk is critical to your institution’s survival, all the while aiming to maintain the integrity of your financial institution. But as you juggle new database platforms and rapid data growth, database performance can decline. And when customer data is at stake, and hefty fines loom, you can’t afford to manage databases reactively. The databases that support these critical applications need to perform reliably.

Join this session and discover expert techniques to easily and proactively manage your ever-growing database environment.

You’ll learn how to:

• Isolate database performance issues and reduce resolution time for mission-critical financial applications
• Cope with large database environments (hundreds of instances and above)
• Handle databases in different locations (including on-premises and cloud)
• Support new database platforms and new cloud database service technologies
• and much more!

Rapidly developing and unprecedented world events have challenged organizations to quickly adapt to a new reality. Recent events have forced governments to enact social distancing measures and business closures that have disrupted daily life and work.

Quest & One Identity understand the complex challenges of pivoting a large workforce to remote work while ensuring business continuity. We know because we did it ourselves – and we want provide technology solutions to more effectively support your customers during this time. Please join us for this exclusive partner webinar where we will cover:

• Best practices and suggestions for helping your newly remote workforce be productive.
• Industry trends during this pandemic and solutions to provide business continuity
• Campaigns and collateral available for relevant outreach to customers
• What’s new with our Partner Circle programs in FY21.

Speaker: Joseph D'Antoni

REGISTER HERE

Get more insight into using SQL Server 2019! This release has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.

In this session, you will learn about:

• Scalar Function Inlining
• Table Variable Optimization
• TempDB In-Memory Metadata
• Batch Mode on Rowstore
• and more

You’ll see the best use cases for each of these features, watch demos for how they work and learn about any limitations these features may present.