Showing posts with label SQL Database Development. Show all posts
Showing posts with label SQL Database Development. Show all posts

Tuesday, January 15, 2013

Database Index - SQL Wars - the battle for data

Database Index - SQL Wars - the battle for data

DATE: January 14th 2013
Walnut Creek CA-Knowing which database to choose is just as hard as choosing a database programmer or developer.  The leaders are Microsoft SQL Server, Oracle, IBM, SYBASE, Progress and then on down to smaller niche solutions. 

SQL Server 2012 is now a mature product - seasoned, tested but in use by the millions while tightly linked the dreaded Microsoft Licensing Model which requires a great of finesse to manage.  


To be continued .....  
Share:

Friday, January 11, 2013

Blogging For Page Views

Contact Pete's Team 925-399-1082

Blogging for Page Views

Walnut Creek CA: One of the main reasons I'm using Blogger or Blogspot is during my testing phase it was clear that Google was indexing pages nearly on the spot.  The traffic patterns was noticeably better with near instantaneous search updates as some pages appeared in minutes.  I also operate another blog that gets far more traffic but it not related to tech, they have broader audience but technical the articles required a great deal more effort to "get it right" which if you've ever written a tech page then you'll agree as one mistake can leave the reader super ticked at you the writer.

As time goes by this blog will have thousands of pages but eventually I'll drive it from an ASP.NET Blog Engine or my own personal version or perhaps I'll be in the after-life looking down and laughing at my mistakes but chances are during the pearly gates inauguration period the code will be quite useless as the next release is always.

There are a number of factors why a database engine is needed as Blogger is not a database at the end user level but it does run on a database.  There are numerous weak spots such as auto-indexing, custom sorting, page layouts that could be better but search limitations have their moments but dammit it works.  Soon I'll be using SQL driven pages to create these pages and related indexes but I'll posting the code, forms, reports as sort of an incubating project.

Blogger is fast way to find an audience but this long time web developer never considered blogging to be viable as I went what a bunch of bull ---- but alas I'm here.

By morning this new page will be indexed on Google Search.  Hurry, the mean Google Search Machine is seeking the ROBOTS.TXT file - no file? no problem they gonna take every page.

Careful for what you wish for and careful what you post.



Share:

Wednesday, January 9, 2013

MS Access or SQL Database Development

MS Access Custom Form

















MS Access or SQL Database Development

Quality database using MS Access or SQL Server

  • Administering SQL server databases.
  • Backups, Recovery, jobs, linked servers,
    • Triggers
    • SQL Profiler
Replication
  • Implement and troubleshoot replication in SQL server environment
  • Writing TSQL ad-hoc queries and reports
    • SSRS reports
    • Custom Report and Business Intelligence Reporting
  • Stored procedures;
    • SQL Server Functions 
    • Creating database objects, ,
    • SSIS packages
  • · Designing and Implementing SQL server databases
  • Expert Data Translation
    • Moving data between SQL Server, ACCESS and ORACLE
    • Creating, testing and troubleshooting patterns/problems using .NET, C#  and VB
  • Collaborating with team members to establish data requirements
    · Automating complex tasks through scripting
  • Installation, Support and Maintenance
Share:

Tuesday, December 18, 2012

BRIEF HISTORY OF PAST PROJECTS


A Brief History of Past Projects


The projects are shielded to protect clients from marketers, spams and unsavory salespersons who have in the past have used my resume to build their client list. 

Important Information about past clients. 

I strive to remain current in technology as much as humanly possible but the focus is squarely set Microsoft technology and ASP.NET

Software Development – 1990 to Present
Develop custom database applications; provide software services and business consulting to various companies primarily in the Bay Area. Developing applications using the majority of current social networking tools and API.



Managing Resources
Managed application developers, Graphic Designers, multi-media professionals and Creatives for the purposes of managing projects.

Projects utilized numerous technologies but our focus was constantly stay current with leading technology to be fully prepared when major revisions would roll out.

Mortgage Industry – Present 
Strong knowledge of back end mortgage processing, debt consolidation, HELOC, default rates, developing real estate marketing systems for mortgage brokers, contractors, and real estate agents.

Mortgage Loan Agent – Present 
Independent loan representative originating home mortgages, commercial loans, and home refinancing. Originate customers, loans, sourced clients through various marketing programs and efforts. Strong ability to interpret loan rate sheets and loan programs.

Terra Vista Software Walnut Creek CA 2004/05Developed software testing application for SonyStyle.com project, evaluated application architecture, made recommendations and implemented strategy to replace underlying software model.
Built For My Son 2003
 

Cabinetmaking Shop – Fairfield CA 2003-2004
Owner of custom cabinet shop, built and designed cabinets, fixtures and restaurants under temporary operations for 9 months, sold business operations back to owner.

