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. <
Speaker: Pinal Dave
Every new release of SQL Server brings a load of new features you can a
Speaker: Joseph D'Antoni
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
Speaker: Brent OzarYou've been hearing about all these robots that are coming to take your job. They're going to automate all the SQL performance tuning and make your life way easier, right? Or harder, I guess...since you'll be looking for a job. Thing is, most of that is just plain old marketing hype that Microsoft is using, trying to sell your management on upgrading to newer versions or moving to the cloud. In this session, Brent Ozar w
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 tec
Speaker : Brent Ozar
If you get into a car, how do you know if the car is fast or not? You hold down the gas pedal, and you time how long it takes before you're breakin' the law.
Now what about SQL Server: how do you know if yours is fast...or a clunker? Database performance tuners need to know three metrics about their SQL Server: how fast it's going, how hard it's working, and how big it is. Brent Ozar will explain where to
Speaker: Brent Ozar
For years, you've heard that you're supposed to reorganize your indexes to make SQL Server go faster. It sounds like it makes sense - keep things in order, right? But you keep doing it, and SQL Server isn't getting any faster. You've even heard that setting fill factor will help prevent fragmentation, and you're doing that too - but your indexes still keep getting fragmented every day, and users aren't happy with SQL
One of the challenges of cloud deployments is choosing the correct sizing for your cloud database environment. Organizations 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.
In this session, we will discuss benchma
Resolve issues faster with continuous, scalable, web-based Sybase database monitoring.