sqlschool.gr logo

episodes

Antonios thoughts about data platform technologies

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 :

YEAR

TAGS

Article

Data Modernization Trends to Transform your Data into Value in 2023

Ως κάποιος που είναι παθιασμένος με τα δεδομένα την ανάλυση τους και παρακολουθεί συνεχώς τις τάσεις της τεχνολογίας, αποφάσισα να γράψω ένα άρθρο στο οποίο να μιλήσω για τις τάσεις που βλέπω στο συγκεκριμένο χώρο για το 2023.

More Articles...

Tip

Refresh Intellisence in SSMS

Για να κάνουμε refresh το intellisence μέσα στο SSMS αρκεί να πατήσουμε Ctrl+Shift+R

More Tips...

Info graph

a day in data

Become a member

If you want to receive updates from us become a member to our community.

Connect

Explore

Learn


sqlschool.gr © 2010-2023 All rights reserved

This site uses cookies for operational and analytics purposes only. By continuing to browse this site, you agree to their use.