Tag: SQL Server

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
.NET Core, ASP.NET, ASP.NET .NET Framework, ASP.NET Core, SQL Server

How to Create SQL Server Database Project With Visual Studio

In this article, we are going to learn about SQL Server Database Project (Template) available in Visual Studio. I will cover the following points, Introduction of SQL Server Database Project. Create New SQL Server Database Project. Import database schema from an existing database, a .sql script file or a Data-tier application (.bacpac) the Project. Publish to create new Database in SQL server. The database plays … Continue reading How to Create SQL Server Database Project With Visual Studio

Md Rijwan Ansari67 Comments