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
An Interesting Problem with ODI: Unable to retrieve user GUID
One of my customers had a problem about logging in to ODI Studio. Their ODI implementation is configured to use external authentication (Microsoft Active Directory). The configuration was done years a...
Toad Data Point – SQL Editor Overview
The SQL Editor combines a powerful SQL and procedure editor into a single interface.The SQL Editor has many advanced features including those that allow you to quickly develop scripts, understand your...
How to generate fewer SQL alternatives
When you are optimizing a complicated SQL statement, Quest SQL Optimizer is capable of generating hundred to even thousands of SQL alternatives. While theoretical this may be nice, it is not practical...
