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 …
There’s little that’s more important than protecting your database and the data/information within it. The most common form of “attack” comes from SQL injection and, even though monitoring systems vendors as well as your company’s IT staff are highly aware of how critical it is to protect your database from …
Columnstore indexes and a new, vector-based query execution method called “batch mode”, can speed up query processing in data warehouses and data marts using SQL Server 2012 by a breathtaking 10X to 100X. This talk describes how to tune indexes, queries, and load processes to help your customers get the …
Learn how to improve the performance of your SQL Server database and understand when the recompilation of queries is necessary and when it is not. Understanding query compilation issues from an operational perspective requires intimate familiarity with two indispensable tools: Performance Monitor and SQL Profiler.
