Learn With Sundar

Get Started

  • Creating T-SQL Query Shortcuts in SQL Server Management Studio(SSMS)

    Introduction Using keyboard shortcuts, it saves time, isn’t it?. SQL Server Management Studio is also not an exception !!!. We can add our own custom keyboard shortcuts, that too for T-SQL query. Really cool !!!! How many of you know about this feature???. Do not worry if you did not know this before. Now you…

  • 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…

Subscribe

Enter your email below to receive updates.