episodes

Monitor Auto Update Statistics

29 Dec 2022

Episode #98 with Antonios Chatzipavlis

Topics : SQL Server, Statistics,

Working with Hypothetical Indexes

18 Dec 2022

Episode #97 with Antonios Chatzipavlis

Topics : Indexes, Hypothetical, AUTOPILOT,

SQL Server 2022 Revealed - SQL Server 2022 - What's New

12 Dec 2022

Episode #96 with Antonios Chatzipavlis

Topics : SQL Server 2022,

Azure Arc enabled SQL Server and PAYG Licensing - SQL Server 2022 - What's New in Management

05 Dec 2022

Episode #95 with Antonios Chatzipavlis

Topics : SQL Server 2022,

Contained Availability Groups - SQL Server 2022 - What's New in Availability

03 Dec 2022

Episode #94 with Antonios Chatzipavlis

Topics : SQL Server 2022, Availability Groups,

System page latch concurrency enhancements - SQL Server 2022 - What's New in Performance

01 Dec 2022

Episode #93 with Antonios Chatzipavlis

Topics : SQL Server 2022, TempDB, PFS, GAM, SGAM,

Query Store and Secondary Replicas - SQL Server 2022 - What's New in Query Store

15 Nov 2022

Episode #92 with Antonios Chatzipavlis

Topics : SQL Server 2022, Query Store, QDS, QS, AG, Availability Groups, Always On, Replicas, Secondary,

Memory Grant Feedback Persistence - SQL Server 2022 - What's New in IQP

13 Nov 2022

Episode #91 with Antonios Chatzipavlis

Topics : SQL Server 2022, Memory, IQP, Query Store,

Optimized Plan Forcing - SQL Server 2022 - What's New in IQP

05 Nov 2022

Episode #90 with Antonios Chatzipavlis

Topics : SQL Server 2022, IQP, QDS,

Degree of Parallelism (DOP) Feedback - SQL Server 2022 - What's New in IQP

02 Nov 2022

Episode #89 with Antonios Chatzipavlis

Topics : SQL Server 2022, DOP, IQP,

Cardinality Estimation (CE) Feedback - SQL Server 2022 - What's New in IQP

01 Nov 2022

Episode #88 with Antonios Chatzipavlis

Topics : SQL Server 2022, CE, IQP

Query Store Hints - SQL Server 2022 - What's New in Query Store

31 Oct 2022

Episode #87 with Antonios Chatzipavlis

Topics : SQL Server 2022, Query Store,

Azure Synapse Link for SQL - SQL Server 2022 - What's New in Analytics

23 Oct 2022

Episode #86 with Antonios Chatzipavlis

Topics : SQL Server 2022, Azure Synapse,

Data Lake Virtualization with S3 compatible object Storage - SQL Server 2022 – What’s new

18 Oct 2022

Episode #85 with Antonios Chatzipavlis

Topics : SQL Server 2022, Analytics, Polybase,

Parameter Sensitive Plan Optimization-SQL Server 2022 - What's New in IQP

16 Oct 2022

Episode #84 with Antonios Chatzipavlis

Topics : SQL Server 2022, Parameter Sniffing,

SQL Server backup to URL for S3-compatible object storage - SQL Server 2022 - What's New in Mgm

10 Oct 2022

Episode #83 with Antonios Chatzipavlis

Topics : SQL Server 2022, Backup, Restore, S3

The Ledger - SQL Server 2022 - What's New in Security

07 Oct 2022

Episode #82 with Antonios Chatzipavlis

Topics : SQL Server 2022, Ledger, Security

Crypto and Encryption Enhancements - SQL Server 2022 - What's New in Security

03 Oct 2022

Episode #81 with Antonios Chatzipavlis

Topics : SQL Server 2022, Encryption,

TDS 8.0 and TLS 1.3 support - SQL Server 2022 - What's New in Security

02 Oct 2022

Episode #80 with Antonios Chatzipavlis

Topics : SQL Server 2022, TDS, TLS,

Transact-SQL snapshot backup - SQL Server 2022 – What’s new in Management

21 Sep 2022

Episode #79 with Antonios Chatzipavlis

Topics : SQL Server 2022, Backup, Restore,

Auto Update Statistics Async with Low Priority - SQL Server 2022 - What's New in Management

19 Sep 2022

Episode #78 with Antonios Chatzipavlis

Topics : SQL Server 2022, Statistics, Async,

Improved backup metadata - SQL Server 2022 - What's New in Backups

14 Sep 2022

Episode #77 with Antonios Chatzipavlis

Topics : SQL Server 2022, Backup, Metadata, Point in Time,

