Database
While converting some MySql databases to SQL Server I ran across this function. Confused by the lack of hints to its purpose in the name I did what any red-blooded IT person would do… look it up. It turns out that this function turns the string representation of an IP address into a long integer. What good that does I am still not sure, but here is the jist of the operation. (octet1 * 256^3) + (octet2 * 256^2) + (octet3 * 256) + octet4 Simple enough, right? Now for the real question. What the heck...
Posted On Tuesday, March 22, 2011 12:18 AM | Feedback (0)
As I have been working on SQL Server Reporting Services reports the last couple of weeks I ran into a scenario where I needed to present a parent-child data layout. It is rare that I have seen a report that was a simple tabular or matrix format and this report continued that trend. I found that the processes for developing complex SSRS reports aren’t as commonly described as I would have thought. Below I will layout the process that I went through to create a solution. I started with a List control...
Posted On Monday, February 14, 2011 4:47 PM | Feedback (0)
We have been having prolonged adventures with this wonderful data type on my current project. We are storing XML data in a CLOB field. In the beginning we used the Oracle ODP.NET provider. When we got into performance testing we found that saving this data killed our performance. A couple of the developers did some testing and found that the Microsoft Oracle provider worked at least an order of magnitude better. I was a little skeptical about moving to the Microsoft provider because I remembered...
Posted On Thursday, April 13, 2006 5:26 PM | Feedback (1)
Here is another story from the trenches. My current project was having mysterious errors coming from its Oracle database, but only under load. Specifically we were getting the following: ORA-01013: user requested cancel of current operation This one had me stumped. How could this happen. I searched the code line by line. I got assurances from the testing team that the testing tool was waiting for the last byte to return before navigating away from the page. I scoured the web for any hint of what...
Posted On Tuesday, March 21, 2006 12:35 AM | Feedback (0)