You can export linked servers as SQL using the following steps: Continue reading Export Multiple Linked Servers
Category: Development
Export All SQL Agent Jobs
To export all SQL Agent jobs together as SQL, you can use the Script Job as option in SQL Server Management Studio. Here are the steps to do this: Continue reading Export All SQL Agent Jobs
DNS Records
DNS (Domain Name System) is a hierarchical and distributed naming system used to translate domain names into IP addresses. DNS records contain information about a domain’s configuration, including the IP addresses associated with the domain, email servers, and other essential information. Continue reading DNS Records
Coalesce Function in MSSQL
COALESCE is a built-in function in Microsoft SQL Server that returns the first non-null expression among its arguments. It takes one or more expressions as arguments and returns the value of the first expression that is not NULL. If all the expressions are NULL, it returns NULL. Continue reading Coalesce Function in MSSQL
Times and Timezones in PHP
To store and convert time between timezones in PHP, you can use the DateTime class and the DateTimeZone class. Continue reading Times and Timezones in PHP
Pivot Function in MSSQL
In SQL Server, the PIVOT function is used to transform rows into columns. The PIVOT function is a T-SQL operator that rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, effectively creating a cross-tabulation of the data. Here’s an example to help illustrate the concept: Continue reading Pivot Function in MSSQL
Send SMTP mail in PHP
You can send SMTP mail in PHP using the built-in mail() function or by using a third-party library like PHPMailer. Continue reading Send SMTP mail in PHP
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. Continue reading SRING_AGG and STUFF functions in MS SQL
Protect your website with Cloudflare DNS
To protect your domain with Cloudflare, you can follow these general steps: Continue reading Protect your website with Cloudflare DNS
Serve Laravel website on a shared hosting
Serving a Laravel website on a shared hosting can be a bit challenging, but it’s definitely possible. Here are some steps you can follow to deploy a Laravel website on a shared hosting: Continue reading Serve Laravel website on a shared hosting
Promises in Javascript
In JavaScript, a promise is an object that represents a value that may not be available yet, but will be at some point in the future. Promises are commonly used for asynchronous programming, such as fetching data from a server or waiting for a user input. Continue reading Promises in Javascript
Triggers in MSSQL
A trigger is a special type of stored procedure in Microsoft SQL Server that automatically executes when an event occurs, such as an INSERT, UPDATE, or DELETE statement. Triggers can be used to enforce business rules, maintain data integrity, or perform actions automatically in response to changes in the data. Continue reading Triggers in MSSQL