SQL Server Indexes Management Using Index Manager for SQL Server

The article describes SQL Server indexes’ types that serve to accelerate reading data from underlying tables and tools to work with indexes.

How To Create A SQL Trace To Capture SQL Server Events

To create a SQL trace, follow these manual steps: Click Start, point to Programs, click Microsoft SQL Server 20xx (your version), click Performance Tools, and then click SQL Server Profiler. On the File menu, click New Trace… to open the 'Connect to Server' dialog box.

Configure SQL Jobs in SQL Server using T-SQL

Using SQL Server Management Studio. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand SQL Server Agent, create a new job or right-click an existing job, and then click Properties. In the Job Properties dialog, click the Steps page, and then click New.

How SQL Server Stores Data Types: sql_variant

How SQL Server Stores Data Types: sql_variant. In this article, see how SQL Server stores data types.

Deploying a Database on Azure SQL – {coding}Sight

The article describes how to create an SQL Server in Azure and deploy a small database using a free tier subscription and basic resources.

Deploying the first SQL to Azure Migration project with Azure Database Migration Service

This article covers real-time issues and use cases of migration tasks for SQL Server to Azure cloud database with ADMS.

SQL Create Table Statement Example | Create Table in SQL Tutorial

SQL Create Table Statement Example | Create Table in SQL Tutorial. The CREATE TABLE statement is used to create a new table in a database.

SQL Datatypes Example | Datatypes In SQL Explained

SQL Datatypes are used to represent the nature of data that can be stored in the database. The data type is the set of representable values.

SQL Injection Example | What Is SQL Injection

SQL injection is a code injection technique that may lead to destroying your database. It is one of the most common web hacking techniques.

SQL Stored Procedure Example | Stored Procedure In SQL

SQL stored procedure is a prepared SQL code that is used to save time and can be reused over and over again. These stored procedures are used in SQL SERVER.

SQL Left Function Example | LEFT() In SQL Server And MySQL

SQL LEFT() is used for extracting a substring starting from the left, followed by the number of characters. The LEFT() extracts several characters from the string.

SQL LOWER Function Example | Lower() In MySQL and SQL Server

SQL LOWER Function Example | Lower() In MySQL and SQL Server. The SQL LOWER function converts all the characters in a string into lowercase.

10 Tips & Tricks To Work With SQL Server Management Studio

This article covers tips to work with SQL Server Management Studio and reduce the time spent on routine in SSMS and increase your efficiency.

Backup Database using T-SQL Statements

Introduction In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements. We need to use BACKUP DATABASE statement to create full database backup, along with…

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master

This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below.

SQL LTRIM Function Example | LTRIM In MySQL And SQL Server

SQL LTRIM() is an inbuilt function that is used for removing all the leading whitespaces or specified characters from the string from the left-hand string.

SQL Format Function | How To Format Function In SQL Server

SQL FORMAT() is an inbuilt function that is used for formatting value with a format. FORMAT() function is used with date/time values and number values.

SQL UNICODE Function Example | SQL Server UNICODE()

SQL UNICODE function is used for returning UNICODE value, i.e. an integer value for the first character of expression. SQL UNICODE Function Example.

SQL Upper Function Example | Upper In MySQL, SQL Server

The SQL UPPER function converts all the letters in a string into uppercase. To convert a string to lowercase, you use the SQL LOWER function instead.

SQL Translate Function Example | SQL Server Translate

SQL TRANSLATE function is used for replacing the sequence of characters with another set of characters one by one. SQL Translate Function Example.