Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the Azure … Continue reading
Related Articles
How to run SQL Statements across Pluggable Databases with catcon.pl
Introduction Beginning with Oracle Database 12.1.0.1.0, DBAs started to work with Pluggable Databases. There were some large migrations of several databases from 10g/11g to 12c where they were consoli...
SQL SERVER – PRINTing Status Using RAISERROR With NOWAIT Option
In this blog post we are going to learn about PRINTing Status Using RAISERROR With NOWAIT Option. The Problem There are many situations where you want to know which line of code is completed in th...
When to Use Server-Side Logic
The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The question has always been what amount of logic should be ...
