SQL Archives | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure

Tag Archives: SQL

Making SQL Server Accessible Over Internet

We can Make the SQL Server Accessible over Internet by following steps: 1. System should have static IP where SQL server is installed. 2. Open SSMS, right click on server > properties and check SQL Server and Windows Authentication mode 3. Go to Server > Security > Logins and configure password for users, who will be accessing the … Continue reading Making SQL Server Accessible Over Internet

How to create Tabular Model Project

In this blog, we will learn how to create blank Tabular model project. Pre-requisite: Visual Studio with Business Intelligence template. Data source to import data into Tabular model (in our case we are using SQL Server). Analysis Server to deploy Tabular model.   Go to Visual Studio, and create new project, go to Templates > … Continue reading How to create Tabular Model Project

Creating Document Map in SSRS

Document Map makes navigation is easy to navigate through table in SSRS In our case we have dataset which contains Product and Product Subcategory. We created the 2 parent groups on Product key and Product Subcategory key. We have to go in the Parent group(ProductCategoryKey) >Advanced > Document Map and select the column used for … Continue reading Creating Document Map in SSRS

How to resolve error when attaching a database in SQL Server

Introduction: One of the common Errors while attaching a .mdf file for restoring Data is as follows: An error occurred when attaching the database(s).  Click the hyperlink in the Message column for details. The detailed message is as follows. Step 1: Right, Click on the .mdf that you want to attach and click on Properties. … Continue reading How to resolve error when attaching a database in SQL Server

Count Number of weekends between 2 dates in SSRS

Problem: There is no in-built function in SSRS where we can count the number of Saturdays and Sundays between any two dates in SSRS. This is a needed function for scenarios where we only need to get a count of working days.’ Solution: Following is a formula that can be used for getting an accurate … Continue reading Count Number of weekends between 2 dates in SSRS

SEARCH :

FOLLOW CLOUDFRONTS BLOG :

Agro-Tech Services Success Stories

Please fill your details to download the file.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close