Showing posts with label SQL. Show all posts
Showing posts with label SQL. 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: