If you have SQL Server database for a long time and you have database on the cloud also like SQL Azure or SQL Server RDS. You might want to understand how the data can help define, redefine, or build your business. Data driven decision or DDD for short is a way to make a business justification based on the data. DDD can be applied by using Business Intelligence platform such as SQL Server and Micr...
[More]
The Fun Fact about the data
When we build anything, we use data. Start from structured data, unstructured data, and semi-structured data we store the data to retrieve it as information and knowledge. Despite of the data usage, we know that the data in our life is growing. And when we can't store the data in the local storage the cloud is the answer. The question is how we store and manage the dat...
[More]
Problem
You have an old database (i.e. SQL Server 2012) from the production. After that, you restore it into SQL Server 2016. After your work, you restore it into your production server to SQL Server 2012. Your restore fail.
medianet_width = "600";
medianet_height = "250";
medianet_crid = "858385152";
medianet_versionId = "3111299";
...
[More]
As a part, of our commitment to create a local video tutorial on Visual Studio Technology. We created a beginner tutorial for ASP.NET MVC with Visual Studio 2015. There are 8 videos on the plan. You can visit YouTube to join the Visual Studio Indonesia YouTube Page. Or enjoying the video below
Building an aplication that use SQL Server means that we give the SQL Server an authority to store and manage the data. In order to make sure that the data always available and secure, we need to take care the configuration that will help the development team to make sure the system and secure and available. Let’s start the tips Tips 1. Physical Security Put the server on a room with sufficien...
[More]
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]
Problem You uninstall SQL Server 2012 and install a new SQL Server 2014 for your development machine. However after the installation of SQL Server 2014 you get an error like below Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0 And you can’t add the data connection on Visual Studio 2013 Cause This is because you remove the entire installation of SQL...
[More]
Problem
You want to move your Windows Azure solution Web Site from your subscriptions to the others
Solution
Solution A. Make Sure it has same service administrator
If you have a same service administrator email between your source subscription and the target subscription, you just contact the support to move the web for you. For example, my subscription A used my
[email protected] and my target subs...
[More]