Category Archives: MS SQL

Objective of this article Sharing a brief of the 2 best options available in MS Azure for SQL Server deployment. Deployment via SQL Server Management Studio (SSMS, using SQL Server 2012) Accessing SQL Azure from SSMS and through browser. Prerequisites for this article MS Azure subscription. You can Sign-up for a free trial account here. […]

There can be some scenarios where you have to search a database using multiple criteria where you don’t know in advance as which criterion or the combination of criteria the end user would select. For example, consider the following scenario There’s a table which contains some basic information about employees, say it has the following […]

SQL Server Pivot was introduced in SQL Server 2005. It is a useful feature but it’s syntax and implementations sounds a bit complex. Let us try to understand this by a simple example. Problem Scenario You are working for software project for a client who has 5 stores located in say 5 different cities. Each […]

When it comes to optimize the performance of a Database you must do certain things in a standard way to get the desired results. Like any other field, the more you experience it, the more you learn. Here are my top 11 tips for Database developers at beginners and intermediate level. With minor or no […]

Executing an Update query on a production database is like driving full speed in opposite direction in a one-way traffic! You never know when your vehicle meets with an accident. A little carelessness in putting up the where clause can create havoc in your database. And an irreparable damage if you forgot to include the […]

My last article was about a database modeling scenario that is frequently encountered in software development. Theoretically that scenario is called one-to-many relationship. The current article is a sequel to the last article and seeks to model a different but a little complicated scenario that is encountered in most of the projects. It may not […]

Database modeling is one of the most challenging parts of a software development. It needs a significant amount of software development experience apart from domain expertise to design and model a database that is truly future proof – one which is flexible enough to accommodate the changing needs of a business. Above all it requires […]

For any application, data is the most valuable asset which must be organized and handled with due care. With the advent of advanced analytics it has become a thing of utmost importance to keep track of not only the successful transaction but also to track and log errors that crop up when a user tries […]