(Rasmita Dash) With traditional HTML and JavaScript, to get some data from the server side, it was necessary to make a form submission. With each submission the entire form was being reloaded. So it was loading an entirely new page and that was making performance slow.
Other News
SQL Developer 4.1 – Instance Viewer
(Jeff Smith) The SQL Developer team has been steadily adding features tailored to the DBA since the version 3.0 release. This steady march continues with version 4.1, which was released as an Early Adopter yesterday.
Changing The Number Of Oracle Database 12c Log Writers
(Craig Shallahamer) In an Oracle Database 12c instance you will likely see multiple log writer (LGWR) background processes. When you first start the Oracle instance you will likely see a parent and two redo workers. This is a very big deal and something many of us have been waiting for – for many ye
Optimising multi-threaded replication
(Arjen Lentz) Multi-threaded replication is a new feature introduced in MySQL 5.6 and MariaDB 10.0. In traditional single-threaded replication, the slaves have a disadvantage as they have to process in sequence what a master executed in parallel.
What is the difference between WHERE and HAVING clauses?
(Kris Wenzel) All the examples for this article are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server.
Making a Change Log Easier With PowerShell
(Rob) Having a Change Log is a good thing. A quick and simple place to find out what has changed on a server and when. This can be invaluable when troubleshooting, matching a change to a symptom especially when assessed alongside your performance counter collection.
Find all Occurrences of Text in all Stored Procedures in all Databases
(Larry Leonard) Sometimes you’d like to find all occurrences of a piece of text in every stored procedure, trigger, etc., possibly to replace it with a new value. The script below will do just that; it returns the database name, the object name, and the object type.
Exploring Query Plans in SQL
(Dennes Torres) SQL Server keeps the most-used execution plans in cache, so it doesn’t need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans? Let’s see how to find some opportunities for optimization by using information
Make Your System Highly Available and Recoverable Using PureApplication System
(Addison Goering) The goal of any enterprise is to operate systems uninterrupted for a long time and to reconstruct a data center’s operations in the event of disaster.
Cross-Platform Cloud Automation with JavaScript
(Steven Edouard) Not everyoneknows Microsoft Azure has the Cross-Platform Command-Line Interface (xplat-cli) for managing Azure Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS) services, but it does. For years, Microsoft has advocated using Windows PowerShell as a scripting langua