Tag: sql server
-
Get Help from Github Copilot on Your SQL Server
Having trouble with your database server in production workload? or you need to optimize query? GitHub Copilot is now available inside SQL Server Management Studio, bringing AI‑powered assistance directly into your SQL workflow. For…
-
Getting Started with SQL Server BI Platform
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…
-
Azure Data Fundamental
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…
-
Migrating Your SQL Server Database into Lower Version
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…
Tagged sql server -
Beginner Tutorial for ASP.NET MVC
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…
-
5 Simple Tips to secure SQL Server 2014
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,…
-
Tips for Building Data Aware Application with SQL Server 2014
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…
Tagged sql server -
Upgrading Your Database into SQL Server 2014
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,…
Tagged sql server -
Building Maintenance Plan on SQL Server 2014
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…
Tagged sql server -
Unable to Add Data Connection on Visual Studio 2013 after SQL Server 2014 Upgrade
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…