SQL Server Blogs & Tutorials

This guide delves into the intricacies of clustered and non-clustered indexes in SQL Server, highlighting their importance in optimizing database performance. Understanding these concepts is crucial for database administrators and developers who aim to enhance query efficiency and data retrieval speed. Before diving in, familiarity with basic SQL Server concepts and the importance of database indexing is recommended.

Hello guys in this tutorial , we will learn the first step of using sql server. We will see how we can create database and perform crud operation using sql queries.

Setting up database on plesk server

Database Backup .bak

1418 (HY000) at line 10185: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

Hello guys, sometimes while working with sql server we often create tables with wrong columns names and we often need to rename those columns. So we will see how to rename table column in sql server.

Hello guys, sometimes while working with big databases in sql server we often need to find all tables where we have used specific columns. So we will see how to do that.

Hello guys, sometimes while working with big databases in sql server we often need to find all procedures where we have used a certain table.So we will see how to do that.

Converting commas or other delimiters to a Table or List in SQL Server

Multiple rows to one comma separated value in Sql Server

The GROUP_CONCAT() function was built specifically for the purpose of concatenating a query’s result set into a list separated by either a comma or a delimiter of your choice.

How to create a read-only MySQL user

How to Connect to a Database with MySQL Workbench

Hello guys, sometimes while working with sql server, we sometimes face the need of working with json data . For that purpose we have to be able to read json data in sql which is quite a difficult task, so we will see how to read json in sql server in simple steps.

Hello guys, in this article we will create script for creating database backups from sql database server. We will use powershell script batch file for this purpose.