SQL Server 101

Unlock the Power of SQL Server Management Studio (SSMS): An In-Depth Look

STRING_SPLIT: Splitting strings into multiple rows using SQL Server using a delimiter or separator

Getting the previous or next row in SQL Server (T-SQL)

Install SQL Server 2022 Developer and SQL Server Management Studio (SSMS) for Free (2024 video)

It's a rap

Practice Activity - Creating a rolling total over the last 3 months in SQL Server

How to check or change the server mode of SSAS (SQL Server Multidimensional or Tabular)

Practice Activity - remove duplicate rows in SQL Server (three different ways)

Convert numbers year, month and days and more to dates in SQL Server - with ...FROMPARTS functions

Retrieve all invoices in SQL Server with a date between now and a month from now

Combing two SQL Server tables together using a JOIN, and creating a Running Total

SQL Server in the Cloud: Creating a Microsoft Azure SQL Database (2023 Version)

How do you pronounce "SQL", as in "SQL Server" or "MySQL"?

SQL Server: The certificate chain was issued by an authority that is not trusted

How to add features to an existing installation of SQL Server

Replace NULLs in an SQL Server query

Installing SSMS version 20, and solving certificate chain not trusted problem in SQL Server.

SQL Server in a minute: Creating a numbered list

Beyond SQL Server: Key Apps and Services for SQL Server Users

Marking rows in an SQL Server table as duplicates

FREE TRIAL: Get a FREE Azure Subscription to Try Out Microsoft's Cloud Services

How to install sample data (from AdventureWorks) on your SQL Server

The SQL Server SELECT statement in 60 seconds - the GROUP BY Clause

What are the various components of SQL Server (T-SQL, DBA, SSRS, SSIS, SSAS, and Azure)?

Use Artificial Intelligence to create sample data for SQL Server.

Microsoft SQL Server, Error: 18456 (connecting to Azure)

Uncover the Secret to Solving That "Trust Server Certificate Connection Error" in Azure Data Studio!

Calculating the first day of the week in SQL Server

How to spread durations (in days) across years using PIVOT in SQL Server (Gantt chart)

SQL Bits 2023 in Newport, Cardiff

Extract parts of dates - using DATENAME, DATEPART, DAY, MONTH and YEAR functions in SQL Server

Calculate the next working day (excluding weekends and vacation/holidays) in SQL Server

Joining strings in SQL Server: +, CONCAT, CONCAT_WS and STRING_AGG

Practice Activity - Joining SQL Server daily data to weekly data

Practice Activity: Replacing NULL and blank values in Microsoft SQL Server

Unveiling the Mystery of Azure Data Studio - Download and Install and how to use Tutorial!

Practice Activity: How to retrieve the second row from a dataset in Microsoft SQL Server

Can I do a certification in SQL Server?

Listing columns using sys.columns, and creating a SELECT statement JOINing three tables

Unveiling the Mysteries of SQL: What You Need to Know!

How do you create a view in SQL Server?

Create Stored Procedures in SQL Server - What You Need to Know

Find column type and sizes in your SQL tables

How to install sample data into SQL Server (2023 version) - AdventureWorks

SQL Server in a minute: What software do you need to install SQL Server? (2023 edition)

Practice Activity: Which employees are being paid more than their managers (using a self-join)

The SQL Server SELECT statement in 60 seconds - the SELECT Clause

The SQL Server SELECT statement in 60 seconds - the HAVING Clause

Practice Activity: How to retrieve the top 80% of items in SQL Server (the Pareto principle)

Creating a time table in SQL Server

The FORMAT function in SQL Server - extracting single or multiple parts of a datetime