Все публикации

All about IDENTITY0:23:51

All about IDENTITY property in SQL Server (Deep Dive)

Deep dive: Using0:43:08

Deep dive: Using JSON with SQL Server

Read JSON data0:03:59

Read JSON data from a table and parse it to rows and columns

Store JSON data0:11:25

Store JSON data in SQL Table using IsJSON() CHECK constraint

Parse JSON string0:10:36

Parse JSON string with nested elements in SQL Server

Import JSON string0:09:02

Import JSON string to SQL tabular row-column format

Convert rows from0:10:18

Convert rows from a SQL Query or Table to JSON format

Download SQL Server0:11:20

Download SQL Server 2019 for free (with SSMS)

Connect SQL Server0:09:40

Connect SQL Server on Linux Azure VM from SSMS

Install SQL Server0:13:46

Install SQL Server on Linux Azure VM

Create a Ubuntu0:10:14

Create a Ubuntu Linux VM on Microsoft Azure

Download and Install0:15:22

Download and Install SQL Server 2017 and SSMS

Import multiple Record0:04:54

Import multiple Record sets from an Excel sheet to SQL Server

Import data from0:02:25

Import data from Excel to SQL Server table

Export a Table0:05:38

Export a Table or Query results from SQL Server to Excel

Move master database0:05:35

Move master database to another drive in SQL Server

Move tempdb to0:05:08

Move tempdb to another drive in SQL Server

Move user Database0:06:36

Move user Database (.mdf and .ldf files) to another drive in SQL Server (DBA stuff)

Detach and Attach0:10:21

Detach and Attach a Database in SQL Server

Run SQL Query0:05:38

Run SQL Query with Date Range filter in Excel

Call Stored Procedure0:05:16

Call Stored Procedure with multiple parameters from Excel

Create Parametrized SQL0:03:26

Create Parametrized SQL Reports in Excel

Create Pivot Table0:04:00

Create Pivot Table report in Excel by connecting SQL Server

Call Stored Procedure0:03:22

Call Stored Procedure from Excel and show results