(Tim Chapman) When data is inserted, updated, or deleted in a database table, if indexes exist that operate on the table, they must be maintained to reflect the table data changes. The maintenance of these indexes will eventually cause the indexes to become less efficient. This inefficiency is typic
Other News
Oracle BI EE 10.1.3.3/2 – Calling Java Scripts and Java Classes from iBots
(Venkatakrishnan J) One of the very good features of BI EE is its ability to call custom Java Scripts and Java Classes after the execution of iBots. Lets look at some examples today. In the first example we shall see how to save the reports scheduled via ibots to a local directory using a simple Jav
Error message when you run a maintenance plan after you set the ‘allow updates’ option to 1 in SQL Server 2005: ‘Alter failed for server’
Consider the following scenario. In Microsoft SQL Server 2005, you set the allow updates option to 1. Then, you run a maintenance plan. In this scenario, you receive the following error message: Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.
All About SQL Functions
(James Payne) In the last tutorial we left off with the SUM(column) function. In this article we will cover the remaining Aggregate Functions and the Scalar Functions. We might even make some fat jokes, some mama jokes, and as always, some nerd jokes.
Regular Expressions
(Joseph Fuda) Introduced in Oracle 11g the REGEXP_COUNT function greatly simplifies counting the number of times a pattern appears inside a string. The following examples demonstrate how to use REGEXP_COUNT with some simple patterns. For versions prior to 11g alternative logic that provides similar
Cannot Resolve Collation Conflict in the equal to operation
Collation in SQL Server are used to specify how the string data-types are sorted and compared with each other. This is based on the languages and their locales. There are Windows collations as well as SQL Server collations and we will cover collations in detail in a future blog post series that we
SQL Server Virtualization Discussion, Happy New Year!
Happy New Year! 2008 should be interesting… again. With the release of SQL Server, Windows Server, VS and all of the assorted tools and technologies, there is a lot happening that will keep us all watching the releases, the updates, the testing and so-on. I think there will be some great things to come out of both the new products […]
New players enliven open source
(Stephen Shankland) For years, the center of open-source software, at least from a commercial perspective, was with companies such as Red Hat, Novell, MySQL, and a number of smaller players. Those companies continued grinding away at their collaborative programming projects and support-centric busin
Enhance Your Apps with the Integrated ASP.NET Pipeline
(Mike Volodarsky) Almost a year ago I wrote an overview of IIS 7.0 in MSDN Magazine. That was several months before IIS 7.0 was released with Windows Vista. Since then, users have had a chance to experience the new IIS 7.0 componentized and extensible architecture and other improvements firsthand.
XsltTransformer: Transforming an xml string with an xslt string
(Dan Rigsby) There are many times when I have xml and xslt as strings and need the transformed data as a string. I put together a utility class to take care of this.