Category: SQL Server

SQL Server

How To Import Or Restore BACPAC File Using SQL Server Management Studio?

Introduction  Backup package (BACPAC) contains schema and data for SQL Server database. We can export the database into BACPAC and import it in new environment as a new database. This can be used as per our convenience to migrate data from one environment to another or one SQL Version to another. This restore option has become best choice for Database Administrator and developer for migration … Continue reading How To Import Or Restore BACPAC File Using SQL Server Management Studio?

Satya Karki1 Comment
SQL Server

What are the Options for Database Backup and Restore? How to Export BACPAC using SSMS?

Background  Developers use one database to develop the solution and then need to create another environment such as Testing and Production. Once everything is ready in a development environment, we need to deploy it for a testing or staging environment. To deploy the application from one environment to another, we need to create a database or deploy a database too. We may need the same … Continue reading What are the Options for Database Backup and Restore? How to Export BACPAC using SSMS?

Satya Karki1 Comment
Feature, Power Bi, Power Platform, SQL Server, SQL Server Reporting Services

How to Configure Power BI Report Server

Introduction Many organizations are reluctant to go to cloud environment due to various reasons such as data privacy, security, compliance or data-sovereignty and data sensitivity. Power BI Report Server is best option for those who has compliance issue to keep their data in the cloud or Power BI online and want to use Power BI reports for reporting, business intelligence and data analysis. In previous … Continue reading How to Configure Power BI Report Server

Satya KarkiLeave a comment
SQL Server, SQL Server Reporting Services

How to Register Report Server from SQL Server Management Studio

Introduction SQL Server Reporting Services (SSRS) is a part of a suite of Microsoft SQL Server services. This article explains hot to handle connection issue in SSRS. By default, when we setup report server configuration manager it registers the Report Server but sometimes it may fail, and we need to register it manually. So, in this write up I will explain how we can handle this registration … Continue reading How to Register Report Server from SQL Server Management Studio

Satya KarkiLeave a comment
Feature, SQL Server

How to Link a SQL Server to an Oracle Database

There can be plethora of scenarios that we need to connect to different databases, get data into MS SQL Server and update data in remote Server . SQL Server has linked server feature through which we can link to other database servers. In this article, I will explain what is Linked server, advantages of Linked servers and how we can link Microsoft SQL database to … Continue reading How to Link a SQL Server to an Oracle Database

Satya KarkiLeave a comment
.NET Core, ASP.NET, ASP.NET .NET Framework, ASP.NET Core, CodeProject, SQL Server

How to Compare Two Databases, find differences and update using Visual Studio

In this article, we are going to learn how to compare two databases using SQL Server Database Project (Template) available in Visual Studio. I will cover the following points: Introduction of SQL Server Database Project. Connect two databases: source and target. Compare and identify differences among the two databases. Update or generate script to update the target database.  In the last article, we learned how … Continue reading How to Compare Two Databases, find differences and update using Visual Studio

Md Rijwan AnsariLeave a comment
CodeProject, SQL Server

Replace a string in SQL server Table Column

Sometimes, we might have requirement of updating or replacing particular string in sql table column. Let me be more specific, we had a application where we were storing the location of file in sql table “AppFile” in column “fileUrl”. We were uploading the file into another DMS (SharePoint Library) and storing the file view url into our table from where user can view the uplad … Continue reading Replace a string in SQL server Table Column

Md Rijwan Ansari1 Comment
SQL Server

MSSQL View, Change in Underlying Table and Impact in .NET Application

Problem Background Our .NET application was working fine, we got same change request and feature addition in the application. We change our code and added new features according to new requirement. We went through all Software development life cycles and deployed in staging server of client. However, our test team miss some area to check properly as we were in urgent delivery of that project. … Continue reading MSSQL View, Change in Underlying Table and Impact in .NET Application

Satya KarkiLeave a comment
SQL Server, SQL Server Reporting Services, SSRS

Deployment of RDL Report File in SQL Report Server

This article explains how to upload or publish rdl file in SSRS report Server. This article will describe two methods to deploy report in SSRS Report Server. 1. By Simply Upload RDL file in Report Server. Open SSRS Server from webportal url. Then, there you will see upload button. Click upload option and browse rdl file of report from the location. It uploads your report … Continue reading Deployment of RDL Report File in SQL Report Server

Satya KarkiLeave a comment
SQL Server, SQL Server Reporting Services

SQL Server Reporting Services(SSRS) | An Introduction

Introduction: This article introduces what is SQL Server Reporting Services and how does it works in brief. An Introduction to SSRS SQL Server Reporting Services (SSRS) is a server-based report generating software system provided by Microsoft. It is a part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). SSRS allows to provide decision making information to end … Continue reading SQL Server Reporting Services(SSRS) | An Introduction

Satya Karki1 Comment