in

MySoftwareStartup

Dedicated to help those that own or are thinking of owning a software development company

Randy Walker Blog

Randy Walker's Blog website where he shares his experiences while being a software entrepreneur, Microsoft MVP, and industry influencer

March 2008 - Posts

  • Preferred method for read only Config files

    I had come across an article where you can use the following line to read custom section settings from your config file (where SectionName is the name of your section) in .Net.

    NameValueCollection myData = (NameValueCollection)System.Configuration.ConfigurationManager.GetSection(SectionName);

    The advantage of this is your setting doesn't have to be in the app.config file (web.config).  You can have a file named mywackyweirdfilename.config, and you use the exact same line.  The beauty of it is in the app.config (web.config) file where you point it to reference the mywackyweirdfilename.config.  e.g.

    <configSections>
         <section name="SectionName" type="System.Configuration.NameValueFileSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
    </configSections>
    <SectionName file="mywackyweirdfilename.config" />

    Why is this such a beautiful way to handle your config file?  Because if you distribute your application, the system administrator can decide where to put the mywackyweirdfilename.config file.  It could, in fact, reside on a public share (although not recommended in case of the network being unavailable) or thumb drive.

    So what's the problem?  You can't write to the config file easily.  I'll do a later post on my solution for writing to the config file, in which the format of the mywackyweirdfilename.config does not match below .

    The format of mywackyweirdfilename.config for the examples above:

    <?xml version="1.0" encoding="utf-8" ?>
    <SectionName>
         <add key="myKey" value ="" />
    </SectionName>

    Technorati Tags: ,,
  • To bug the Microsoft MSDN Evangelist, or not to bug

    Excellent times ...

    image

    image

    image

  • SQL Server Reporting Services Licensing Info

    After presenting at the Tulsa SQL Server SIG I received the following question:

    According to all the blogs if you install SSRS on a web server it still burns up another SQL server license even if you don’t install SQL.  Our production SQL server costs like $30,000 for the enterprise version because it’s on an 8 core box.  The SharePoint server where I am trying to install SSRS also has 8 cores.  For SharePoint you have to install SSRS on the web server or it will not work.  Is there a cheap version of SSRS that won’t cost 30k?

    Below was my response:

    Attached is a document I found detailed your licensing options.  Initially I thought you would not be able to get around buying an Enterprise license because it is the only version supporting 8 processors (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx).  However, it says “Processor licenses are available in Enterprise, Standard, and Workgroup Editions and offer more simplicity for certain scenarios.”  So, you should only have to purchase a workgroup license for 8 processors.

    However, there are specific features of SSRS that are specific to the version licensed.  Such as the Enterprise version only supports Data Driven Subscriptions (you can have data trigger the running of a report), plus others.  I believe e-mail subscriptions are a Standard version feature, which is a must have IMHO.

    The real question is going to be if you can talk to the person responsible for purchasing/licensing to figure out how to buy the standard workgroup or standard license, plus the additional licensing for the additional processors.  Don’t forget, I’m betting there isn’t 8 processors, because of the newer multi core processors.  So make sure you verify the number of hard processors.

  • Getting more out of SQL Server Reporting Services Charts

    Summary: This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how to design better charts. (32 printed pages)

    Click here to download the associated sample code, GetMoreChartsSamples.exe.

    Click here to download the Word version of the article, MoreSSRSCharts.doc.

    http://technet.microsoft.com/en-us/library/aa964128.aspx

  • SQL Injection article

    It's hard to believe that SQL injection is still an issue.  My friend Zain Naboulsi gave us a great overview of basic security hacks and how to defend against them at our last MSDN Express event.  I recall learning about SQL Injection issues over 12 years ago in my first job.

    Here's a fairly decent article about some of the details of SQL Injection, in case you're not familiar with it's problems.

    http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

  • Join the Microsoft Game Studios Beta Program

    If you're interested in joining Microsoft's beta program for games, you'll be interested in the following email I received.

    We are gearing up for a year of great betas. To prepare for these upcoming betas we have a new survey on the beta website. Please follow this link to access the new survey: (link removed). We will be using this new survey to select participants for our betas. If you do not complete this new survey, you will not be able to participate! But don't worry, the survey is quick and painless.

    Remember, we are always looking for all types of game players. Whether you play once a year or every day, whether you pre-order the latest consoles or wouldn't think of paying for a game - we want feedback from you! If you know of someone who would be interested in participating in the Microsoft Game Studios Beta program, please feel free to forward this mail or direct them to: http://connect.microsoft.com/mgsbetas.

    Technorati Tags: ,
  • Pictures of the 1st Fort Smith .Net User Group Meeting

    A bit thank you goes out to Anthony Potts for sharing these pictures.

    03-03-08-Raymond 03-03-08-Crowd 03-03-08-Randy

  • State Government kudos

    This is not a tech related blog posting.

    I started out the day regretting all the phone calls I had to make.  Two collection calls and then a call to the state government about a mixup I made.  For some reason when it comes to paying my state withholding tax, I always seem to mess it up.  They have this little form that you are supposed to send in, with the month and year filled in for you.  (Why they don't have a way to file and pay online, is another story for another blog posting)

    I seem to always neglect putting the form in or putting the wrong form in.  Needless to say back in November I royally screwed things up.  Being the typical slow government, they didn't notify me until months later.

    All this is to say a big thank you to Patty in collections at the Arkansas State Government.  She stuck it out and helped me contact various people so that everything was fixed.  When I asked to talk to her boss so I could give her a little thank you, she responded with "no need, it's my job."  How true, I only wish everyone thought that such good customer service is their job.  What a nicer world it would be if it was.

    Posted Mar 11 2008, 02:43 PM by Randy Walker with no comments
    Filed under:
  • Free DevExpress .net controls

    I ran across an ad today that linked me to where DevExpress is giving away over 40 controls for free.  I'm a big fan of two of their products (which unfortunately aren't free), CodeRush and their Excel like grid control.  Their grid control is a huge hit amongst the Excel heavy business users I typically deal with.

    The free sets of controls you get are:

     

    You can register here for it: http://www.devexpress.com/Products/NET/WebRegistration/index.xml

    Technorati Tags:
    Posted Mar 06 2008, 10:46 PM by Randy Walker with no comments
    Filed under:
  • SQL Server Management Pack

    I found this nugget of a tool today.  I haven't tried it out yet, but it sounds like one terrific tool.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en

    The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects.

    Feature Summary:

    • Active Directory Helper Service
    • SQL Server Agent
    • Backup
    • Databases and Tables
    • DBCC
    • Full Text Search
    • Log Shipping
    • Clustering
    • DB availability
    • Replication monitoring
    • Agent jobs
    • Backup Query Engine
    • Replication
    • Web Assistant
    • SQL XML

  • First Fort Smith .Net User Group Meeting

    Last night was the first meeting for the Fort Smith .Net User Group.  It was a great turnout of 38 people and featured Raymond Lewellan talking about Behavior Driven Development.

    You can read more about the event from the following blogs:

    Michael Paladino

    David Mohundro

     

Copyright 2008 Randy Walker
Powered by Community Server (Commercial Edition), by Telligent Systems