What is Experts Exchange?

Experts Exchange is a technology help website. Our experts are real people with real-world technology experience from around the globe. Microsoft MVPs, IT consultants and many more. They volunteer their time to provide tech support in our patented Q&A forums. If you've got a technology problem-big or small-we can help you solve it.
Learn why it works or Sign up and ask a question
 
 

How to Create User-Defined Aggregates in Oracle

sdstuber
How to Create User-Defined Aggregates in Oracle

Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and "COUNT". Previously the only way to achieve this kind of functionality across a set of data would be to write a pl/sql routine to iterate through a cursor.

The aggregates are defined in multiple parts, using Oracle's Object Oriented functionality. In structure it's somewhat ...

HOW TO: Add Local Storage (e.g. a SATA disk) as a Raw Disk Mapping (RDM) or Mapped RAW LUN to a virtual machine hosted on ESXi

hanccocka
In this article, I am going to expose some of the hidden, undocumented, unsupported features and functions of the VMware vSphere Hypervisor (ESXi).

VMware vSphere ESXi 4.x, and ESXi 5.0 does not officially support Raw Disk Mapping of Local Storage e.g SATA, SAS or SCSI disks.

Please use at your own risk, and if you do escalate a Support Request (SR) to VMware Support, do not be surprised if they state this is unsupported.

...

Loading Complex XML Using SSIS

ValentinoV
Introduction
In my previous article I showed you how the XML Source component can be used to load XML files into a SQL Server database, using fairly simple XML structures. In this follow-up article I will demonstrate how to tackle the complex XML issue.

The Complex XML Example
You probably know that SSRS reports, RDLs, are actually XML files. And they’re not the easiest types of XML files around. To humans they are still readable but the structure can be quite complex. So there we’ve got our example: an RDL. More specifically I’ll be using the RDL that’s available ...

Loading XML Using SSIS

ValentinoV
Introduction
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)

But how far can you go? When does the XML Source component become unusable? Let’s find out!

To create the examples I’m using the Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64).

...

HOW TO: Enable Jumbo Frames on a VMware vSphere Hypervisor (ESXi 5.0) host server using the VMware vSphere Client

hanccocka
The original payload size or maximum transmission unit (MTU) of an ethernet frame is 1500 bytes. A jumbo frame has an ethernet frame size of 9000 bytes or over. Common Jumbo Frame sizes are 9000, 9216 bytes (example - HP switches).

Enabling Jumbo Frames may help reduce storage latency and increase storage throughput when used in conjunction with iSCSI or NFS storage network protocols with a VMware vSphere Hypervisor (ESXi 5.0) host server and a storage area network (SAN) or network attached storage (NAS) device.
...

Top Technology Experts

DaveBaldwin
DaveBaldwin has been a member of Experts Exchange since 10/17/2003. Since then he has earned 33 certifications, including a Genius in PHP.

To date, he has answered 3846 questions, and posted 14604 comments on Experts Exchange.
 
 
Top Solutions
Today | All Time
View All
 

Visit Experts Exchange from your mobile device to search, ask, and monitor your questions. Never lose touch again.

Preview From Your Desktop
 

Help celebrate the Experts who protect the community from technological anguish. Now Presenting the 8th Annual Expert Awards!

View the Winners
 
Filter: Date
thmh asked a question! label not defined vba 01/28/12 02:09 AM
Mutawadi posted an expert comment! Citrix Problem - Can't launch published desktop/app - PS4 /… 01/28/12 02:08 AM
pergr posted an expert comment! Will a VLAN do this 01/28/12 02:05 AM
asaidi posted a comment! array into array result 01/28/12 02:05 AM
Fugas posted an expert comment! array into array result 01/28/12 02:02 AM
B_SIVARAMAKRISHNAN asked a question! How to query & fetch data from Oracle 8i database runni… 01/28/12 01:59 AM
GrahamSkan posted an expert comment! Word Address Tabel to Label type 01/28/12 01:58 AM
mickeyshelley1 asked a question! Problem With VBA Code Enabling Controls 01/28/12 01:57 AM
Osley asked a question! Server 2008 R2 - Script Needed 01/28/12 01:56 AM
MK15 accepted a solution! acquire huge collection of books 01/28/12 01:56 AM
consultkhan posted an expert comment! Share Team Server 2010 and Exchange Server 2010 on … 01/28/12 01:56 AM
Lorna70 accepted a solution! DropDownList populating a 2nd DropDownList with the selected value o… 01/28/12 01:55 AM
demazter posted an expert comment! MS Outlook 2007---PST Files 01/28/12 01:54 AM
ambergreenit posted a comment! Unable to log on to domain, server 2003 Terminal Services 01/28/12 01:54 AM
Lorna70 posted a comment! DropDownList populating a 2nd DropDownList with the selected value of… 01/28/12 01:53 AM
consultkhan posted an expert comment! Outlook Sync Errors 80040604-516-8004060… 01/28/12 01:53 AM
andymacf posted an expert comment! Word Address Tabel to Label type 01/28/12 01:52 AM
modus_in_rebus posted an admin comment! Printer Toner Level Utility 01/28/12 01:51 AM
demazter posted an expert comment! Exchange 2010 01/28/12 01:51 AM
gbadmin posted a comment! Folders Not Showing 01/28/12 01:48 AM
View More
 
View More Zones
 
View More Zones