If you’re learning SQL server then you’ll often stumble onto term called “normalization”. So in this article we’ll discuss what normalization is and what are the different types of normalization. [Read more...]
SQLite Administrator
If you’re using SQLite for your small apps then using GUI interface for database creation can be handy. There is no official GUI tool for manipulating SQLite database. There are some 3rd party gui tools for sqlite. Few tools are either discontinued or are still packaged with old version of sqlite. [Read more...]
Triggers in MS-SQL Server
Whenever database is modified then triggers are fired based on the event set. Two logical tables are created when triggers are fired.
[Read more...]
Using MS-SQL Server Express
Earlier I have written beginners guide on MS-SQL server. In this post i’ll cover few more things about ms-sql server which are intended towards beginners. If you are beginner then I suggest you to read this post first. [Read more...]