Contra Costa County Summer 2001
Developed with MS Access database to that extracted and analyzes telephone billing calls and patterns.

SBC/Pacific Bell- San Ramon CA Summer/Fall 2001
Develop customized application for DSL order department using ASP Classic , VB and Internet.
Wells Fargo Bank 2000/2001 – Internal IT tracking database
MS Access database for managing internal projects and initiatives.




Jobwire.net – Authentic Technologies 1998-2004
Developed an internet job posting board for Dot Com Web Play. Successful revenue generating operation - ASP Classic and SQL.

Plan-it Interactive –1999-00 
Developed customer and account management database. Installed WAN/LAN for five locations. Automated business processes, scheduled events, employees and trucks. Used MS Access and ASP classic.

MustangSoccer.com – Authentic Technologies 2000 
Development of a youth sports site complete with fields, schedules, players, and on-line registration system. Site was taken over by larger vendor and original site was donation from our firm.

Authentic Technologies –1997-2002 President
Founder of a software development operation consisting focusing on projects for the Dot Com boom, raised capital for multiple web plays, created joint venture agreements, cross marketing programs and customized business solutions.

Outlook Companion – Email management 1998-99
Developed add-in for client and then created a version for downloading. Used Outlook 97/98 to assist MS Office users with automation of tasks inside of MS Outlook.

www.FreeSportsPlay.com – Joint Venture Project
Lead architect for developing online gaming application that allowed users to play for points and prizes. Project consisted of integrating five developers focused on web development. This site is down as the venture folded.

Bank of America  –Loan Systems 
Developed internal mortgage tracking system to capture transactions related to Mortgage Transaction Processing.

PG&E  San Bruno Fire 
Developed internal tracking system specifically related to the San Bruno Fire in Sept 2010.  Project began in 2011 and finished later that summer.

Comerica Bank Developed custom reporting application using MS Access to track loan defaults and delinquent loan accounts. Integrated reporting data into MS Access and Excel for analysis via pivot tables.

AMI Flight Charter Operations - San Francisco 1997-98
Developed reporting application using MS Access to supplement flight operations scheduling program. Importing and exporting of schedules, airport arrivals/departures and expense data. Reports provided with detailed expenses for each plane.

Project Management Database- Authentic Technologies 1998-2000
Internal company database created in MS Access 2000. Tracks projects, customers, Utilizes MS Outlook libraries to manage Email, appointments and calendars. Integrates to MS project. Tracks employee time on projects, manages hosted clients DNS records, and generates billing statements. Created ASP web interface for client access. Tools: NT Server, ASP, SQL, MS Access, Java Script, VB script, COM, VB, CDONTS, Win32 API and MS Exchange.

McCready Insurance Summer 1998
Converted billing system using VB and MS Access. Migrated user to NT servers from Novell 3.x to Windows 4.0.

Levi Strauss 1997 
Developed Access/VB application to manage subsidiary cash flows. Provided currency translations, FTP upload from 88 subsidiaries located world wide. Project provided corporate treasurer with accurate information regarding cash on hand held by subsidiaries.

Irwin Home Equity – 1996-97
Developed a variety of applications for a fast growing mortgage loan company. Developed multiple applications in Access 2.0 and 95, DOS, Qbasic, VB 4.0 and 5.0, supported Eastern Loan Origination System, FiServe, Novell 3x, NT server 3.5, Created database to manage loan portfolio for 10 Q reports, portfolio cash flows available cash reserves.

Computer Land Stores– 1995-96
Developed in-house reporting system for tracking returns and shipments from distribution system. Primary tools were MS Access using ODBC against Sybase database. Rolled up data for integration with Excel using VB, VBA and Office 2.0 Automation. Reports provided clients with relevant reports on product pipeline, sales and production plus developed MBS Analytics.

Clone Zone 1990-93 
Retail computer store owner: Focused on selling new and used computer. Installation, repairs, service, networks, new systems, training and consulting. Authorized reseller for most major brands. Staff consisted of 4 employees, managed sales, marketing, advertising, purchasing and payables. Prepared all aspects of accounting and tax preparation requirements.

MainFrame Designs 1980-89 
Operated 10,000 SF mid-sized cabinet and millwork shop with ten full time employees. Design build operation focused on commercial fixtures, stores, schools, hospitality and restaurant trades. Projects included Moscone Convention Center, San Jose Airport, Tony Roma’s, Wendy’s International, McDonalds, Emporium Capwells, Macy’s, Flakey Jakes Restaurants, Fresh Choice. Contra Costa County Colleges District, UC Berkeley, Wells Fargo Bank, Chevron, Pacific Bell and many major chains in Northern California and Nevada.
Share: