Microsoft Technologies

1
Microsoft Technologies

• What it means to my clients.Benjamin Day

2
About the speaker

• Benjamin Day
• Owner, Benjamin Day Consulting, Inc.
• Email benday_at_benday.com
• Web http//www.benday.com
• Blog http//blog.benday.com

3
Best of

• SQL Server
• Ease of development with .NET
• Security
• Developer reference material
• Microsoft supported open source projects
• Open source community projects

4
Less

• Database server costs less
• Not as cheap as open source
• Hidden cost of not having good support

5
Oracle vs. SQL Server
http//www.microsoft.com/sql/prodinfo/compare/orac
le/pricecomparison.mspx
6
Oracle vs. SQL Server
7
(No Transcript)
8
SQL Server Wins

• Cheaper
• Easier to install
• Much easier to administer
• Self tuning
• Maintenance Plan Wizard
• Equal or better performance
• Simple to access from .NET

9
Before .NET

• Difficult to develop enterprise quality
  software with before .NET
• VB6 and ASP
• Adequate but you had to write a lot yourself
• ASP wasnt compiled ? no easy error checking
• No built in security
• Relied on IIS and/or COM
• Considered by many to not be serious
• Java

10
Then the clouds part

• .NET Framework
• ASP.NET
• C
• VB.NET
• Leveraged lessons learned from Java and ASP
  Classic
• Javas getting bloated
• Built real tools for developing serious
  application with Microsoft technologies

11
What does it mean to my clients?

• Time is money
• Cheaper
• Easier to use
• Unified development environment
• Integrates with
• Windows security (aka single sign on)
• SQL Server

12
Visual Studio 2005

• Goal Eliminate or streamline tedious web
  development tasks
• 80 / 20 Rule
• Membership
• Streamlined security
• Profiles
• Personalization, preference management
• Validators
• Simple client-side input validation
• DataSources
• Streamline display and modification of database
  information

13
.NET Security

• Mass. Department of Revenue
• Very concerned about security
• Needed a way to manage complex permissions for
  tax filers and preparers
• .NET integrates security into all places in the
  code
• Built in
• Available from the user interface code to the
  database
• Security system is extensible

14
Support

• http//msdn.microsoft.com
• http//support.microsoft.com
• Free technical resources for
• Fixing bugs
• Patch management
• Developer how to documents
• Administrator how to documents
• Readily available information means its cheaper
  to develop and support Microsoft technologies

15
Quasi-Open Source

• http//www.godotnet.com
• http//msdn.microsoft.com/practices/
• Sponsored by Microsoft
• Tools, utilities, frameworks, samples available
  for download
• Enterprise Library
• Database Access
• Caching
• Cryptography
• Logging
• Exception (aka Error) Management
• Security
• Saves development time
• Gives you reliable application building blocks

16
Open Source

• Avid developer community creating tools and
  frameworks for .NET development
• NUnit
• Testing framework
• Enables Test Driven Development
• High-quality, reliable software
• Constantly test software during development
• Not just at QA

17
NHibernate

• Object-relational data access framework
• .NET port of the Java-based Hibernate
  Object-Relational Framework
• Hibernate's goal is to relieve the developer
  from 95 percent of common data persistence
  related programming tasks.
• Reduces amount of code by gt25
• Allows the developer and development team to
  concentrate on The Real Business Problem