(Ghanesh Prasad) You have a requirement where users want to filter report data in SQL Server Reporting Services by entering a list of comma delimited values instead of choosing from a dropdown list. In this tip we show how this can be completed with Reporting Services.
Author: SSWUG Research
Practical SQL: DB2 at Home, Part 5, Building Tables with XML
(Joe Pluta) Last time, we took a little segue into creating XML from relational data. Now it’s time to return to the other direction, making relational tables from XML data. XML can easily support a complex nested relationship of data with both optional and repeating elements, but that doesn’t alway
Creation of Views with different options
(Chandrika Bandi) Views in SQL Server provides you to work with virtual tables, to hide complex queries or sensitive data.
Cleaning up after RUNSTATS
(Willie Favero) RUNSTATS, one of the best tools in a DBA’s toolbox. the importance of accurate statistics in the DB2 catalog cannot be over emphasized. To quote a conversation with a good friend: “When a customer reports a performance problem with a query or query performance regression, the over
DB2 Administrative SQL Cookbook: Identifying Dependent MQTs and Views
(Ember Crooks) When you’re considering dropping and re-creating a table, view, or MQT, it is critical to ensure that you consider any dependencies. When dropping a table, any MQTs that rely on it will be dropped, and views marked inoperative.
Show Search Data and Paging in ASP.Net Grid View Using jQuery
(Rahul Saxena) In this article I explain how to make a search application with paging in an ASP.NET Grid View using jQuery.
Interfaces and Lambda Expressions in Java
(Cay S. Horstmann) In this chapter from Core Java for the Impatient, you will learn about interfaces and lambda expressions, including static and default methods, method and constructor references, processing lambda expressions, variable scope, higher-order functions, and local inner classes.
SQLd360 with the AWR Warehouse
(Kellyn Pot’Vin) Mauro decided to give me another challenge- run SQLd360 against the AWR Warehouse and let him know how it does straight “out of the box”. It’s a simpler installation process than SQLTXPLAIN, you simply unzip and run, (no installation of any packages…)
Exporting SQL Developer Reports/Grids to PDF
(Jeff Smith) You can save query results or any other grid in SQL Developer as a PDF.
Review all item help texts
(Jeffrey Kemp) The business analyst or QA wants to check all the help texts for all items in your apex application – don’t force them to navigate to each page and click on the labels, one by one; instead, give them a spreadsheet to review at their leisure.