A wealth of knowledge on SQL Server Wait Types awaits you in our Waitopedia site. Our in-depth information on SQL Server wait types gives you the upper hand when SQL Server performance is hindered due to one of these wait types. Wait statistics can point…
I remember as a young lad of 12 years of age writing letters to friends and family that I had grown up with. As I would finish the letter, I would jump on my bike and run to the local post office to purchase a stamp for the letter. I’m not going…
During October 2015, Oracle announced that the Extended Support Fee for Oracle Database 11g R2 will be waived until May 31, 2017. After this period, Extended Support for Oracle Database 11g R2 will be offered until December 2020.
A primary concern for…
We have all read the headlines: Earlier this month, Delta Air Lines experienced a massive power outage that led to the cancellation of thousands of foreign and domestic flights. This seismic event took place at the height of the summer travel season…
In database replication, “immediately” never feels quite fast enough for your users, does it?
“We replicate transactions from production databases in real time,” you tell them. “You’ll see the change immediately, as soon as the transactions…
In this blog, I want to share a scenario that happens when not all the local components are not present doing a specific type of install.
When selecting ‘Create a New Connection’ | ‘Salesforce’, there is nowhere to enter the connection data, such as…
Third-party validation. No, its purpose isn’t just to stroke our egos in admiration. Nor is it a meaningless attaboy. (“Way to go, little Timmy! You did good today, kiddo.”)
No, third-party validation acts as affirmation — a gut check…
Here is an annoying issue that hopefully will never happen to you.
For the most part, there is just one service account to run the Diagnostic Server; however, some users may decide, "Hey, I'm going to monitor one or two connections with my own…
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer…
My grandmother was the greatest. She was the iconic example of old world class and style… I never knew she was also a prophet.
As I was growing up, she would always take me aside and raising a finger crooked from age, she would point to me and…
As a database developer or DBA, you’ve lacked the proper tools to help you keep pace with the rest of your organization. You’ve watched your app-developing colleagues across the hall use agile to whiz through product releases and embrace DevOps to automate…
Let’s face it: We can’t all be the kind of hero who saves the world. But as a database administrator, if you could simplify database migrations and upgrades in your company, wouldn’t that make you a hero with your users and co-workers?…
One of the pitfalls of creating custom rules for Foglight is failure to take into account assumptions being made when crafting a custom rule. As a result this can cause unexpected results when different assumptions are made, for example when the individual…
To all you DBAs and database performance monitoring enthusiasts out there: Have you gotten your copy of the survey The Real World of the Database Administrator yet?
In my previous post, I highlighted several facts of DBA life noted in the survey, including…
“How can I cook when they’ve taken my kitchen away?”
Like the man in the photo, you may have to ask yourself that question now that Oracle Streams has been deprecated. If you depended on Oracle Streams for moving data in your database…
As a DBA, would you say that your database performance monitoring tasks are getting any less complex?
I thought not.
We commissioned a study called The Real World of the Database Administrator for a closer look at the facts of DBA life. In this post,…
The Association of Support Professionals (ASP) has announced the winners of its “Ten Best Web Support Sites” competition that showcases excellence in online service and support
As you know, time is your…
This release of Toad Intelligence Central includes the following new features and enhancements.
I meet a lot of database developers who have agile envy. Are you one of them?
Do you see your counterparts on the application development teams scrumming and sprinting their way to shorter product cycles? Do you watch app developers release 25 updates…
...So you can start building a water weenie.
Sure, you can spend your whole summer working on SQL Server performance tuning, but wouldn’t you really rather build and operate your own water weenie, like Windell here?
I thought so.
Windell is a…
If you've been noticing that you're not getting deadlock email alerts from Spotlight on SQL Server Enterprise even though alarms are popping up in Spotlight itself, then this workaround might be for you.
Before you move on though, I am assuming…
In my previous blog post, Our Communities Are Moving, you read about our plan to move our Systems and Information Management (SIM) communities starting with the Blog in July. We are happy to announce that our new Community and Blog are now available…
A multi-functional tool to manage user settings and assist in troubleshooting.
How many times have you fixed your Toad for Oracle’s settings the way you want it and would like to: As Toad for Oracle users, we know that Toad for Oracle is all about…
Toad™ Data Modeler 6.0 is a major release with new features and functionality.
Toad™ Data Modeler has always enabled its users to reverse engineer database structures, update models, design and generate SQL, compare models along with other…
It’s crazy - technology and business are moving faster than ever and you’re sprinting just to keep up. Meanwhile, your workday is wasted on tons of repetitive, day-to-day tasks. That’s why we hosted a Virtual Tradeshow.
The bad news…
