First time certification will be your first good or worst experience, but if you want differentiate yourself with the other. Certification will give you better understanding, better skill, and better insight about the technical competency. This tips will give you a non-technical tips about how to prepare your first innteranational certification. Tips 1. Find and understand your certification comp...
[More]
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]
If you have ever need to learn project management deeply by understanding every fundamental aspect. This article will cover you what need to be learnt for project management. Project management that I said is pragmatic project management. this learning guide is not ittended for PMI certification but might be usefull for your quick and daily activity when you managing the project. Before we start w...
[More]
As Microsoft Certified Trainer, we delivered a training through a virtualization and most of it you will use hyper-V as a standard of virtualization technology. However, many labs on MOC (Microsoft Official Curriculum) uses Level 7 Hardware. It means you will need at least 8 GB Memory, and 1000 TB hard disk with 7200 RPM. Unfortunately, although you will have the hardware, the client will have sam...
[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]
Background This article will cover how to prepare a project with Visual Studio Online and Agile method. This article assumes that you already have Visual Studio Online account. If you don’t have one, just create at http://visualstudio.com. Creating a project and version control On your visual studio online account, create a new project You can full a project information like the ...
[More]
Problem You sync your one drive with your PC and you get an error that tell there is a sync problem, but after you click the detail it is said the all files are up to date Causes This is because some temp files can’t be synced to your OneDrive and make a few conflict with your sync status Solution Open your OneDrive Application Find a folder that has an issue. it is symbolized by the c...
[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]