Learn With Sundar

Get Started

  • What is Power BI

    Introduction With Microsoft Power BI we can quickly connect to our data and visualize as much or as little as we like and creates stunning reports and dashboards to help get insights into the business, which helps to make decisions. To make decisions we need data, that only the business data. In this article, we…

  • Pinned tabs in SQL Server Management Studio (SSMS)

    Introduction While working in SQL Server Management Studio (SSMS), we may need to open many query windows. But each time we may feel difficult to recognize the important query window which we need to refer frequently. There is an option, we can Pin the tabs which are mostly frequently referred. Pinning Tabs We can pin…

  • SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master – Part 3

    Introduction This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below, MS SQL Server – Zero to Hero Query Master – Part 1 MS…

  • Split Query Window in SQL Server Management Studio(SSMS)

    Introduction Sometime we may write a long query in our query window and we may need to refer the objects or other part of the T-SQL frequently. For that we may be scrolling up and down in the query window. But we have an awesome option for that in the SQL Query Window, which many…

  • Last Execution of Stored Procedure in SQL Server

    Introduction In an ERP project or any other big applications, there may be many Stored Procedures used. But we are not sure that all the stored procedures are required or not or valid ones. While the requirement(s) has changed, we may ended with another new stored procedure or based on the performance we may have…

  • List Databases Available for Current User -SQL Server

    Introduction Sometimes, we may be curious to know to which databases do we have access or we need to access a particular database but not sure that we have access or not. In this article, we will discuss a T-SQL that will list the Databases available for current user. For Particular Database HAS_DBACCESS  – This…

Subscribe

Enter your email below to receive updates.