17 тысяч подписчиков
169 видео
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
