<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by DEEPAK SINGH on Medium]]></title>
        <description><![CDATA[Stories by DEEPAK SINGH on Medium]]></description>
        <link>https://medium.com/@deepaksingh26071999?source=rss-330e5c33f7cf------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*7nsDMWU_j1aaDWqhXKgJvg.jpeg</url>
            <title>Stories by DEEPAK SINGH on Medium</title>
            <link>https://medium.com/@deepaksingh26071999?source=rss-330e5c33f7cf------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 22:35:35 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@deepaksingh26071999/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Integration Chatbots with Power Applications]]></title>
            <link>https://medium.com/@deepaksingh26071999/integration-chatbots-with-power-applications-64cbf7c6df7a?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/64cbf7c6df7a</guid>
            <category><![CDATA[chatbots]]></category>
            <category><![CDATA[integration]]></category>
            <category><![CDATA[model-driven-app]]></category>
            <category><![CDATA[canvas-app]]></category>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Wed, 27 Dec 2023 12:53:29 GMT</pubDate>
            <atom:updated>2023-12-27T12:53:29.392Z</atom:updated>
            <content:encoded><![CDATA[<p>Power Apps: Power Application is Platform as a service. It is a low code Platform which can help us to Create Application more Quickly. Power Apps is more power full because it has so many Features like 300+ Connectors, its Own Database (Dataverse), so many build in Templates. In Power Applications we can create 3 types of Applications 1)Canvas App 2)Model Driven App 3)Portal App</p><h3>Chatbots</h3><p>chatbots is a software application which can be used for simultaneous conversation with the human users, over the internets. chatbots use NLP (Natural Language Process) to understand the user input and response the output. chatbot can be deploy with websites, messaging Platform, Mobile Application and other platforms.</p><h3>Integrate chatbots with Canvas apps:</h3><p>So, if we want to use Chatbot in Our Canvas Apps there are few easy steps to integrates it.</p><ol><li>create a chatbot in Power Virtual Agent and Add topics that we want to use in Chatbots.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Gs7_y2L14CVXv_3QiaQozQ.png" /></figure><p>2. Now Publish the Chatbots.</p><p>3. Goto Setting on left menu and Click on “Channels” =&gt; “Custom Website”.</p><p>Custom Website can provide us the link so we can use that link in chatbots.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GSaylkEpjUQWb5veCnVNGQ.png" /></figure><p>4. Now we need to use this link in canvas applications.</p><p>5. open a canvas Blank Application and add new screen</p><p>6. Goto Setting and click Upcoming Features and search for “chatbots component” and make it enable</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1003/1*BPRyjmryYgPPHXMK9OgBXw.png" /></figure><p>7. In the new screen Goto Input and search for chatbots and drag that chatbots in Screen</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vMTZY23_t2H9MWEtgmLUUg.png" /></figure><p>8. for adding our publish chatbot in screen we need to go at Schema Name and Add select our chatbots</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EQKoCBtfqlmrEylMOZMzng.png" /></figure><p>9. For testing this chatbot we need to play this Application and try</p><p>10. Integration Done Successfully with canvas Apps</p><h3>Integration Chatbot with Model Driven Application:</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*q3uruc6sGiJyk1Z5O2GUfA.png" /></figure><ol><li>Create a Model driven Application and Add Some Dataverse table with the help of solution.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*q3uruc6sGiJyk1Z5O2GUfA.png" /></figure><p>2. So here I created a solution and added 2 Dataverse table</p><p>3.Now on the Header we have 3dots click and added to switch to classic</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wYTxbudXGnL5HTbQP4pdfw.png" /></figure><p>4. Power Apps Pop-up will open on the left hand select Web resource=&gt;New</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fO5U6gGY9SrgPtPzUE1m3w.png" /></figure><p>5. New Web Resource will be open in Name column “we will provide a Name”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vCnWM6mR1dbwgYx6o2zZSA.png" /></figure><p>6.In Type column select Webpage(HTML) so Text Editor Button will Enable and then select “Source” and added the URL of chatbots and press Ok</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*S3P9Vq4RoGNrWbtJ26IGJA.png" /></figure><p>7. For finding the url of chatbots Goto Chatbots =&gt; Setting =&gt; Channels =&gt;custom Websites.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*W1AuDtxp7tTMZgDeJ1tYwA.png" /></figure><p>automatically in URL column the link will come</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SzSeaP9lZmbzGqWFp5s4ig.png" /></figure><p>8. Click on “Publish”</p><p>9. Now I want to add the Chatbot in model drive App. In switch to classic</p><p>Goto Entities=&gt; Dataverse Name =&gt; Forms =&gt; Main.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*k4m-kPztsyyLKMxmuuOsvw.png" /></figure><p>10. here we need to add the chatbots. so, on header click on “Insert” =&gt; web resource</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lHrQ2QeBuLCyByKQRyvjrw.png" /></figure><p>and here in “web resource” we will search our chatbots with its name.</p><p>11. In Field Name and Properties Provide Name and Label Name and then click on Ok Button</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/971/1*Tp6waQJ4CbFxGce0eDTXLw.png" /></figure><p>12. After Create on My chatbots is Attached</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*T_eqSXlvDCGwLTVN9zvxIQ.png" /></figure><p>You can check it in your Model Driven Application its Added</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=64cbf7c6df7a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power Virtual Agent (Chatbot)]]></title>
            <link>https://medium.com/@deepaksingh26071999/power-virtual-agent-chatbot-4df5f6acde8e?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/4df5f6acde8e</guid>
            <category><![CDATA[chatbots]]></category>
            <category><![CDATA[power-virtual-agent]]></category>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Wed, 27 Dec 2023 03:04:54 GMT</pubDate>
            <atom:updated>2023-12-27T03:04:54.933Z</atom:updated>
            <content:encoded><![CDATA[<h3>What is Power Virtual Agent:</h3><p>Power Virtual Agent is a part of Microsoft Power Platform. It is designed for Analyze the data, Automate the process and creating the application in easy way. Mainly Power Virtual Agent is used for creating the Chatbot and virtual agent without the need of any extension Code.</p><h3>what is chatbot:</h3><p>Chatbot is a software application which can be used for simulating conversation with the human users over the internets. chatbot use the NLP (Natural language Process) To understand the user input and response. chatbot can be deploy on websites, messaging platform, mobile application and other platforms.</p><p>lets create chatbot using Power Apps:-</p><ol><li>Goto make.powerapps.com and click on “More” on Left Menu and select “Chatbots”</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Oq5svt0sk9hdwUO5h_OzFQ.png" /></figure><p>2. Click on + New Chatbots</p><p>Copilot screen will popup. Add <strong>Copilotname</strong> and select <strong>language</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XURGx9Myj9ORfv6XMs_Z6A.png" /></figure><p>3. Todo_List chatbot wis created:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UhSAhHoBX3sCFDd9B6jCbg.png" /></figure><p>4. If I want to add my own question to chatbot with the help “+ Add Blank Topics” we can add our own conversation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EuFIqdlQ1ovH253-5ripzQ.png" /></figure><p>5. For adding your own Questions, we need to write in “Enter Text box” and we can write a single or bunch of question here.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/917/1*VDkqiYE3o4U1QEd-9QWgOw.png" /></figure><p>All this are the question i Added so I asked any of this question to the chatbot.</p><p>So for some response comes from chat bot we need to click on “+ Icon” i.e Add Notes and select a “Message” and add whatever message so chatbot can provide us that as Output</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I-RyjELad8Ii4Etb760oKg.png" /></figure><p>IF i want to Add Questions With Multiple Choice Question it is easy more. click on “+ add Notes” and select Questions</p><p>Write Question And with the Help of “Add Options” we add the multiple Options. I Added 2 multiple Options <strong>DanpheEMR and DPM</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/666/1*TYUz0UEgzJCdQcEyydIQPQ.png" /></figure><p>Now for testing First Save this and Test Copilot</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/837/1*8i9y7AMUdFO6YPCc5Qlbtg.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4df5f6acde8e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Attachments in Canvas Apps using Patch Method]]></title>
            <link>https://medium.com/@deepaksingh26071999/attachments-in-canvas-apps-using-patch-method-5f38058555f7?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/5f38058555f7</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Thu, 05 Oct 2023 19:48:57 GMT</pubDate>
            <atom:updated>2023-10-05T19:48:57.508Z</atom:updated>
            <content:encoded><![CDATA[<p>In Power apps we can create Application using 3 type 1) Canvas App 2) Model Driven App 3) Portal Apps</p><p>Canvas Apps: - Canvas Apps is a type of application in power apps which can help us to create an application. In Canvas App user can create Interactive and Customizable Applications for working with Data without writing of Code. it also has Power Automate to Automate our Workflows.</p><p>Attachments: - Attachments can help us to Attach the File or Pdf</p><p>Patch: - Patch can help us to store the Data in Our Dataverse, also we can do Update using Patch.</p><h3>Attachment With Patch</h3><ol><li>1st need to create a Blank application in Canvas App and Add Edit Form in It</li><li>now we need Attachments so we will 1st create attachment in SharePoint List and used in Power Apps</li><li>In Power Apps 1st we create app and then we use<strong> Edit Form </strong>in It<br>and in <strong>Data</strong> we will find sharepoint and attach that inside <strong>Edit Form</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FkVldBi7A8UPHXmN6KIEZA.png" /></figure><p>4. Add SharePoint in Power Apps and arrange the size in it. here I only added Attachment inside Edit Form and Comments, Button are outside the Forms</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/1*hKKuNhuzSdXrAnbRfDryGA.png" /></figure><p>Now i want to create a Dataverse Table so they can store all the Records of my Patch()</p><p><strong>AttachmentPractise(Dataverse Table): 1) ID datatype as autoincrement 2)Attachment datatype as File 3) Comments datatype as String. I will add 3 column</strong></p><p>5. This is my Dataverse Table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9sFogTlMnr8cr1GsjeQsBA.png" /></figure><p>6. Now i will Add Patch Code On submit Button and That will store the Data in Dataverse Table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*H_5xSlbChw88-WQAwA3Sig.png" /></figure><h3>Uploaded Attachment Download</h3><ol><li>Create a Blank Vertical Gallery and Pass Datasource [<strong>AttachmentPractise</strong> ] .</li><li>in Gallery Added 1 label For Comments , and for Attchment Added DataCardvalue2_1(Copy and Paste it from Attachment List) that come From Attachment</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*M04ygHoazjGmOH1zhdS0Fw.png" /></figure><p>For Label4 <strong>Text</strong> <strong>Property:</strong>- ThisItem.Comments</p><p>For Attachment <strong>Item Property:</strong>- ThisItem.Attachments</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/850/1*H9sD01n8s_m_9ESmqvlDbw.png" /></figure><p>3. Attachment with Download:- click on Attachment Goto Advance Property(Right Side of Screen)</p><p><strong>Do changes on Name And Values :- Name :- FileName , Value :-Value</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AnEqONh6U1bNDmdrTaxSJA.png" /></figure><p>4. Save Code , Play it And Click on Attachment File It will Download it</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5f38058555f7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Reusable Component in Power apps]]></title>
            <link>https://medium.com/@deepaksingh26071999/reusable-component-in-power-apps-68b4bb7f3701?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/68b4bb7f3701</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Wed, 04 Oct 2023 19:16:58 GMT</pubDate>
            <atom:updated>2023-10-04T19:16:58.918Z</atom:updated>
            <content:encoded><![CDATA[<p>Power Apps is a Low Code Platform when We can create Application using Less Line of Code or No Code. It is a Largest PowerApps Platform where we can do Power Automate for Automate our Workflow and also include Power BI for Best Visualizations.</p><p>Reusable Components: Reusable Components is nothing But a Building Block that we Create Once and use it Again and Again</p><p>For Creating Reusable Component, we need to Follow Some Steps</p><p>step 1) Create a Blank canvas Power Application</p><p>step 2) Goto Components and Add New Component</p><p>Step 3) In Component we need Header so we will use Rectangle Shape and in header we add 2 buttons 1st Home 2nd About-Us</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bq9rh61CP0dpzglFyPRTmg.png" /></figure><p>Step 4) Now create 2Custom Property for 2Buttons and pass Datatype as Screen</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8mHG-ZPbWL4H8_1RHVwkNA.png" /></figure><p>2 custom Property is Created with Screen Datatypes</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/473/1*_rO6DaSnZEWPQteLJIs8zg.png" /></figure><p>Step 5) Now in Button1(Home) OnSelect Property we need to right code for Navigate :- OnSelect prop:- <strong>Syntax Navigate(ComponentName,CustomPropertyName) something Like this</strong><br>for <strong>Home Button OnSelect</strong> :- <strong>Navigate (HeaderComponentPractise.Home); for</strong> <strong>About-Us OnSelect</strong> :- <strong>Navigate (HeaderComponentPractise.About-Us)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/971/1*Y41lCq6kOVVpMnG1RQ-g3A.png" /></figure><p>step 6) Now goto Screen then Click on Custom and Add our Components.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/877/1*wXVnEjeyzlO0VajdFWjA4g.png" /></figure><p>step 7) Now inside Screen our Reusable Component is there click on that and in <strong>Left Side Property</strong> Tab it will reflect with our <strong>Custom Property. </strong>so simply pass our screen name inside <strong>Home and About-Us</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/868/1*yQ4hGqsdaycKdZhiVzH2hg.png" /></figure><p>inside this HeaderComponentPractise for Screen1 and Screen2 all the Cutsom Property will reflect so Pass all the Screen Name to Custom Property so it will Navigate Perfectly</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=68b4bb7f3701" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Dataflows connection for Dataverse]]></title>
            <link>https://medium.com/@deepaksingh26071999/dataflows-connection-for-dataverse-12ef5849bf24?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/12ef5849bf24</guid>
            <category><![CDATA[dataflow]]></category>
            <category><![CDATA[powerapps]]></category>
            <category><![CDATA[connection]]></category>
            <category><![CDATA[dataverse]]></category>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Tue, 28 Mar 2023 19:56:08 GMT</pubDate>
            <atom:updated>2023-03-28T19:56:08.447Z</atom:updated>
            <content:encoded><![CDATA[<p>What is Dataverse ?</p><p>Dataverse is a cloud-based data storage and management service provided by Microsoft as part of the Power Platform. It allows organizations to create, manage, and store data in a secure and scalable way, without the need for complex database infrastructure.</p><p>What is Dataflows ?</p><p>Dataflows is a data integration and transformation service provided by Microsoft Power Platform. It enables users to extract data from multiple sources, transform it into a common format, and load it into the Dataverse or other data destinations, such as a data warehouse or a business intelligence tool.</p><p>Here are the steps to create a connection for Dataverse to Dataverse in Dataflows: -</p><p>step1. First Sign into Power Apps using your Microsoft credentials.</p><p>step2. In the Power Apps, select the “… More” option from the left-hand menu.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gzDNYsZ75zS2oZQSVBOVfw.png" /></figure><p>step3. From there Select “Dataflows” from that list.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*42QrRHYUcoReu_eYCWwM8g.png" /></figure><p>step4. Click on the “New Dataflow” button in the top-right corner of the screen to create a new Dataflow.</p><p>step5. Give your Dataflow a name “Connection try” and create. then select “Dataverse” as the data source.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LHZCCAGqC9p9r5kbag8_Fw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-UyQncGX3TUoESCKyhYUPg.png" /></figure><p>Click on Dataverse It will create a Power query to connect to DataSource</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YbPicoFSJripdSEoEjgoSQ.png" /></figure><p>step6. Now the connection settings have Environment Detail where we want to paste the URL of Developer Resource Follow steps7 to get URL.</p><p>step7. that URL u will get Settings icon → Advanced Setting-&gt; settings Dropdown -&gt; Customizations-&gt; Developer Resources -&gt; copy the Service root URL.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/755/1*oeqtlHYb9ORKm1eLELRbUA.png" /></figure><p>step8. Paste that URL in Dataverse of Data source and then Sign in so our Dataverse connected successfully.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*43Kg1renKzGhSdJAyV47LA.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=12ef5849bf24" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Normalization in SQL Server]]></title>
            <link>https://medium.com/@deepaksingh26071999/normalization-in-sql-server-981eeca50120?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/981eeca50120</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Thu, 23 Mar 2023 17:03:09 GMT</pubDate>
            <atom:updated>2023-03-23T17:03:09.684Z</atom:updated>
            <content:encoded><![CDATA[<p>Normalization: -</p><p>Normalization is a Database technique which can help us to remove redundancy.</p><p>Redundancy means In a Table 1stcolumn <strong>Country </strong>and 2column <strong>Sales</strong> so here we are adding the sales of Country.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/320/0*m9D3Vl0QPL7bHNZp.png" /></figure><p>In country Column i have India and Ind. Both meaning is same but when i find total record of</p><p>India it will give me 700 Sales so this is redundancy .For removing redundancy we need to create a</p><p>master table and where we can add Country and link it with relationship.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/451/0*SBzZOJMLinixKDP6.png" /></figure><p>1st Normalization ,2nd Normalization, 3rd Normalization :-</p><p>Multivalued :- same Column Can have comma separate Files or more than 1 values.</p><p>e.g. :- full name Column i want to change all Singh to Yadav But its not possible so here follow the 1nf.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/321/0*GB2BOoZgp10vcq6d.png" /></figure><p>1nf :-Help us to avoid Redundancy and Multiple value in Column For that we need to split the column to Firstname,MiddleName and lastname then we edit the Singh to Yadav.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/319/0*K0l-5_GV4QmPH13H.png" /></figure><p>2nf :- non key Column Can fully depend on the primary key. so that we need to Split the table and link with Primary key.</p><p>for e.g.</p><p>In this Table i have records of Student + Subject records so we need to split the table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/319/0*IRVTf3mVkdZuRkA7.png" /></figure><p>split the table :-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/319/0*XzpG04g2jpzZUOqv.png" /></figure><p>3nf :- Transient in Nature. non-key column cannot fully depend on another non-key column.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/423/0*F1JCYrJ96Zy04Vpx.png" /></figure><p>Total Amount ,Cost and Unit are non-key column. Total Amount is fully Depend on Unit and Cost</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=981eeca50120" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Trigger in SQL Server]]></title>
            <link>https://medium.com/@deepaksingh26071999/trigger-in-sql-server-3124a09ccb04?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/3124a09ccb04</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Thu, 23 Mar 2023 16:51:39 GMT</pubDate>
            <atom:updated>2023-03-23T16:51:39.301Z</atom:updated>
            <content:encoded><![CDATA[<p>TRIGGER is logic which can be fire’s whenever we are doing INSERT , UPDATE , DELETE .</p><p>2 different type of TRIGGER in SQL SERVER :-</p><p>a. AFTER TRIGGER :-AFTER TRIGGER can be execute after the INSERT ,UPDATE, DELETE operators happen on table</p><p>b. INSTEAD OF TRIGGER :- INSTEAD OF TRIGGER can skip or cancel INSERT ,UPDATE, DELETE and it can be execute before the update of table</p><p>For creating any TRIGGER we need 2 Tables</p><p>In 1st Table we will perform all the operators like INSERT UPDATE DELETE and 2nd Table where TRIGGER will fire and provide us DATETIME() for every INSERT ,UPDATE ,DELETE queries</p><p>a.] <strong>AFTER TRIGGER</strong> we need 2 table</p><p>1st table is StudentRecord . 2nd Table name StudentTriggerData</p><p>In StudentRecord table we have 3 field StudID, Studname ,StudAge</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/529/0*RyqOziClLK9zmw8U" /></figure><p>In StudentTriggerData we have 1 field RecordofStudents</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/0*66aA8zNroJw-vYH3" /></figure><p>For writing Query of TRIGGER in StudentRecord we need to Right click on StudentRecord then select trigger then New Trigger</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/456/0*VhEzSK7-Hy9uy7mX" /></figure><p>In New Trigger we will write query for INSERT ,UPDATE ,DELETE operators</p><p>// Codes for AFTER TRIGGER</p><p><em>CREATE TRIGGER Studtrigger (provide name of triggerTable)</em></p><p><em>ON StudentRecord (table name of which table we r doing Insert ,update ,delete)</em></p><p><em>AFTER INSERT,DELETE,UPDATE (here we r doing After Trigger )</em></p><p><em>AS</em></p><p><em>BEGIN</em></p><p><em>insert into StudentTriggerData (RecordOfStudents) values(GETDATE());</em></p><p>END</p><p><em>GO</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/638/0*ATpUD04Uw5QLw4ow" /></figure><p>Now we add record on our StudentRecord table by right click on table and select (Edit Top 200 Record)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/0*GTIh0_Iu9jUjQCHn" /></figure><p>Adding some Records</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/0*gGiyI5Y_B3QtGYSL" /></figure><p>Trigger will invoke and provide DATE n TIME in StudentTriggerData Tabel</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/332/0*yaNVN66wgL87fbAx" /></figure><p>b.] <strong>INSTEAD OF TRIGGER </strong>:-</p><p>we just need to mentioned Instead of at the place of After and Instead of will skip the operators and not allow to add the record on table but it will add the Date n Time in our <em>StudentTriggerData Table</em>.</p><p>// Codes for INSTEAD OF TRIGGER</p><p><em>CREATE TRIGGER Studtrigger (provide name of TriggerTable)</em></p><p><em>ON StudentRecord ( table name of which table we r doing Insert ,update ,delete)</em></p><p><em>Instead of INSERT,DELETE,UPDATE (here we r doing Instead of Trigger)</em></p><p><em>AS</em></p><p><em>BEGIN</em></p><p><em>insert into StudentTriggerData( RecordOfStudents ) values(GETDATE());</em></p><p><em>END</em></p><p><em>GO</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/0*-iUI202Fpqbh9c4X" /></figure><p>Whenever we are adding records instead of will not allowing to adding the records</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/408/0*C2972leonZ5HHo3r" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3124a09ccb04" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Datatypes in SQL Server]]></title>
            <link>https://medium.com/@deepaksingh26071999/datatypes-in-sql-server-f8f67c771002?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/f8f67c771002</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Fri, 02 Dec 2022 14:35:23 GMT</pubDate>
            <atom:updated>2022-12-07T06:48:07.947Z</atom:updated>
            <content:encoded><![CDATA[<p>💓 Mssql Datatype can have int, char, varchar, decimal, bit, money</p><p>1) Integer: Integer Datatype can be used to store Whole Numbers like Id, Age can take 4byte of data to store.</p><p>tinyInt :- 1byte, smallInt: 2byte ,mediumInt : 3 byte, Int :4byte, bigInt :5byte</p><p>2) Char: - Char is a Fixed Length. char can store Non-unicode characters like English character, Special Character, Number etc. It can Store 1byte of data</p><p>3) Varchar: - Varchar is a variable Length. It stores Non-unicode characters like English characters, Special characters and number. And it can store 1 Byte of Data</p><p>4) Decimal: - Decimal can store the exact value in database. decimal (P, D)</p><p>P = Precision, D = Digit</p><p>5) Bit: - Bit can store the value 0 and 1. 0 = false ,1 = true.</p><p>6)Money: - Money can store the Currency Value</p><p>Also, we have nChar and nVarchar</p><p>nChar : nChar is a fixed length. it can store Unicode or Localized Language like Hindi, Marathi, Gujrati. And it takes 2 bytes to store</p><p>nVarchar : nVarchar is variable length.it can store Unicode or Localized Language like Hindi, Marathi, English. And it takes 2 bytes to store</p><p>💀 Different Between Char and nChar</p><p>Char : - Char is a Fixed Language and can Store English Character ,Special Character and Number . And its 1 bytes</p><p>nChar :- nChar can take local-language or Unicode language like Hindi, Marathi, Gujrati, English. It takes 2 bytes</p><p>💀 Different Between Varchar and nVarchar</p><p>Varchar: - Varchar is a Variable Length and can Store English Character, Special Character and Number. And its takes 1 bytes</p><p>nVarchar : Varchar can take local-language or Unicode language like Hindi, Marathi, Gujrati, English. It takes 2 bytes</p><p>For EG:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/492/0*-foOaw8a1CphX0ZC.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f8f67c771002" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[INSTALL MDX AND TABULAR IN SQLSERVER]]></title>
            <link>https://medium.com/@deepaksingh26071999/install-mdx-and-tabular-in-sqlserver-e8d192f4a5bb?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/e8d192f4a5bb</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Tue, 01 Nov 2022 18:29:36 GMT</pubDate>
            <atom:updated>2022-11-04T20:54:44.919Z</atom:updated>
            <content:encoded><![CDATA[<p>If we want to do Work in SSAS then we need to know how we can install and add MDX, TABULAR in SQL server. This article will help for Installation and Adding.</p><p>Before Installation we need to know SSAS, Cubes, MDX</p><p>SSAS: - SQL server analytics service is a Microsoft Business Intelligence Technology to develop OLAP (online analytics processing). SSAS can do precalculation it can also help us to create cubes using data from data mart or data warehouse for deeper and fast Data Analytics.</p><p>Cubes: - cubes are multi–Dimension Data Source which have Dimension and fact (Measures).</p><p>MDX: - MDX (Multi Dimension cubes) is a query language used to query a cube.</p><p>So, our SQL Server will look like this without MDX and TABULAR. It only has RDBMS</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YrQXcGErAN4xx6mYHLntgw.png" /></figure><blockquote>SO, we need to install MDX and TABULAR. For installing we need to perform some certain steps</blockquote><blockquote>INSTALLING MDX: -</blockquote><ol><li>SO, 1st we need to go to <strong>SQL setup </strong>which is located in</li></ol><p><strong><em>c:drive =&gt; sql2019 =&gt; Developer_ENU =&gt; setup</em></strong></p><p>2. open <strong><em>setup</em></strong> then select<strong><em> Installation</em></strong> and then select <strong><em>New SQL-Server stand-alone installation or …</em></strong></p><p><strong><em>setup =&gt; Installation =&gt; new sql server standalone</em></strong></p><p>3. go to <strong><em>Installation</em></strong> <strong><em>Type</em></strong> then select<strong><em> Add Features to an existing instance of SQL server 2019</em></strong> and drag the <strong><em>MSSQLSERVER then Next</em></strong>.</p><p><strong><em>Installation =&gt; Add Features to an existing instance of SQL server 2019 and Drag MSSQLSERVER then Next</em></strong></p><p>4.Feature Selection: - check the check box of<strong><em> Database Engine Services and Analysis Services</em></strong></p><p><strong><em>Feature Selection = &gt; Database Engine Services and Analysis Services check the checkbox</em></strong></p><p>5. select <strong><em>Ready to install and select Installation option</em></strong></p><p>6. MDX is Successfully Install</p><blockquote>INSTALLING TABULAR :-</blockquote><ol><li>SO, 1st we need to go to <strong>SQL setup </strong>which is located in</li></ol><p><strong><em>c:drive =&gt; sql2019 =&gt; Developer_ENU =&gt; setup</em></strong></p><p>2. open <strong><em>setup</em></strong> then select<strong><em> Installation</em></strong> and then select <strong><em>New SQL-Server stand-alone installation or ….</em></strong></p><p><strong><em>setup =&gt; Installation =&gt; new SQL server standalone</em></strong></p><p>3. <strong><em>Installation</em></strong> <strong><em>Type: -</em></strong> select<strong><em> Perform a new Installation of SQL server 2019</em></strong></p><p><strong><em>Installation =&gt; Perform a new Installation of SQL server 2019 =&gt; Next</em></strong></p><p>4.<strong><em> Product key: — specified a free edition s</em></strong>elect <strong><em>developer</em></strong></p><p><strong><em>product key: - specify a free edition: Developer</em></strong></p><p>5.<strong><em>accept the License Terms agreement =&gt; Next</em></strong></p><p>6.Feature Selection: - check the check box of<strong><em> Database Engine Services and Analysis Services</em></strong></p><p><strong><em>Feature Selection = &gt; Database Engine Services and Analysis Services check the checkbox</em></strong></p><p>7. <strong><em>Instance Configuration</em></strong>: - provide same name in<strong><em> Named Instance:- Tabular</em></strong> and same name will be in <strong><em>Instance ID: Tabular</em></strong></p><p>8.<strong><em>next to Server Configuration</em></strong></p><p>9.<strong><em>Database Engine Configuration</em></strong>: - click on <strong><em>Add Current User </em></strong>Button</p><p>10. <strong><em>Analysis Services Configuration</em></strong>: — select <strong><em>server Mode as Tabular Mode</em></strong> and click on <strong><em>Add Current User </em></strong>Button</p><p>11.select <strong><em>Ready to install and select Installation option</em></strong></p><p>12. Tabular is Successfully Install</p><blockquote>Now Both Tabular and MDX are Installed Successfully So, we need to go and add in SQL server</blockquote><p>Now Open SQL server: -</p><ol><li>Goto <strong><em>SQL server Object</em></strong> in <strong><em>Connect we have Analysis services </em></strong>clicked on that</li><li>SQL server popup: In <strong><em>Server name</em></strong> Drag the <strong><em>Browse for Servers </em></strong>and then we have <strong><em>Analysis Services</em></strong> drag it there will have <strong><em>MSI (MDX) </em></strong>and <strong><em>MSI\Tabular (Tabular)</em></strong></li></ol><blockquote><strong><em>Images for adding Tabular and MDX in SQL server</em></strong></blockquote><p>1st: -</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DuHDW-_7k2GDiYmhE3tJew.png" /></figure><p>2nd: —</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YPinmkTmd47eKCaX3OosTg.png" /></figure><p>3rd: -</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*x_NPx6nmwOck1IcZPfIKTQ.png" /></figure><p>4th: - finally our SQL will have both MDX and Tabular . It will look like this</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xUN_j5mwODEAmfTZiTP5bA.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e8d192f4a5bb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL SERVER PROFILER]]></title>
            <link>https://medium.com/@deepaksingh26071999/sql-server-profiler-f8ce90843d14?source=rss-330e5c33f7cf------2</link>
            <guid isPermaLink="false">https://medium.com/p/f8ce90843d14</guid>
            <dc:creator><![CDATA[DEEPAK SINGH]]></dc:creator>
            <pubDate>Wed, 12 Oct 2022 18:18:17 GMT</pubDate>
            <atom:updated>2022-10-12T18:18:17.932Z</atom:updated>
            <content:encoded><![CDATA[<p>what is SQL SERVER PROFILER: -</p><p>SQL server profiler is a tool which can Lisen all the SQL queries or troubleshooting problem of SQL servers. For e.g., we written any queries in SQL server like <strong>select * from stud_record</strong> and the queries are executed it will give us the record of stud_record and at same time the SQL server profiler also Lisen the same queries in Profiler by using batch Started and batch Completed.</p><p>for e.g.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/492/1*bQM5hjcKuX3eHpZFWmuaAQ.png" /></figure><p>Here the same query is Lisen by the SQL profiler with thw query.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pgv2RuaCCeiNAvZ5nVpLYg.png" /></figure><p>And if any SQL queries got error at that time profiler can Lisen error query too.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/1*AP2NmlAY9WHOGHharRieUQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OyGCn6g8teKNJM_neXMG-Q.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f8ce90843d14" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>