SQL Server Stored Procedures Explained by Satish Kartan

Stored Procedures are SQL statements saved in a database as an object. They can be called interactively through the Query Analyzer, and by other stored procedures. They can be defined with parameters to make them more flexible, and can return result sets and status codes.   Their advantages include: The ability to restrict access to…

SQLite Database Recovery – Reasons for Corrupt SQLite Database

SQLite is a popular relational database management system excessively used in these days. But unlike other database management systems, it’s not a client-server database engine. In fact, it’s embedded into the end program. SQLite is widely supported by various browsers, operating systems, embedded systems and many other applications. If you want an open-source and embedded…

SQL Server Indexes Explained by Satish Kartan

A database index is similar to an index in a book – it is comprised of a lookup value, and a number identifier that corresponds to the row number in a table. In SQL Server, there are two kinds of indexes – clustered and non-clustered. Clustered Indexes require that the data in the table is…

DBHawk’s SQL Job Scheduler by Satish Kartan

DBHawk has the solution that can make scheduling SQL batch jobs easier and more efficient. Using its SQL job scheduler, you can run the queries in batch mode and save the output results on your hard drive or have them delivered to you via email. DBHawk’s SQL job scheduler has a well-designed and intuitive user…

Difference of SQL, SQL*Plus and PL/SQL

There are a few products with the letters “SQL” in the title, and these three, SQL*Plus, SQL, and PL/SQL, are frequently utilized together. Along these it’s easy to become difficult as to which product is doing the work is being finished. This segment explained by Satish Kartan quickly portrays each of these three products.  …

Microsoft SQL Database Hosting

Microsoft SQL Database Hosting is reference to the hosting services that are idyllic and most swell suited for ecommerce websites and business websites requiring high profile databases and storage solutions. The SQL Server Hosting is known for its agility and other virtues such as reliability, security and easy usage. It is one of the most…

The Foundations of Structured Query Language

Structured Query Language (SQL) is a declarative form of a query language used to perform data manipulation tasks such as Select, Insert, Update and Delete.   The foundations of SQL are based on Relational Algebra. There are Select, Project, Join, Thetha join, difference and union. Relational Algebra is itself based on the foundations of set…

SQL Strategies for Restricting Even Numbers in The Prime Lotto System

The Prime Lotto system restricts possible lotto combinations with a simple probability based model. The rules are loosely implemented to include in each 6 ball line:   2 primes 1 non prime odd 3 even numbers   Prime numbers are a good way to restrict numbers using a set based approach. We know that over…

Converting an Access Database to SQL Server

Microsoft’s Access Database is extremely popular and is adequate for most company applications. But Microsoft’s Access is meant for small projects with few users. As frequently happens, a small Access application grows and slowly becomes the heart and soul of a company administration system.   As volumes and the number of users increase, the limitations…

Successful SQL Server Monitoring – Security Is a Priority

Server monitoring is important to maintain privacy and secrecy of company’s records. As a huge amount of crucial data is stored in the server, so it is not a choice but a compulsion for an IT entrepreneur to install a server monitoring program to prevent his sensitive data from being discovered by the prying eyes.…