Posts
413
Comments
230
Trackbacks
42
Database
Local LINQtoSQL Database For Your Windows Phone 7 Application
There aren’t many applications that are of value without having some for of data store. In Windows Phone development we have a few options. You can store text directly to isolated storage. You can also use a number of third party libraries to create or mimic databases in isolated storage. With Mango we gained the ability to have a native .NET database approach which uses LINQ to SQL. In this article I will try to bring together the components needed to implement this last type of data store and fill ......
Posted On Thursday, September 6, 2012 12:35 PM | Comments (0)
TechEd 2012: Fast SQL Server
While I spend a certain amount of my time creating databases (coding around SQL Server and setup a server when I have to) it isn’t my bread and butter. Since I have run into a number of time that SQL Server needed to be tuned I figured I would step out of my comfort zone and see what I can learn. Brent Ozar packed a mountain of information into his session on making SQL Server faster. I’m not sure how he found time to hit all of his points since he was allowing the audience abuse him on Twitter instead ......
Posted On Friday, June 15, 2012 3:53 PM | Comments (1)
What Is INET_ATON And Why Is It In A 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 | Comments (0)
The Importance of Having the Right Index
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 | Comments (0)
Creating Parent-Child Relationships in SSRS
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 | Comments (0)
Fun with Oracle CLOBs
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 | Comments (1)

Tim Murphy

Tim is a Solutions Architect for PSC Group, LLC. He has been an IT consultant since 1999 specializing in Microsoft technologies. Along with running the Chicago Information Technology Architects Group and speaking on Microsoft and architecture topics he was also contributing author on "The Definitive Guide to the Microsoft Enterprise Library".



I review for the O'Reilly Blogger Review Program



Technorati Profile

www.flickr.com
Tag Cloud