(Sourav Kayal) The next evaluation of web-based applications leads straight to AJAX, and more generally, rich internet applications. In this article we will discuss various AJAX patterns in modern web applications. We will expect that you have a basic understanding of AJAX technology concepts.
Other News
Simple tuning example but uncertain test results
(Bobby Durrett) Last week I came across what seemed like a simple query tuning problem. A PeopleSoft batch job ran for many hours and when I did an AWR report I found that the top query was doing a full scan when an index should help.
Invisible Indexes (Part 2)
(Andrew Reid) In Oracle 11.1.0.6.0, you could not run DBMS_STATS against an invisible index or a table with an invisible index. I found 2 workarounds. You could run the old ANALYZE command or you could make the index visible on a temporary basis:
Are There Safeguards to Prevent the DBA from Dropping a Table?
(David Fitzjarrell) A recent IT-related survey had in its list of questions one rather interesting offering:
IBM Integration Bus vs. leading Open Source ESB – wise people learn from others
(A.Nariovich) When it comes to deploying a piece of infrastructure, clients have a wide selection of products. Some of the clients make decisions based on their previous experience, skills and research. Others take time and effort to evaluate a subset of products in order to select the best one base
Implementing A Basic LIKE/Wildcard Search Function In Power Query
(Chris Webb) Last week someone asked me whether it was possible to do the equivalent of a SQL LIKE filter in Power Query. Unfortunately there isn’t a function to do this in the standard library but, as always, it is possible to write some M code to do this.
Power Pivot: Managing Refresh
(Chris) Power Pivot workbooks need to be refreshed on a schedule. One of the coolest things about Power Pivot is that all that time that users had to spend gathering and scraping data from here, there, and everywhere is how seamless Power Pivot makes it.
Concurrent Access Resolution on LUW and DB2 for z/OS
(Daniel L. Luksetich) Concurrency is a critical performance aspect of any database application. While there are many options available to improve it, one of the more recent features that has quietly made its way into DB2 for LUW and z/OS is concurrent access resolution.
INGEST Part 2 – Marriage with Temporal Data
(Mark Gillis) Part 1 was a basic illustration of how INGEST can be used to provide a high-availability data replication mechanism without employing expensive and complicated ETL. In Part 2, I’m going to try and explore a few more complicated options: enriching or extending the data as it is ingested
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
(Pinal Dave) SQL Server Agent fails to start because of the error 15281 is a very common error.