Category: Databases
Benny
November 25, 2020
Content Management Systems, Databases, JavaScript, Macronimous, Opensource, PHP Programming, web programming, Web standards, Web tools, Welcome
Web development, in general, refers to the tasks associated with developing websites for hosting via intranet or internet. It encompasses all the operations required to plan design, build, host, …
MySQL has long been the preferred open source database software solution. However, with newer options coming into the market, it is only natural to be intrigued by what …
As developers, we know the importance of full stack of development technology putting our lives at ease. While LAMP stack started this trend many years back, we now see …
Using client apps for MySQL provides more than just a well-presented representation of your database. It elevates the level of accuracy and time saved by database administrators. And every …
With the rapid emergence of technological innovations, there has been a dramatic rise in the demand for high-end technological solutions for web application development. Traditional technologies have taken a …
The new-age digital economy revolves around three key disruptive forces – Web, mobile, and Internet of Things (IoT). A new set of tools and technology is now needed to …
Have you thought about the right Data type which you should use? Is VARCHAR bad? Do you review the SQL statements that you have written? Do you know what …
Index on multiple columns for SQL performance Since clustered index records the table and arranges the data according to the index key, SQL Server allows only one clustered index …
1) Increase SQL Server stored procedure performance with following three tips: Stored procedures play a vital role in enhancing the performance of the database. The following three tips will …
The Problem with all the codes is that the value is not sanitized before it will be sent as a query. All we need to make sure is that …