tag:blogger.com,1999:blog-55130655149152979392024-03-24T13:03:44.359+06:00Mominul's Blogwhile(!(succeed=try()));Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.comBlogger271125tag:blogger.com,1999:blog-5513065514915297939.post-23438587180443814912024-03-24T13:01:00.001+06:002024-03-24T13:03:11.590+06:00Power BI: Load, Clean and Transform DataLet’s take a look at how to import, clean and transform data in order to improve data quality using Power BI Desktop.The first step is to get data. Microsoft Power BI Desktop allows importing data from various data sources like Excel, Text/CSV, PDF, XML, JSON, Oracle Database, SAP Database and many more.Here on the Ribbon pane, select Get Data, click on More (using Store.csv file for this exampleMominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-11507733016791537772024-03-21T14:12:00.000+06:002024-03-21T14:12:35.317+06:00Log Shipping in SQL Server Log Shipping in SQL ServerLog Shipping is a process of copying the transaction log back up from a primary server to a secondary server and restoring it to the secondary server.The purpose of implementing Log Shipping is to maintain two SQL Server databases synchronized in separate locations for high availability.Log Shipping operationsLog Shipping consists of the following three operations:Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-49708216889300563092024-03-14T15:45:00.003+06:002024-03-14T15:45:53.202+06:00Configuring a SQL Server AlwaysOn High Availability Group In this article, we will learn the step by step configuration of SQL Server AlwaysOn High availability Group for two nodes. Once nodes are added to the cluster group, we will able to use the AlwaysOn feature in the SQL server.In the following steps, we will create a Service account to connect SQL server instances. The Service account will be used to connect the SQL instance from both the Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-67527623012414749822024-03-14T11:19:00.007+06:002024-03-14T11:20:32.047+06:00Overview of SQL Server Security -Part-01 Overview of SQL Server Security : Part-01Relational databases are used in an amazing variety of applications with connections from a dizzying array of clients over widely distributed networks, particularly the Internet, which makes data accessible to almost anyone, anywhere. Databases can hold a significant portion of human knowledge, including highly sensitive personal information and Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-8646317921178414552024-03-13T14:25:00.003+06:002024-03-13T14:25:59.933+06:00Database Normalization in SQL with Examples Database NormalizationDatabase Normalization is a set of rules that are applied to a database, such that the schema of the database ensures that all the rules are being followed. These rules are also known as Normal Forms and are widely used while designing database solutions.The database normalization process can be divided into following types:First Normal Form (1NF)Second Normal Form (Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-91891782337686820732024-03-10T16:42:00.005+06:002024-03-10T16:42:48.510+06:00Database table partitioning in SQL Server What is a database table partitioning?Partitioning is the database process where very large tables are divided into multiple smaller parts. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. The main of goal of partitioning is to aid in maintenance of large tables and to reduce the Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-57223755830415643872024-03-06T16:13:00.005+06:002024-03-06T16:13:53.239+06:00How to create and configure a linked server in SQL Server Management Studio Linked servers allow submitting a T-SQL statement on a SQL Server instance, which returns data from other SQL Server instances. A linked server allows joining data from several SQL Server instances using a single T-SQL statement when data exists on multiple databases on different SQL instances. By using a linked server to retrieve data from several SQL instances, the only Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-66313411052229516102024-03-06T15:37:00.001+06:002024-03-06T15:37:29.167+06:00Configuring Always-On High Availability Groups on SQL Server In this article, we’ll walk you through a step-by-step guide on how to install and configure Always On Availability Groups on SQL Server running on Windows Server 2019, discuss failover scenarios, and some other related topics.Always On Availability Groups provide high availability in MIcrosoft SQL Server. Always On appeared in MSSQL 2012 release.Features of Always On Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-34626953395328458952024-03-06T15:33:00.000+06:002024-03-06T15:33:04.246+06:00MS SQL Server 2019 Enterprise Edition Installation Guide In this article we will describe step-by-step Microsoft SQL Server 2019 installation and tell about all options, components, relevant recommendations and best practices.MS SQL Server is a leading relational database management system and the main competitor of Oracle Database in the corporate segment.MS SQL Server 2019 EditionsThere are 5 MSSQL 2019 editions:Express is a free edition. Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-19744630699336238372024-03-06T13:30:00.003+06:002024-03-06T13:35:50.402+06:00Configure Named Pipe And TCP/IP Settings Of SQL Server In this article, we are going to configure Microsoft SQL Server on a Windows machine to listen to a specific TCP port. We will enable TCP/IP and Named Pipe and configure firewall rules so that other network computers can communicate with SQL Server instances.Pre-requisitesMicrosoft SQL Server installed on the machine (please check my article to install SQL Server here).Configure Named Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-57301681103830164882024-03-06T13:25:00.003+06:002024-03-06T15:31:17.515+06:00Step By Step Installation Of Microsoft SQL Server(Developer Version) On Windows System IntroductionIn this article, we are going to install Microsoft SQL Server on windows machines step by step. In this tutorial, we are going to use SQL Server 2019 Developer edition and Windows Server 2019.Pre-requisitesWindows machine having 2 core and 4 GB RAM configurationDownload SQL Server 2019 Developer EditionFirst, let’s download SQL Server installation media from the official Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-34373640887973997832024-02-28T12:15:00.001+06:002024-02-28T12:22:12.712+06:00Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-6) Part-51.
Question 1
For the sales department of your
organization, you publish a report that imports data from Microsoft Excel
located in a Microsoft SharePoint folder. The data model contains several DAX
measures. You must create a Power BI report from the existing data with minimal
development efforts. Which type of data source should you use?
1 / 1 point
A Power BI Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-14963291765214821862024-02-28T12:13:00.002+06:002024-02-28T12:23:05.344+06:00Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-5) Part-41.
Question 1
Multiple Microsoft Excel files
are saved in a folder and synced with Microsoft’s OneDrive for Business. You
need to import data from files without using the data gateway. Which type of
Power BI data connector should you use?
1 / 1 point
SharePoint folder
Excel workbook
SharePoint list
OneDrive for business
Correct
That’s correct! A Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-50300408956977904382024-02-28T12:11:00.002+06:002024-02-28T12:23:50.674+06:00Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-4) Part-31.You are planning to get data from flat files for your company. The
company wants a scheduled refresh for the dataset by using Microsoft 365
credentials. Which two of the following locations should you recommend? Select
all that apply.
1 / 1 point
OneDrive for business
Correct
That’s correct! OneDrive account provides the ability to automatically
synchronize flatMominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-65794574622573823362024-02-28T12:09:00.001+06:002024-02-28T12:24:43.385+06:00Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-3) Part-21.
Question
1
For the sales department of your organization, you publish a report that
imports data from Microsoft Excel located in a Microsoft SharePoint folder. The
data model contains several DAX measures. You must create a Power BI report
from the existing data with minimal development efforts. Which type of data
source should you use?
1 / 1 point
An Excel Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-58860420240160094842024-02-28T12:05:00.006+06:002024-02-28T12:28:08.272+06:00Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-2) Part-11.
Question
1
Multiple Microsoft Excel files are saved in a folder and synced with
Microsoft’s OneDrive for Business. You need to import data from files without
using the data gateway. Which type of Power BI data connector should you use?
1 / 1 point
Excel workbook
OneDrive for business
SharePoint folder
SharePoint list
Correct
That’s correct! A Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-23273394639431328322024-02-28T11:57:00.001+06:002024-02-28T12:16:53.439+06:00Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-1) 1.Question 1For the sales department of your organization, you publish a report that imports data from Microsoft Excel located in a Microsoft SharePoint folder. The data model contains several DAX measures. You must create a Power BI report from the existing data with minimal development efforts. Which type of data source should you use?1 / 1 pointAn Excel Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-78882949413910795992024-02-04T13:51:00.002+06:002024-02-04T13:51:21.524+06:00PowerBI Embedded Report Integration with Web Application in ASP.NET Core using Azure Service Principal Method(Part-2) Assalamulaikum,This is the continuation of this post where I discussed about cloud configuration of Embedding report. Today I will discuss about programming part for asp.net core:Configuring ASP.NET Core applicationApplication must know few settings to show report from Power BI. Add the following JSON to your appsettings.json file and fill in appropriate values."PowerBI": { Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-32211226881791042152024-01-29T16:28:00.005+06:002024-01-29T16:28:38.743+06:00Send Emails with Attachments in SQL Server (T-SQL) SQL Server provides us with the ability to send email via its Database Mail solution. This includes a bunch of stored procedures that facilitate the configuration and sending of emails.To send an email, use the sp_send_dbmail stored procedure. This procedure accepts a bunch of optional arguments, one of which allows you to send attachments.Actually, there are two Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-91419674785855731202024-01-21T13:52:00.002+06:002024-01-21T13:52:25.046+06:00PowerBI Embedded Report Integration with Web Application in ASP.NET Core using Azure Service Principal Method(Part-1) Assalamulaikum!To get benefits of report sharing with multiple ERP users from single power premium user of PowerBI service we can consume PowerBI Embedded Report integration.In Power BI Embedded, Microsoft offers two main solutions: 1. Embed for your Customers, also known as App Owns Data2. Embed for your Organization, also known as User Owns Data Embed For Your Customers/ App Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-63730426284190090112024-01-11T10:54:00.000+06:002024-01-11T10:54:44.094+06:00Data Movement Automation via PowerShell Script: Part-2After writing 1st Article which was related to data movement on FTP server from Drive , Today I will write about Data Movement from Drive to Drive with different conditions using PowerShell Script :1. Copy Files by checking duplicity on certain time: To copy files from a specific path that were modified 2 days ago, while checking for duplicate files in the destination Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-42750985395256676082023-12-31T11:04:00.003+06:002023-12-31T11:29:14.595+06:00Data Movement Automation via PowerShell Script: Part-1 PowerShell is a task automation and configuration management framework developed by Microsoft. It is a scripting language and an interactive command-line shell designed to simplify system management tasks.PowerShell is used extensively in various IT domains, including system administration, network configuration, and cyber security. Its benefits include automation, simplified scripting, andMominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-71149344069926643202023-05-24T14:43:00.000+06:002023-05-24T14:43:04.169+06:00How to Send EMail using SQL Express Edition Step#01 msdb.dbo.sysmail_add_profile_spThis stored procedure adds a database mail profile in SQL Server. Following is the syntax of the stored procedure:123Execute sysmail_add_profile_sp @profile_name = 'DBMailprofile_name' , @description = 'description'It uses two input parameters:@Profile_name: The value of this Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com1tag:blogger.com,1999:blog-5513065514915297939.post-83655140698754482632022-05-23T11:43:00.002+06:002022-05-23T11:43:57.785+06:00Python- How to Install a Package in Python using PIPSteps to Install a Package in Python using PIP(1) First, type Command Prompt in the Windows search box(2) Next, open the Command Prompt, and you’ll see the following screen with your user name (to avoid any permission issues, you may consider to run the Command Prompt as an administrator):C:\Users\Ron>(3) In the Command Prompt, type “cd\” as this command will ensure that your Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0tag:blogger.com,1999:blog-5513065514915297939.post-90161031580380292212022-03-27T13:23:00.001+06:002022-04-13T14:25:08.748+06:00Tutorial for Microsoft Certification on Data Engineering DP-203 Microsoft DP-203 Exam DetailsMicrosoft DP-203 Exam Course OutlineMicrosoft provides a course outline for the DP-203 exam that covers the major sections for getting better understanding during the preparation time. The topics are:Topic 1: Design and Implement Data StorageDesign a data storage structuredesign an Azure Data Lake solution (Microsoft Documentation: Azure Data Lake Storage Mominulhttp://www.blogger.com/profile/18432371745825941328noreply@blogger.com0