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

kaufmed
kaufmed has been a member of Experts Exchange since 04/06/2004. Since then he has earned 30 certifications, including a Genius in C#.

To date, he has answered 3873 questions, written 8 articles, and posted 14328 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
jwhst10 posted a comment! Microsoft Access Form to Add New Record to SQL Back-End 01/27/12 12:32 PM
liveaspankaj posted a comment! Testing and Publishing iPhone App for a client 01/27/12 12:32 PM
dlethe posted an expert comment! RAID 5 with 3 drives 01/27/12 12:32 PM
wasimibm posted an expert comment! Problem with importing table. 01/27/12 12:31 PM
capricorn1 posted an expert comment! Opening a Form to a specific record then turning off filter. 01/27/12 12:31 PM
jogos posted an expert comment! DBCC CHECKDB 01/27/12 12:31 PM
autocrib posted a comment! RemoteApp Certificate prevents authentication 01/27/12 12:31 PM
brianmfalls asked a question! Keeping Coldfusion from Timing Out. 01/27/12 12:31 PM
divinemr asked a question! Using Navicat Premium with Mysql db, how do I print multiple pages per sheet 01/27/12 12:31 PM
sazuke posted an expert comment! virus software 01/27/12 12:30 PM
7Souls posted a comment! Need a Perl script to calculate size in a file directory on Windows 2003 s… 01/27/12 12:30 PM
DavidMintz asked a question! Upcoming Reminders in Outlook 01/27/12 12:30 PM
jordannet posted an expert comment! Outlook 2010 No Free/Busy Information could be retrieved 01/27/12 12:29 PM
Kdo posted an expert comment! I need to keep to columns and flip to other columns as rows? 01/27/12 12:29 PM
_alias99 posted an admin comment! Google Map API 01/27/12 12:29 PM
jiggyfly asked a question! FLASH IE movie not loaded 01/27/12 12:29 PM
HainKurt posted an expert comment! Oracle Linked Server - queries slow 01/27/12 12:29 PM
waldorf71 posted an expert comment! ASP.NET Emails are going into spam 01/27/12 12:29 PM
Mutawadi posted an expert comment! Notification Icons - Not Saving after Customize on Citrix 01/27/12 12:29 PM
Programmer-x posted an expert comment! Testing and Publishing iPhone App for a client 01/27/12 12:29 PM
View More
 
View More Zones
 
View More Zones