Posts
413
Comments
230
Trackbacks
42
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 ......
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)
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 ......
Posted On Monday, February 27, 2012 10:27 PM | Comments (0)
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 ......
Posted On Friday, August 19, 2011 9:04 AM | Comments (0)
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 ......
Posted On Wednesday, June 15, 2011 7:21 AM | Comments (2)
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 ......
Posted On Friday, April 1, 2011 2:04 AM | Comments (0)
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 ......
Posted On Tuesday, March 22, 2011 3:18 PM | Comments (0)
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)
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 ......
Posted On Tuesday, November 30, 2010 4:27 PM | Comments (0)
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 ......
Posted On Thursday, August 24, 2006 1:47 AM | 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