(Pinal Dave) SQL Server 2012 introduces new analytical functions FIRST_VALUE() and LAST_VALUE(). This function returns first and last value from the list.
Other News
DB2 best practices: Implementing DB2 workload management in a data warehouse
(Paul Bird and Rimas P. Kalesnykas) This article describes the best ways to implement a successful workload management solution using DB2 for Linux, UNIX, and Windows, Version 9.7.4 or higher. The information in the article reflects the latest experiences of IBM field personnel and customers within
Survivor
Survivor Some might say that holding down a job today is similar to playing the USA reality TV game show "Survivor". For those of you located where the show is not broadcast, Survivor starts with two teams in a remote location where the contestants must survive the elements by building shelter and finding food. Individuals must cooperate in order to […]
How do I capture a 10053 trace for a SQL statement called in a PL/SQL package?
(Maria Colgan) Traditionally if you wanted to capture an Optimizer trace (10053) for a SQL statement you would issue an alter session command to switch on a 10053 trace for that entire session, and then issue the SQL statement you wanted to capture the trace for. Once the statement completed you wou
DB2 Workload Management using Performance Optimization Feature
(Thuan Bui) See how one fictional company uses DB2® Workload Management and Optim Performance Manager Extended Edition to allocate database system resources to help a high priority application achieve its business objectives in a data warehousing environment.
The Problems of Managing MySQL’s Configuration
(Simon Mudd) I want to keep a record of the configuration of the MySQL servers I manage. The configuration of some servers differs from others and over time the configuration may vary, partly as a result of upgrades in the mysql version or the use of the particular mysql instance, so tracking this i
Writing A RequireJS Plugin To Load Remote jQuery Templates
(Ben Nadel) Over the past couple of weeks, I’ve started looking into RequireJS for asynchronous script loading and JavaScript dependency management. While I don’t have a lot of experience with such things, there is definitely something about RequireJS that feels really good. All the stuff that I’ve
XML Validation with XSLT & Calling Custom functions from XSLT
(Surya Prakash) In this article, I will discuss about validating XML against defined XSL. Prior to getting into this article, it’s mandatory that one should have basic knowledge on what XML & XSL are.
SQL Server 2008 R2 Generate Scripts Wizard with Database Schema and Data
(Ashish Kumar Mehta) While looking through the new features and improvements in SQL Server 2008 R2, we found a potentially interesting addition within the Generate Scripts Wizard in SQL Server Management Studio. Using the Generate and Publish Scripts wizard you can script out data stored in the tabl
Tips On How To Edit Documents Utilizing An XSLT Editor
(Michael) XSLT is brief for Extensible Stylesheet Language Transformations, which in common lingo means it’s a programming language meant to change XML paperwork into other kind of documents, whether or not it’s the identical format or some other format like HTML or normal text.