Browse by Tags

Related Posts
  • Blog Post: Best Practices Analyzer for ISV SQL Servers to protect your company’s property

    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 for your firm. Microsoft provides two versions of...
  • Blog Post: Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

    [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 they save. Indexes primary use is to find records...
  • Blog Post: Fundamentals: Creating a Workload by Using a Trace Log

    [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 light in Information Technology expertise. In this...
  • Blog Post: Telvent: For the Smart Grid, smart utilities use SQL Server

    Telvent Designer allows the next generation of infrastructure needed to support modern commerce to be designed. Microsoft SQL Server 2008 supports spatial data -- the locations of items expressed as longitude, latitude. Modern GPS devices can locate items within a few feet. SQL Server spatial ability...
  • Blog Post: Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

    [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 Engine Tuning Advisor to identify performance...
  • Blog Post: Migrating from Oracle to SQL Server

    [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 those days, computer manufacturers often had different...
  • Blog Post: Telvent: ArcFM Support for Microsoft Platforms

    I have listed below which Microsoft technologies are supported by Telvent ArcFM with the release of 10.0.1 SP1. Architecture Tier Product Operating System Client IE 6 SP1 IE 7 IE 8 Windows 7 (32 +64 bit) Windows XP SP3...
  • Blog Post: Telvent: The other Grid runs on SQL Server 2008

    Telvent’s ArcFM Enterprise GIS Solution is a complete utility GIS solution covering electric, gas, sewage and water grids. Without the electric grid, grid computing would not happen. Your utility infrastructure is managed more efficiently and effectively through ArcFM. ArcFM provides tools for...
  • Blog Post: Telvent: When the lights go out, SQL Server is working to turn them back on!

    Telvent’s Responder Outage Management Solution (OMS) reduces outage time for customers from power outages. Outages may result from adverse weather, aging power infrastructure, and energy constraints. Responder OMS significantly improves the dispatch and management of crews over prior systems. Responder...
  • Blog Post: Telvent: The Future of Enterprise Utility Solutions

    Today's utilities face the challenges of tighter IT budgets, reduced in-house development staff, and the need to quickly deliver business benefits through applications. Utilities also need to adapt to the rapid changes in smart grid technology, the electricity distribution system of the future. Telvent...
  • Blog Post: Right sizing ISV installations for the best bang for the buck!

    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 working off valid but stale past knowledge. Two...
  • Blog Post: Benchmark Results: Telvent ArcFM Solution running on SQL Server

    Telvent, a leading provider of IT solutions and business information services, works with Microsoft to develop integrated solutions that can help utilities better use their distribution assets for maintenance and growth. The companies recently joined forces to conduct real-world scalability and performance...