TechNet Blogs

Resources

Benchmarks
Itron Enterprise Edition Meter Data Management can support 10 Million meters on a SQL Server 2008 R2 Enterprise Edition Benchmark test results overwhelmingly confirm that Itron Enterprise EditionTM Meter Data Management v7.0 SP3 is a highly scalable system, capable of supporting 10 million meters on SQL Server 2008 R2 Enterprise Edition under real-world conditions. IEE MDM has powerful processing capabilities and the ability to scale on SQL Server—along with reduced licensing, hardware, administration, and support fees.
Webcasts
Best practices for deploying Itron Applications on SQL Server: In this webcast experts from Microsoft and Itron discuss the best practices of deploying Itron Applications on SQl Server.

Enterprise Applications on Microsoft SQL Server

| |

Enterprise Applications on Microsoft SQL Server

Itron: Latest Benchmark hot off the press... IEE MDM v7.0 SP3 on SQL Server 2008 R2 is something to talk about!

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
This spring there has been extensive benchmarking done with the Itron team on Itron Enterprise Edition Meter Data Management and Microsoft SQL Server 2008 R2 Enterprise, which I have been following. A few weeks ago there was a webcast with Itron's Robert...
Enterprise Applications on Microsoft SQL Server

ITRON: IEE MDM Support for Microsoft Platforms

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
I have listed below which Microsoft technologies are supported by Itron's Enterprise Edition Meter Data Management. Architecture Tier Product Operating System Client (Rich Client Userface...
Enterprise Applications on Microsoft SQL Server

Migration: The value gained moving from Oracle to SQL Server 2008R2

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[DB2 Migration Value] [ Sybase Migration Value ] In the early 1980's I was an Oracle Developer on mainframes and on MS-DOS using Oracle 5.1 on MS-DOS (distributed on some 20+ diskettes -- I still have them). It was an interesting time because PC products...
Enterprise Applications on Microsoft SQL Server

Itron: SQL Server 2008R2 contributing towards a greener planet

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
In an older post I described the performance of Itron's Enterprise Edition Meter Data Management (MDM) Version 5.3 using SQL Server 2005. Today, you can read about Version 7 performance on SQL Server 2008 R2. The performance has increased to handle the...
Enterprise Applications on Microsoft SQL Server

Migration: The value gained moving from DB2 to SQL Server 2008R2

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Oracle Migration Value] [Sybase Migration Value] Two decades ago, I made my living as a DB2 developer working for GTENW (now Verizon). In this year's spring-cleaning, I came across my old DB2 certificates; perhaps it is time to do a spring-cleaning...
Enterprise Applications on Microsoft SQL Server

Itron: Cutting edge technology running on .Net 4.0 Parallel Computing

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
The classic Moore's law has the power available from CPUs doubling every two years. This is true but there has been a slight critical change. Ten years ago I purchased a high-end developer laptop that ran a single core 3.2 GHz CPU that left me with a...
Enterprise Applications on Microsoft SQL Server

Itron: 3 Billion Readings/day recorded on SQL Server - helping make the planet greener

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Advanced Metering Infrastructure (AMI) is changing the face of the utility industry and helping make the planet greener. There is an old saying, "Information is power!", the AMI version of this is " Information saves power !". The technical problem is...
Enterprise Applications on Microsoft SQL Server

Itron: Central Maine Power Chooses SQL Server to run their Smart Grid Initiative

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Itron's Enterprise Edition Meter Data Management (IEE MDM) with be used for this advanced smart grid project. The project allows customers to: View their usage Make changes in the way they use electricity Thus, control how much they spend...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

Posted over 2 years ago

by Ken Lassesen
- 3 Comments
[Prior Post in Series] [Next Post in Series] In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor. In this post, I will look at the other side of the coin and delete indexes that are unused or that cost more resources than...
Enterprise Applications on Microsoft SQL Server

Itron: Webcast on Best Practices for Deploying Itron Applications on SQL Server in April

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Time to mark April 27th, 2011 at 10:00 AM Pacific on your calendars! Lonnye Bower, Developer Evangelist, Microsoft Corporation will be presenting on the best practices for deploying Itron applications on Microsoft SQL Server 2008 data management software...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

Posted over 2 years ago

by Ken Lassesen
- 1 Comments
[Prior Post in Series] [Next Post in Series] In my last post Fundamentals: Creating a Workload by Using a Trace Log , I illustrated how to create a workload. In this post, I will look at the complimentary step, using the log as input to the Database...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Creating a Workload by Using a Trace Log

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Next Post in Series] This is the kick-off post of a regular Friday series of posts, " Basic Skills for SQL Server ISV Administrators ". I have found that ISV Administrators are often Professional Engineers (P.E.) -- rich in business knowledge and...
Enterprise Applications on Microsoft SQL Server

Best Practices Analyzer for ISV SQL Servers to protect your company’s property

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
The intellectual property(IP) or other valuable information may be stored on SQL Server in your ISV product. Its value is more than credit card records (credit cards can be cancelled if lost, IP can’t). It may be the equivalent of a state secret...
Enterprise Applications on Microsoft SQL Server

Migrating from Oracle to SQL Server

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Next Post in Series: Kronos Migration] My first experience with data migration dates from the 1970’s when a firm was moving from a Honeywell Mainframe (64KB of memory, no DASD -- just tape drives) to an IBM 4331 (2 MB of memory and DASD). In...
Enterprise Applications on Microsoft SQL Server

Right sizing ISV installations for the best bang for the buck!

Posted over 2 years ago

by SQL Server ISV
- 0 Comments
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . Recently I have seen two configurations that caused me to shake my head in disbelief. In reality, the problem is the classic one of people...