sp_Configure

What's new in SQL Server 2019?

Try SQL Server 2019! https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019-ctp

1.      Added Big Data Clusters - We can Deploy a Big Data cluster with SQL and Spark Linux and we can access big data from HDFS
2.      Now, support for persistent memory devices
3.      Now, support for column-store statistics in DBCC CLONEDATABASE
4.      Now added new Poly-base connectors
5.      Now certificate management in SQL Server Configuration Manager - SSL and TLS certificates are widely used to secure access to SQL Server instances
6.      Added UTF-8 support Database engine, SQL Graph features and Intelligent query processing
7.      The latest SSMS version supports choice of UTF-8 enabled collations in the UI.
8.      Added a new options - sp_estimate_data_compression_savings
9.      Added a new system function - sys.dm_db_page_info and it used for returns page information

Added some new system objects -
                    i.            sys.sp_xa_recover
                  ii.            sys.sp_xa_rollback
                iii.            sys.sp_xa_rollback_ex
                iv.            sys.sp_xa_start
                  v.            sys.xp_copy_file
                vi.            sys.xp_copy_files
              vii.            sys.xp_delete_files
            viii.            sys.sp_add_feature_restriction
                 ix.            sys.sp_autoindex_cancel_dta
                   x.            sys.sp_xa_commit
                 xi.            sys.sp_xa_end
               xii.            sys.sp_xa_forget
             xiii.            sys.sp_xa_forget_ex
             xiv.            sys.sp_xa_init
               xv.            sys.sp_xa_init_ex
             xvi.            sys.sp_autoindex_invoke_dta
           xvii.            sys.sp_cloud_update_blob_tier
         xviii.            sys.sp_configure_automatic_tuning
             xix.            sys.sp_diagnostic_showplan_log_dbid
               xx.            sys.sp_change_repl_serverport
             xxi.            sys.sp_getdistributorplatform
           xxii.            sys.sp_MSget_server_portinfo
         xxiii.            And manymore items are added

Added some new tables and views and its looks like -
                    I.            sys._trusted_assemblies
                  II.            sys.persistent_version_store
                III.            sys.dm_tran_aborted_transactions
                IV.            sys.tbl_server_resource_stats
                  V.            sys.dm_hadr_ag_threads
                VI.            sys.dm_hadr_db_threads
              VII.            sys.dm_os_job_object
            VIII.            sys.edge_constraint_clauses
                IX.            sys.persistent_version_store_long_term

Added some new functions and its looks like -
                    I.            sys.fn_getproviderstring
                  II.            sys.fn_dbslog
                III.            sys.dm_db_page_info



What’s New in sp_Configure  and sys.configurations Options?
The SQL Server 2019 is added three new options in sp_configure and sys.configurations-

1.      Allow file System Enumeration - By defaults is one (1), can be 0 or 1.
2.      Poly-base Enabled - By defaults is zero (0), can be 0 or 1
3.      Column Encryption Enclave Type - By defaults is zero (0), can be 0 or 1

What’s New in SQL Server 2019 in sys.tables?

Now, let’s try to explore to SQL Server 2019 - Reference link
ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.
^