|
|
|
|
|
Login to share your opinion Wall4PHP Mobile FrameworkWall4PHP is one of the framework that I recommend to mobile web application developer for the number of useful information that you may find inside… read more How To Be A ProSQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 o…Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all… read more MySql insert into statementMySQL INSERT INTO statement is used to insert record(s) or row(s) into a table. read more 6 CSS3 and jQuery Loading Animations SolutionsThe largest resource of CSS3 and jQuery Loading animations is now in your hands. You will be surprised to see the amazing animated series as… read more How to connect to SQL Server when your default database is unavailableI was restoring a TB+ sized database on our staging database today. Someone needed to use a different database but he couldn't login because the… read more MySQL - Deletion History Tables - Part 1MySQL stored procedure’s come in really handy at times. I like to let the database do the work for me sometimes. read more Store Multiple Values for a Key using Apache Collectionsn common programming we use maps to store key and value pair. They have one-to-one relationship.But, sometimes we need to use one-to-many relationship in order… read more Database Tuning overview – Access Path TuningPart of the Performance Tuning series – Performance Stack , this section looks at Access Path Tuning. How does the user access the data and… read more SQL Jobs on a Mirrored EnvironmentOne of the little challenges a DBA has to deal with when setting up SQL Server mirroring is handling of SQL Server jobs. SQL Server… read more Martin Fowler working on NoSQL DistilledOver the last few months[1] I've been helping my colleague Pramod Sadalage work on a book on NoSQL technologies to be titled NoSQL Distilled. (You… read more Should we use Singular or Plural Database Table NamesWell, I have been in a dilemma about this for a while. After reading several posts on Singular vs Plural Database table names, I finally… read more Data Structure for Social News Streams on Graph DatabasesI was on vaccation and then on summer school and I worked on my first scientific poster and on a talk which will hopefully ontribute… read more SQL Bulk copy method to insert large amount of data to the sql databaseI was recently tasked with a project at a company to update an SQL Server 2008 database with large amounts of data each day. The… read more Working with MySQL EventsMySQL events (also known as temporal triggers) were added in MySQL 5.1.6 and offer an alternative to scheduled tasks and cron jobs for database activities.… read more Optimizing Core Data SavesI recently transitioned from keeping data models in memory to persisting them to disc using Core Data. There are a lot of good reasons to… read more Load balancing for PHP and MySQLA single MySQL server is a single point of failure. A single MySQL server can only be scaled vertically by increasing hardware size, which has… read more Generate AlphaNumeric Identity Column in SQL ServerLet us suppose you have a requirement where you want to have an alphanumeric identity column that has characters and numbers and you want these… read more Get Count of Tables From MySQL DatabaseNow a days I have work for one application in which I have to create and drop tables dynamically and based on these new tables… read more Handling File Data with PHP - PHPReading from a File PHP offers numerous methods for reading data from a file, ranging from reading in just one character at a time to… read more |