New Fixed Server Roles and Permissions - SQL Server 2022 - What's New in Security

12 Sep 2022

Episode #76 with Antonios Chatzipavlis

Topics : SQL Server 2022, Security, Roles, Permissions,

Dynamic Data Masking - SQL Server 2022 - What's new in Security

07 Sep 2022

Episode #75 with Antonios Chatzipavlis

Topics : SQL Server 2022, Data Masking,

XML Compression - SQL Server 2022 - What's New

06 Sep 2022

Episode #74 with Antonios Chatzipavlis

Topics : SQL Server 2022, XML, Compression,

Virtual Log File growth changes - SQL Server 2022 - What's New

05 Sep 2022

Episode #73 with Antonios Chatzipavlis

Topics : SQL Server 2022, Transaction Log, Growth, Virtual Log File, VLF,

Trim Functions Improvements - SQL Server 2022 - What's New

31 Aug 2022

Episode #72 with Antonios Chatzipavlis

Topics : SQL Server 2022, TRIM, LTRIM, RTRIM, T-SQL,

Accelerated Database Recovery (ADR) improvements - SQL Server 2022 - What's New

30 Aug 2022

Episode #71 with Antonios Chatzipavlis

Topics : SQL 2022, SQL Server 2022, What's New, ADR,

Resumable add table constraints - SQL Server 2022 - What's New

29 Aug 2022

Episode #70 with Antonios Chatzipavlis

Topics : SQL 2022, SQL Server 2022, Constraints, Primary Key, Unique,

Statistics AUTO_DROP - SQL Server 2022 - What's New

26 Aug 2022

Episode #69 with Antonios Chatzipavlis

Topics : SQL Server 2022, Statistics, AUTO DROP,

New JSON Functions - SQL Server 2022 - What's New

25 Aug 2022

Episode #68 with Antonios Chatzipavlis

Topics : SQL Server 2022, JSON, ISJSON, JSON_PATH_EXISTS, JSON_OBJECT, JSON_ARRAY,

The Approximate Percentile Functions - SQL Server 2022 - What's New

24 Aug 2022

Episode #67 with Antonios Chatzipavlis

Topics : SQL Server 2022, APPROX_PERCENTILE_DISC, APPROX_PERCENTILE_CONT,

Distinct Predicates - SQL Server 2022 - What's New

23 Aug 2022

Episode #66 with Antonios Chatzipavlis

Topics : IS DISTINCT FROM, IS NOT DISTINCT FROM, SQL Server 2022,

SQL Windowing Enhancements - SQL Server 2022 - What's New

22 Aug 2022

Episode #65 with Antonios Chatzipavlis

Topics : Window Functions, Window clause, SQL Server 2022,

Bit Manipulation Functions - SQL Server 2022 - What's New

19 Aug 2022

Episode #64 with Antonios Chatzipavlis

Topics : bit, left_shift, right_shift, bit_count, set_bit, get_bit,

Time Series Functions - SQL Server 2022 - What's New

18 Aug 2022

Episode #63 with Antonios Chatzipavlis

Topics : SQL Server 2022, Time Series Functions, DATE_BUCKET, GENERATE_SERIES, FIRST_VALUE, LAST_VALUE,

TSQL Functions - SQL Server 2022 - What's New

16 Aug 2022

Episode #62 with Antonios Chatzipavlis

Topics : SQL Server 2022, TSQL Functions,

Using Extended Properties

11 Aug 2022

Episode #61 with Antonios Chatzipavlis

Topics : Extended Properties, Documentation, sp_addextendedproperty,

Page Splits

05 Aug 2022

Episode #60 with Antonios Chatzipavlis

Topics : Page Splits,

Using Primary Key with large number of fields is not the best option to produce row uniqueness

29 Jul 2022

Episode #59 with Antonios Chatzipavlis

Topics : Database Design Mistakes, Primary Key, Unique Constraint,

Hide tables in SSMS

20 Mar 2022

Episode #58 with Antonios Chatzipavlis

Topics : SQL Server,

Implementing Slowly Change Dimension in Azure Synapse SQL pool

23 Feb 2022

Episode #57 with Antonios Chatzipavlis

Topics : Azure Synapse Analytics, Slowly Change Dimension, SCD, Azure Data Factory,

Send Notification Email from Data Factory or Azure Synapse pipeline

14 Feb 2022

Episode #56 with Antonios Chatzipavlis

Topics : Azure Synapse Analytics, Data Factory, Pipelines, Email, Notification,

Availability Groups and MSDTC importance

25 Jan 2022

Episode #55 with Antonios Chatzipavlis

Topics :