SQL Server Tutorial

This website provides a SQL server Tutorial, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .

You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.

How to get the sizes of all databases on a SQL Server

How to get the sizes of all databases on a SQL Server ?

SQL Server Lag Function

SQL Server LAG() function is a Analytics Functions that provides access to a row at a given physical offset that comes before the current row.

SQL Server CONCAT_WS Function

SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.

It separates those concatenated string values with the delimiter specified in the first function parameter.

SQL Server ISNUMERIC Function

SQL Server ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.

Identify blocked processes or long nunning query in SQL Server

Blocking occurs when a process hold a lock and other process has to wait till the first process completes.

SSRS shared data source

A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server .

SSRS Shared DataSets

SSRS Shared Dataset is a dataset which is created by using Shared Data Source and deployed to Report Server. Shared Dataset can be used by multiple reports.

SQL Server CUBE

CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.

SQL Server GROUPING SETS

SQL GROUPING SETS allows computing multiple GROUP BY clauses in a single statement. The results of GROUPING SETS are the equivalent of UNION ALL of the specified groups.

SQL Server CHOOSE Function

SQL Server Tutorials By Pradeep Raturi : SQL Server CHOOSE Functions is the logical function that returns the item at the specified index from a list of values in SQL Server.

SQL Server IIF Function

SQL Server Tutorials By Pradeep Raturi : SQL Server IIF function is the logical function that returns one of two parts, depending on the evaluation of an expression.

Temporary table / temp table in SQL Server

Temporary or Temp tables are tables that exist temporarily on the SQL Server.

How to Retrieve data in XML Format in SQL SERVER

How to Retrieve data in XML Format in SQL SERVER ?

SQL SERVER TRY_CAST()

SQL Server TRY_CAST() Function is a conversion functions that is used to cast a value to a specified data type.

Delete duplicate rows from a table in SQL Server

how to delete duplicates records from a table in sql server ?.

SQL Server CTE

SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.

SQL Server Sequence

A Sequence objects are used to sequentially generate numeric values that can be in ascending or descending order at a defined interval and may cycle if requested.