On this article, we will show you several tips to prepare and to plan data aware application with SQL Server 2014. The tips should be considered if you want to make your application evolve with the database technology as well as technology trend like a cloud. Tips 1 – Avoid Create a SQL Login Directly as the user It is not a good idea to create an user that has direct access to sql server. It w...
[More]
Background Upgrading is easy when we talk about one level upgrade. For example, upgrading from 2012 R2 to 2014 will be seemless. However if you upgrade from SQL Server 2000 to SQL Server 2014, you will need some tips to make the database run smoothly. This article will guide you to do step-by-step approaches. Patching your SQL Server 2000 to the latest service pack (i.e. SP4( Backup your...
[More]
Problem As an Admin, you want your life easier by creating automatic task on your database server. However, you don’t have a good best practices how to create a good maintenance Solution Preparation Phase In order to create a better maintenance plan you should have at least Two hard disk, the first hard disk is for transactional and the second hard disk work as a backup. Having one har...
[More]