Essential SQL Server Development Tips for SQL Developers

This lecture, is an overview of what you will learn in this section.

In this lecture, we will talk about the Sequence objects in SQL Server.

In this lecture, we will talk about the DATE data type in SQL Server.

In this lecture, we will talk about the TIME data type in SQL Server.

In this lecture, we will compare the DATETIME data type in SQL Server with DATETIME2.

In this lecture, we will talk about the MERGE statement in SQL Server.

In this lecture, we will talk about Row Constructors in SQL Server.

In this lecture, we will talk about the STRING_SPLIT function in SQL Server.

In this lecture, we will talk about the built-in JSON support in SQL Server.

In this lecture, we will talk about how you can use temporal tables in SQL Server.

In this lecture, we will talk about table-valued parameters (TVPs) in SQL Server.

In this lecture, we will talk about how you can segment strings in SQL Server.

In this lecture, we will talk about how you can generate T-SQL statements in SQL Server.

In this lecture, we will talk about how you can search for specific keywords in SQL Server Agent Jobs using T-SQL script.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture, you will learn how to import and export unstructured data in SQL Server using the VARBINARY Datatype.

In this lecture, you will learn how to import and export unstructured data in SQL Server using the FILESTREAM feature.

In this lecture, you will learn how to import and export unstructured data in SQL Server using the FileTables feature.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture, you will learn how to retrieve security-related info for SQL Server logins.

In this lecture, you will learn how you can insert leading characters to a string in SQL Server.

In this lecture, you will learn how you can retrieve all the records from all tables in all user databases in SQL Server.

In this lecture, you will learn how to retrieve SQL Server instance-related information.

In this lecture, you will learn how you can execute T-SQL statements against all databases, within a SQL Server instance.

In this lecture, you will learn how to create a simple linked server between SQL Server instances.

In this lecture, you will learn a variety of useful T-SQL tips.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture, you will learn how to find the programmability objects in SQL Server, and retrieve their meta-information.

In this lecture, you will learn how you can execute heavy set-based operations, against very large databases (VLDBs) in SQL Server.

In this lecture, you will learn how to build a simple data archiving mechanism, using the OUTPUT clause in SQL Server.

In this lecture, you will learn how to use computed and persisted columns in SQL Server tables.

In this lecture, you will learn how to handle NULL and empty values in SQL Server table records.

In this lecture, you will learn how to troubleshoot the error message: the multi-part identifier…could not be bound.

In this lecture, you will learn how you can use the GO command in SQL Server, in order to separate different T-SQL batches.

In this lecture, you will learn how to suppress the “N Row(s) Affected” Output Message in SQL Server.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will be learning in this section.

In this lecture, we will be discussing about the error message [The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered] and how you can easily resolve it.

In this lecture, we will be discussing about the benefits of primary keys in database tables.

In this lecture, we will be discussing about the differences between batch and streaming data.

In this lecture, we will be discussing about the benefits of using stored procedures in databases.

Via this lecture and live demonstration, you will learn how to easily retrieve version information about your SQL Server instances.

Via this lecture and live demonstration, you will learn all about T-SQL snippets in SSMS.

In this lecture, you will be learning about Transparent Data Encryption (TDE) in SQL Server, which is used for encrypting data-at-rest.

This T-SQL tip helps you to retrieve the version name a SQL Server instance using the @@VERSION system function in SQL Server.

In this lecture, we will be discussing about the basic knowledge you need to know about SQL Server database backup and recovery, including best practices and techniques for data security.

In this lecture, we cover the basics of SQL Server performance tuning. Performance tuning is crucial for maintaining efficient and responsive databases.

Explore the key differences between Data Warehouses and Data Lakes to make informed decisions for effective data storage solutions

In this lecture, we’ll walk through the core concepts of clustered and non-clustered indexes, then shift to specialized types like columnstore, filtered, and full-text indexes for broader indexing strategies.

In this lecture, we’ll look at some of the most common mistakes SQL developers make—often without realizing it. These issues can lead to slower queries, incorrect data, or even production failures. The goal here is not just to list them, but to understand why they happen and how to prevent them in your daily development work.

In this lecture, we'll explore Privileged Access Management, or PAM, in SQL Server, since privileged accounts, like sysadmin logins, are powerful but also pose the highest security risks if they’re misused or compromised.

This lecture, is a recap on what you have learned in this course.

This is the bonus lecture of the course.