Tim Murphy's .NET Software Architecture Blog

Database

There are 11 entries for the tag 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 ......

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 ......

Choosing A Windows Based Web Hosting Service

Recently I have gone through the process of selecting a web hosting company for one of my clients. There are a lot of options out there and a number things you need to be cautious about. I will go over some of the decision points and questions you will want to ask a company before signing a contract. The first thing you need to do is define the features that make up you site. Is it made up purely of static content or does not use a database? If that is the case then you can choose just about any ......

The Power Of Windows Phone 7 Tasks

One of the things that is important to learn when you are developing any application is how it will interact with the environment it lives in. I’m not talking about simply interacting with files or database but with major resources. With WP7 there are a number of things such as the photos, browser, maps and the phone itself that your application may be concerned with. The WP7 development API includes a number of access points to give your application greater reach. These APIs can be found here. They ......

SharePoint Lists Vs. Database Tables

I got a question from a developer whether they should use SharePoint lists or database tables to hold the data for his application. This is a fair question and as a consultant I will start with the standard answer: It depends. I will follow up that answer with the standard consultant question: what are you trying to do? There generally isn’t one answer for any technology choice. We need to take as many factors into account as possible. Who will be maintaining the data? Will the data only be used ......

Beginning Windows Phone 7 Development

Windows Phone 7 development is an exciting topic. I have been exploring WP7 development for a little while now and I figured I would post some of the basic concepts that might be helpful to beginners. So here they are in no particular order. Panorama control I kept seeing references to the Panorama Control. It seems that this was a control that existed separately during the beta for WP7. In the final release this is now incorporated into a page type, so you won’t see the control in the toolbox. So ......

Architecture Blooming In Chicago

For the last three years the Chicago Information Technology Architects Group has been the only community in the Chicago area for Software Architects, Enterprise Architects, Infrastructure Architects and Database Architects. Suddenly this is changing. The first change was a special interest group created by member of the Chicago .NET Users Group (CNUG). This has just started in the last couple of months. Now it was just announced that IASA is finally launching a Chicago chapter. This is something ......

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 ......

This Developers Life Podcast

This Developers Life is a podcast put out by Scott Hanselman and Rob Conery. In the most recent episode there were a couple of things that really struck me. The fist was on motivation. Why is it that we keep spending every free hour keeping up with the latest technologies and techniques? Personally, I have always enjoyed the satisfaction of solving problems with technology. Hey, if you aren’t one to join sports then you need some sort of challenge. Of course getting to play with new toys like Windows ......

Queue Hell

I have come across a situation at a client where they believe that queues are the answer for everything. It is how they abstract their database from the applications. The battle cry seems to be “If we go through a queue it is more flexible and ensures that messages between apps will get to their destination. While I do believe that queues such as MSMQ and MQ Series have their place, they are not the answer to all the worlds woes. Of course the same goes for any technology. I have heard of companies ......

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 ......