OpenSQL Camp Starts Tomorrow!


So the good news is that the inaugural OpenSQL Camp is going to be an awesome event with mouth watering sessions by noted experts. The bad news (for me) is that I won't be attending it, which makes me sad. I cannot leave my town because my wife can go into labor anytime now.

The session list looks great! Congratulations and thanks to Baron, Sheeri, Ronald, all the sponsors and contributors for organizing the first OpenSQL Camp.

I will be watching PlanetMySQL closely for juicy blog posts. Hopefully, the one and only Sheeri is taking her camcorder!

Stack Overflow: Q&A Site


Today I discovered Stack Overflow, a collaborative site that focuses on technical Questions. You can ask questions related to any language, apparently without having to register. The site is currently in beta. There are also a few MySQL questions that are currently unanswered.

Scalability As A Functional Or Non Functional Requirement

I am currently tasked with writing Software Requirements Specification (SRS) document for a project. Effective sharding (based on specific criterion) and Scalability are key requirements of the project.

Scalability is traditionally classified as a non-functional requirement. My question to the community is that if scalability is crucial to a project, would it still be classified as a non-functional requirement? Are their cases when scalability requirements would be best classified as functional requirements?

Open Source Pony Tail

Sorry for not updating this blog regularly. My wife's due date is soon so I've busy.

Anyway, I wanted to share this very funny interview with Jonathan Schwartz (puppet):

How to connect VB 2008 application to Database that is online?

Hey,
I need all the users off my application to be able to connect the same database. I was wondering if I could put the database on net and have my program connect to it whenever my users are connected to internet then they could make the desired changes to it. Anyone knows if this is possible? And, if it is, How?

Much easier to write a little php page that they contact to interact with the database (with proper security precautions, of course). Otherwise you open the database to the world and it’s subject to attack.

Relational Database Management System in Sap

Basically SAP, an enterprise application is made up of programs together with the data used and formed by programs. The data are organized in a meaningful way within the database, making it easy for the programs to access and find the data necessary to do something useful like run a financial report or create a sales order. Both the programs as well as data exist in the same database in the case of an SAP component or products such as ECC. Normally each and every component has its own database a production system landscape composed of SAP ECC, SAP Business Warehouse (BW), and SAP Customer Relationship Management (CRM) consists of three production databases.

Database Structure:

Essentially database is an electronic filing system that houses a collection of information organized in such a way that allows a computer program to find preferred pieces of data in a rapid way. A database is composed of tables, columns (called fields), and rows (called records or data). The fundamental structure of a database is same as the Microsoft Excel spreadsheet wherein columns (fields) store row after row of records (data). The difference between a database and a spreadsheet is simply the databases that contain multiple tables are connected to one another through relationships.

Database structure is an alternative technical term that does not need to concern with you, but are important nonetheless. Structures are triggered and are very well defined in the ABAP/4 Data Dictionary and have only temporary data. The database plays a key role in each SAP system, as it houses all the data that are used by that SAP component or product specifically. Numerous brands of databases exist, making it easier for an IT shop to opt for a database vendor with which they are almost well-known. Moreover, it is imperative to note that not all database vendors and versions are supported by SAP. Rather it tends to stick with the market leaders, over the years adding and removing support for certain vendors.

Primary Key

Database tables in an RDBMS are obligatory to hold a unique field that distinguishes one particular record separately from others found in the database. This unique field is called a primary key and is composed of one or more fields that make each and every record in a database as a unique one.

Foreign Key

Use the primary key field in one table for linking it with another. The common link field in the other table is usually not the primary key in the other table: and is known as a foreign key.

Database Concepts:

The SAP system contains lots of types of constructs along with structures inside the R/3 Data Dictionary (DDIC). The majority of these constructs tend to be very technical.

Transparent Tables

SAP uses another concept called transparent tables, which are SAP database tables that contain only data at runtime. When a table is activated in the ABAP/4 Data Dictionary, a transparent table is created automatically in the database. This transparent table encloses the same name as your database table contained in the ABAP/4 Dictionary. Each of its fields contains the same names as their database counterparts though the sequence of the fields might get varied. This unstable field sequence makes it possible to insert new fields into the table without having to convert it, all of which pays a way for more rapid access to data during runtime.

Startup Scalability Strategies @ Startonomics

Tomorrow morning I am presenting a session, Startup Scalability Strategies, at Startonomics, a conference being organized by Dave McClure and Deal Maker Media. The sessions will be streamed live using UStream. Check the Startonomics website at http://startonomics.com for more details.

Also check out my guest blog post titled How Important Is Scalability written for Startonomics blog.

Original Music Database - (No Cover Songs)

SUBSCRIBE to be eligible for FEATURES in my VLogs, the Audio Prophecy Show and my Live Internet Radio Show. Info can be found on my channel.

This is an original music database to give exposure to the original musicians here on YouTube. Post your original music as video responses and join the database.

Featured artists will be announced by bulletin.
Also, check out my new YT Show, “Audio Prophecy” that has been inspired by the OMDB. You can find it on my channel. We showcase musicians, have artist interviews, discuss current YT original music news and events, etc.

*** Genre Groups ***
There’s been an overwhelming request to categorize the original music videos so I have created groups for different genres. Aswell as posting your video response to this video, artists can join these groups and add your videos. Each genre may include Acoustic, Electric ,Orchestral, A Cappella, etc.
New groups will be added upon request.

ROCK
http://www.youtube.com/group/OMDBrock
HIP-HOP and SOUL
http://www.youtube.com/group/OMDBhiphop
Rhythm & Blues
http://www.youtube.com/group/OMDBrb
Classic Blues
http://www.youtube.com/group/OMDBblues
Jazz
http://www.youtube.com/group/OMDBjazz
Pop
http://www.youtube.com/group/OMDBpop
Folk & Traditional
http://www.youtube.com/group/OMDBfolk
Country and Country Rock
http://www.youtube.com/group/OMDBcountry
Electronic
http://www.youtube.com/group/OMDBelec
Ambient
http://www.youtube.com/group/OMDBambient
Cultural
http://www.youtube.com/group/OMDBCultural
Religious - Christian
http://www.youtube.com/group/OMDBChristian
Religious - All
http://www.youtube.com/group/OMDBreligious
Classical
http://www.youtube.com/group/OMDBclassical
Punk Music
http://www.youtube.com/group/OMDBpunk
Gothic Music
http://www.youtube.com/group/OMDBgothic
Musical Comedy
http://www.youtube.com/group/OMDBcomedy
Music for Children and Families
http://www.youtube.com/group/OMDBchild
Music in French
http://www.youtube.com/group/OMDBfrench
Latin Music
http://www.youtube.com/group/OMDBlatin
Ideas In Development, Riffs & Collaberation Sharing
http://www.youtube.com/group/OMDBdev

***General Info***
-You may post as much original music as you want
-Help notify me of spam videos if I miss them
-Comment, Rate and Subscribe to other original artists you enjoy
-Send Friend Invites to other original artist to better spead word and popularity of our efforts. (Please no spamming with bulletins or video sharing)
-Enable your bulletins window on your profiles to better advertise us all. (to disable email notifications for bulletins, goto “My Account” , “Email Options” and disable bulletin email notification.
-Please no hateful comments between artists
-Spread the word

Intro/outro music by Modern Oracle (Copyright 2007)

Duration : 0:1:18

Continue Reading…

Technorati Tags: , , , , , , , , ,