• Articles

    Improve SQL Server performance using profiler and tuning advisor

    Lets start with point number 7 How can we improve SQL Server performance by using Database engine tuning advisor SQL Server performance largely depends on how you have created the index i.e your cluster index and non cluster index etc Most of the times developers do not even think about indexes By default SQL Server creates a cluster index on the primary key and that’s a only index you will find in most database by default non cluster index if you have not given thought of index or indexes I’ll say non cluster indexes far away When these default settings are taken to production It doesn’t workout for a long…

  • SQL Server interview question  :- What is use of Coalesce and ISNULL ( SQL Server training)?
    Articles,  Blog

    SQL Server interview question :- What is use of Coalesce and ISNULL ( SQL Server training)?

    In this video will try to understand what exactly is the use of ISNULL function and what is the use of Coalesce function Let me pronounce again coalesce I am not sure that if that pronounciation is right but english is my second language In case it is not right I am extremely sorry for that In this video we will try to demonstrate ISNULL and Coalesce function First start with ISNULL In order to demonstrate the ISNULL function I have created a very simple table here The table name is tblPerson and it has two columns first name and surname and if you go and fire select query over…

  • Deploying Microsoft SQL Server to Google Compute Engine
    Articles,  Blog

    Deploying Microsoft SQL Server to Google Compute Engine

    In this Cloud Minute, I want to show you how to deploy Microsoft SQL Server on a Google Compute Engine instance. In Google Cloud Developer Console Go to Compute Engine and create an instance Give it a name, select its zone and then machine type For boot disk, choose one of the SQL Server images provided And hit create Once the instance is ready You can create a Windows user and password and remote desktop into it like any other Windows instance Once logged in You can use SQL Server Management Studio to connect and manage the SQL Server instance You can check out the links in the description of…

  • Articles

    SQL Server interview training :-What are triggers , inserted and deleted tables ?

    In this video will talk about what exactly are triggers, and in what scenario we should be using them While we do that will talk about two important types of tables one is called as inserted table and the other one is called as deleted table Will talk about two different kinds of triggers i.e called as the Instead of trigger and the After trigger Triggers are logic like stored procedures which can be executed before the updation happens on a table or after the updation happens on a table If you want to execute pre processing or post processing logic after the updation or before the updation you can…

  • Articles

    How to use Blazor and C# to host a static website in Azure Storage | Azure Tips and Tricks

    >>Learn how to use Blazor and C-sharp to host a static website in Azure Storage in this episode of Azure Tips and Tricks. Blazor is a cool new feature of ASP.NET that allows you to build client web apps using C-sharp. We’ll create a client-side Blazor Web Application and host it in Azure storage using the static websites feature. I’ll use Visual Studio 2019 to create the blazer app with. To find out what you need to install to use blazer, visit this URL. Here we go. I’ll do File New Project, and here I select the ASP.NET Core Web Application. Now I’ll give it a name, MystaticBlazorApp. All right.…

  • Uploading files to GCS (Cloud Storage Bytes)
    Articles,  Blog

    Uploading files to GCS (Cloud Storage Bytes)

    JENNY BROWN: Before you can use the power of the cloud to serve your content, you have to get your data into it. In this episode of “Google Cloud Storage Bytes,” we talk about all the different ways you can upload data. So buckle up, because we’re heading to the cloud. [MUSIC PLAYING] We all know that Google Cloud Storage can serve your binary assets to users worldwide at high speeds and low prices. But before you can do any of that, you’ve got to get your data into Google Cloud Storage, which can be done in a few specific ways. First is the easiest option– using the Google Cloud…

  • Deploying Web Service in Hosting Server (eg: godaddy, somee etc.) || Part-19
    Articles,  Blog

    Deploying Web Service in Hosting Server (eg: godaddy, somee etc.) || Part-19

    hi I’m Revanth this is part 19 of web services video series in this session we will discuss how to deploy web service in hosting server like a godaddy and somee.com etc important synopsis we will discuss in this video are create a web service project buy the required hosting server and deploy the developed service in hosting server using FTP File Transfer Protocol or visual studio or using cPanel from the file manager so let’s begin the tutorial if you haven’t watched the previous videos I strongly recommend to watch before proceeding this video’s in part 16 and part 17 and party 18 how discussed consuming and deploying web…

  • Upload Website ASP.NET MVC [Hosting SOMEE.COM]
    Articles,  Blog

    Upload Website ASP.NET MVC [Hosting SOMEE.COM]

    I will show you how to publish a website ASP.Net to hosting Somee This is my example Website ASP.Net You must solve all errors in Console Log Next we’ll publish our website by Publish in VS Choose Custom & Set a name Choose File System Choose a path to publish Here I create a path to C:Publishedmymobileshop Then OK & Next Here I choose to Delete all existing files before publishing Then publish Waiting & listen to Music=)) Finished Compress all files as Zip type Go to Control Panel of SOMEE Of course you must have a acc on Somee Then create our Website Set name of Website Choose MSSQL…