This presentation starts with the basics you need to know as an app developer about interacting with your PostgreSQL database. Then, it digs into how you can start to analyze performance. You will learn what you need to know for a small application, then the things you should be cautious …
Triggers, more specifically DML triggers, are blocks of code that run automatically when the associated event occurs on an Oracle database table. Some developers use them a lot. Many others say “Never use triggers!” What’s a DB dev to do? In our September PL/SQL Office Hours, Chris and Steven explore …
This presentation discusses how to get great MySQL performance while being practical – spending time on what gives you the best return. It covers the main areas for improving MySQL performance, pointing out the most important things you need to get right for each of them.
If you are experiencing deadlocks in SQL Server, you want to know more about them. What queries are causing them? What tables and indexes are at the root of the problem? You can find this information by using tools such as trace flags, Profiler, and Extended Events.
Gerry Narvaja of Tokutek discusses Performance at Scale with TokuDB. TokuDB is an open source, high-performance storage engine for MySQL and MariaDB that dramatically improves scalability and operational efficiency. TokuDB is for Big Data applications with demanding requirements that are not met by the your current storage engine, and reduces …
You have heard the term ‘parameter sniffing’, but you’re always a little bit fuzzy on the details. Is this a bug in SQL Server? Could it be happening to you? This video explains the truth about this complex and often confusing feature in SQL Server.
