You can export linked servers as SQL using the following steps:
020 February 2023
Export All SQL Agent Jobs
To export all SQL Agent jobs together as SQL, you can use the Script Job as option…
018 February 2023
Coalesce Function in MSSQL
COALESCE is a built-in function in Microsoft SQL Server that returns the first non-null expression among its…
016 February 2023
Pivot Function in MSSQL
In SQL Server, the PIVOT function is used to transform rows into columns. The PIVOT function is…
014 February 2023
SRING_AGG and STUFF functions in MS SQL
Both STRING_AGG and STUFF are string functions in Microsoft SQL Server that are used to manipulate strings.
010 February 2023
Triggers in MSSQL
A trigger is a special type of stored procedure in Microsoft SQL Server that automatically executes when…
08 February 2023
SQL Merge Statement & UPSERT Operation
The MERGE statement in Microsoft SQL Server allows you to perform multiple actions (such as insert, update,…
07 February 2023
CTE (Common Table Expression) in SQL
CTE (Common Table Expression) is a feature in SQL that allows you to define a temporary result…
06 February 2023
SQL Window Functions
SQL Window Functions are a feature of SQL that allow you to perform calculations across rows within…
02 February 2023
How to access local MongoDB server from a Docker Environment
It is actually pretty easy. In my case I needed to reach from Laravel Sail to my…