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
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
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
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
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
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
The Microsoft.AspNetCore.Session package provides middleware for managing session state. Add the following heightened line in your Startup.cs Following line of code is needed to set the session value. To get the session value Continue reading How to set and get the session value in asp.net core.