(Marco V.) I wanted to write a post on configuring the RMAN environment using the SHOW and CONFIGURE commands in Oracle Database 12c, but after few commands I decided to investigate about the differences on default RMAN settings between the versions 10g, 11g and 12c.
Author: SSWUG Research
Top selling items – revisited in 12c
(Kim Berg Hansen) April last year I blogged about TOP-N reporting using Top selling items as example. In Oracle 12c we now have a new FETCH FIRST syntax, so in this post I’ll revisit the Top selling items example showing where and how FETCH FIRST can be used and where you still need to know the anal
OOW13: First glimpses of the new SOA Suite 12c
(Lucas Jellema) During this week’s Oracle OpenWorld Conference, we were given some sneak peeks into the short term future of the Oracle SOA Suite.
How to make Map Reports in SSRS
(Jason Thomas) I was going through some of my old documents and found this article on map reports which I had written for a SSRS book (which didn’t go through because of some time related issues). I thought it might be useful to those who are looking to explore map reports in SSRS. So here it goes:-
HOW TO CONVERT TABLE DATA TO XML AND XML TO TABLE
(Devi Prasad) The below code explains how to convert the data in a table to xml form and then convert the xml back into table data.
Monitoring SQL Server and SharePoint BI Components
(Tyler Chessman) In “Delivering BI through SQL Server and SharePoint” (September 2012), I discussed the latest business intelligence (BI) components that Microsoft delivers through SQL Server 2012 and SharePoint 2010. Those BI components are highlighted in yellow in Figure 1.
Jquery Detect Scroll to Bottom of Page Reversed Bug
(Tech Zombie) Took me all day to debug this.
Sql Server: Use FREEPROCCACHE & DROPCLEANBUFFERS to free up plan cache and buffer pool
(SqlTimes) A quick one today; During development, I often find myself having to clear up SQL servers procedure cache before re-running a query. Sometimes I have a hard time recollecting the exact order of words.
SSWUGtv News: This week, hear about Metalogix’s brand new suite of email migration and archiving solutions!
Video Programming for IT Professionals
Techniques For Improving SQL Query Performance – Indexing, Parameterization and Partitioning
(Derek Colley) You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to