Skip to content

Category Archives: Databases

Getting Started with Microsoft Azure SQL Database

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. […]

Continue Reading: Getting Started with Microsoft Azure SQL Database →
Dynamic Search Without Using Dynamic SQL

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 […]

Continue Reading: Dynamic Search Without Using Dynamic SQL →
SQL Server Pivot – A Simple and Practical Example

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 […]

Continue Reading: SQL Server Pivot – A Simple and Practical Example →
Top 11 Tips for Database Performance Optimization

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 […]

Continue Reading: Top 11 Tips for Database Performance Optimization →
How to Rectify Mal-formatted Records in a Database Table?

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 […]

Continue Reading: How to Rectify Mal-formatted Records in a Database Table? →
Database Modeling with Real Requirement – Part 2

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 […]

Continue Reading: Database Modeling with Real Requirement – Part 2 →
Database Modeling with Real Requirement and Scenario

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 […]

Continue Reading: Database Modeling with Real Requirement and Scenario →
Error Handling in SQL Server: Best Practices

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 […]

Continue Reading: Error Handling in SQL Server: Best Practices →
How to Design Database to Handle Alternate City Names?

There are scenarios in many software projects where you need to handle alternate city names (city alias) entered by users. These scenario may occur when a user enters a destination while finding Hotel or Flights (or may be in any other similar cases). A travel domain portal like Expedia is a good example where a […]

Continue Reading: How to Design Database to Handle Alternate City Names? →
How to Architect a Multi-tenant Database?

What is a Multi-tenant Database? SaaS is in fashion now and developers working on SaaS applications and related skill sets are much in demand. You may be aware that one of the five essential attributes of a SaaS is multi-tenancy. Your SaaS must be multi-tenant to reduce maintenance and support cost and in turn make […]

Continue Reading: How to Architect a Multi-tenant Database? →