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
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 :
Article
Data Modernization Trends to Transform your Data into Value in 2023
Ως κάποιος που είναι παθιασμένος με τα δεδομένα την ανάλυση τους και παρακολουθεί συνεχώς τις τάσεις της τεχνολογίας, αποφάσισα να γράψω ένα άρθρο στο οποίο να μιλήσω για τις τάσεις που βλέπω στο συγκεκριμένο χώρο για το 2023.
More Articles...
Tip
Για να κάνουμε refresh το intellisence μέσα στο SSMS αρκεί να πατήσουμε Ctrl+Shift+R
More Tips...
Info graph
If you want to receive updates from us become a member to our community.
About us
Contact us
Newsletters
Privacy
Terms of Use
Connect
Explore
Learn
This site uses cookies for operational and analytics purposes only. By continuing to browse this site, you agree to their use.