Learn With Sundar

Get Started

  • Find Recently Modified Tables In SQL Server Database

    Introduction SQL Server maintains a table to keep information about each tables that are created in appropriate databases. Its a System Table called as sys.tables. For every table created to the database, a new one record is created in the sys.tables table which contains information such as table name, object id of table, created date,…

  • Azure Relational Databases – An Overview

    Introduction In this article we will discuss about the Relational Databases that our Azure Cloud provides. Azure provides four Relational Database Services as, SQL Server in a Virtual Machine SQL Managed Instance Azure SQL Database Azure Database for MySQL, PostgreSQL, MariaDB Now lets explore each services individually. SQL Server in a Virtual Machine The same…

  • Preparing Data For Power BI Report and Dashboard

    Introduction In this article, we will discuss about the steps that we need to flow to prepare an Interactive Reports and Dashboards using the Data in Power BI. Import Data from Data Source First thing is we have to load the data from the data sources. In our previous articles we have discussed about this,…

  • Azure Databricks – An Overview

    Introduction These days Data place an important roles in our day to day life and there are plenty of data available, which in terms becomes difficult to manage by Data Professionals. But we have smart tool to manage our large amount of data, which is called Azure Databricks. In this simple article, we will have…

  • Import Dataset In Python From SQL Server – Get Started with SQL Server Machine Learning Services – Part 4

    Introduction In our previous article, we discuss about how to run Python in SQL Server that hard coded. In this article we will discuss about the data which is already stored in our SQL Server Databases. Steps to Process Python with SQL Server Data In order to work with Data using Python, we have to…

  • SQL Server sp_execute_external_script Stored Procedure – Get Started with SQL Server Machine Learning Services – Part 3

    Introduction When we want to execute any external language script in SQL Server, then we have to sp_execute_external_script stored procedure. sp_execute_external_script  is a new system stored procedure which was introduced in the SQL Server 2016. It is mainly used to execute the Machine Learning Services such as Python and R in SQL Server. Executing Python…

Subscribe

Enter your email below to receive updates.