Learn With Sundar

Get Started

  • Efficient Way Of Copying Database In SQL Server

    Introduction Sometimes when working in Database, we may need to create another working copy of the current database or production database to check our new logic which should not affect the existing objects such as tables, stored procedures or etc. Example, suppose we may need to check few things using the Production database, but applying…

  • One Drop Statement For Multiple Tables In SQL Server

    Introduction When as a developer working in a database, which is in Development state, we may create some physical tables or temp tables to check the logic. Or based on the initial requirement we may have created more tables as part of Normalizing the data and our reviewer may suggest some better ideas to accommodate…

  • Query Editor in Power BI for Data Transformation

    Introduction From our previous articles, we know how to load data into our Power BI from various data sources. But that exact data is not enough to create our Power BI reports. We need to shape those data, that is refine the data, adding new columns, renaming the columns and many other improvements to create…

  • Power BI Change Data Type of a Column

    Introduction Mostly the Power BI Desktop tool automatically detects the datatype of a column based on its value. Sometime it detects wrong datatype because Power BI automatically detects all these column data types as text (mostly) or as some other datatype formats. Say for an example, the Number’s may be converted to Text datatype or…

  • What is Azure Cognitive Search

    Introduction In this article, we will discuss about the Azure Search also known as Azure Cognitive Search. What is Azure Search?. Azure Search is a Search-as-a-Service cloud solution. These days modern applications has Search options, which make users to use the application in simple. But developers know that implementing the search engine is not that…

  • List of Available Database for Current User In SQL Server

    Introduction When working in the SQL Server, we may have to check some other databases other than the current one which we are working. In that scenario we may not be sure that does we have access to those Databases?. In this article we discuss the list of databases that are available for the current…

Subscribe

Enter your email below to receive updates.