SQL Server 2019 : Administration SQL Server Part 2

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 2.6 GB
  • Uploaded By tutsnode
  • Downloads 755
  • Last checked 1 day ago
  • Date uploaded 4 years ago
  • Seeders 17
  • Leechers 2

Infohash : 52C660589AD62B7B8AF3DD26F5761C3049BE940B




Description

This course brings together two of my courses on the Udemy platform which are :

SQL server : Configuring and modifying a database on SQL Server
SQL server : The complete course on Indexes (4 h of class)

The first chapter will talk about the index :

You have problems of slowness on your SQL servers, and you suspect the implementation of your indexes?

You haven’t set up indexes on your tables, because you don’t know the differences between a clustered and a non-clustered index?

In this first chapter, come and discover the importance of a good index setup on your tables, don’t go on a spending spree buying disk storage, when it may be the index setup that is wrong!

It’s simple, indexes are the first reason, of your performance improvements on a SQL server.

The training in detail:

The structure of a clustered and a non-clustered index.
The Table SCAN and the Table SEEK
The covering index and Why you should not index the whole table (Over indexing).
Remove duplicate indexes, and see the definition of a SINGLE index.
Remember to consolidate indexes, and the columnstore index.
Beware of filtered indexes and their associated cache plan, and see what is the term SARGABLE?
How to choose the right Clustered Index
Why fragmentation is important, and how to remove it
Tracking page splits and the FILLFACTOR definition
Rebuild Index Vs REORGANIZE and the ABORT_AFTER_WAIT option
The second chapter will talk about the configuration and modification on your database :

Do you know that a bad choice of your AUTOGROW of your DB, can lower your performance on your server?

And yes it’s not a myth

In this course we will see that it is possible to enable a myriad of options, when creating a DB on SQL server.

This course aims firstly, to make you discover these options, and then to help you avoid the pitfalls when activating certain options.

So why watch this chapter ?

Changing the parallelism (MAXDOP) of a DB
Creating, configuring and modifying a DB (Creating a DB by attaching a file etc
)
Learn the utility and activation of the Query Store
Learn the use and activation of the BROKER service
The impact of changing the owner of a DB
What is TARGET RECOVERY Time?
And many other modules in this 2.5 hour course.

Why get into SQL administration?

SQL is one of the most actively sought after skills in the job market.
Administering SQL Server today is a full-time job.
In addition, SQL Server, by its simplicity, allows you to quickly gain skills on specific subjects.
If you are a Tech Lead, a developer, a future DBA, or any other profession that will tackle SQL, then this course is for you
I also made sure that the videos were no longer than 10 minutes, so that it wouldn’t be too boring

Look at the average of my other courses (4,4/5), and you will see that my courses are quality courses
Who this course is for:

Future Database Administrators (DBA)
Students who want to get started on SQL

Requirements

Installation of SQL server on his station + management studio (SSMS)

Last Updated 5/2021

Files:

SQL Server 2019 Administration SQL Server Part 2 [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 2 02 Practical cases on indexing
  • 003 Learn to consolidate your indexes!.mp4 (107.8 MB)
  • 010 set up_2.sql (17.3 KB)
  • 003 Learn to consolidate your indexes!.en.srt (10.4 KB)
  • 002 DĂ©mo _ Learn the INCLUDE clause on your index.en.srt (8.6 KB)
  • 012 DĂ©mo _ Filtered indexes and the cache plan.en.srt (8.3 KB)
  • 001 DĂ©mo _ Do you know the covering Index _.en.srt (8.2 KB)
  • 010 set up_1.sql (6.7 KB)
  • 014 DĂ©mo _ The index columnstore.en.srt (6.2 KB)
  • 013 How to choice your clustered index _.en.srt (6.0 KB)
  • 010 Consolidate index_UK.sql (5.7 KB)
  • 009 DĂ©mo _ Improve performance by deactivating the indexes.en.srt (5.2 KB)
  • 010 Avoid an index clustered on a NEWID column !.en.srt (5.2 KB)
  • 008 covering index UK.sql (2.8 KB)
  • 007 DĂ©mo _ What is the OVER indexing _.en.srt (4.8 KB)
  • 005 DĂ©mo _ Indexing and column order.en.srt (4.7 KB)
  • 015 DĂ©mo _ Let's a create a indexed view !.en.srt (4.6 KB)
  • 011 INDEx UNIQUE_UK.sql (2.1 KB)
  • 019 03 Filtered indexes and plan caching_UK.sql (4.4 KB)
  • 013 Duplicate Index_UK.sql (2.7 KB)
  • 012 9-order-of-columns-index.sql (4.1 KB)
  • 016 deactivation_index_UK.sql (3.9 KB)
  • 015 In search of the perfect index UK .sql (2.2 KB)
  • 017 GUID Performance_UK.sql (2.3 KB)
  • 018 Index+filtrĂ©_UK.sql (2.4 KB)
  • 008 DĂ©mo _ In search of the perfect index.en.srt (3.9 KB)
  • 011 DĂ©mo _ What is a filtered index _.en.srt (3.8 KB)
  • 009 01 Best uses for INCLUDE_UK.sql (3.7 KB)
  • 004 DĂ©mo _ Let's discover the UNIQUE index.en.srt (3.7 KB)
  • 021 colmunstore index_UK.sql (3.7 KB)
  • 014 2-OverIndexing_UK.sql (3.7 KB)
  • 006 DĂ©mo _ Be careful about the duplicate index !.en.srt (3.6 KB)
  • 022 Index view UK.sql (3.3 KB)
  • 002 DĂ©mo _ Learn the INCLUDE clause on your index.mp4 (88.8 MB)
  • 001 DĂ©mo _ Do you know the covering Index _.mp4 (86.9 MB)
  • 012 DĂ©mo _ Filtered indexes and the cache plan.mp4 (85.0 MB)
  • 014 DĂ©mo _ The index columnstore.mp4 (73.8 MB)
  • 010 Avoid an index clustered on a NEWID column !.mp4 (52.7 MB)
  • 005 DĂ©mo _ Indexing and column order.mp4 (52.6 MB)
  • 015 DĂ©mo _ Let's a create a indexed view !.mp4 (49.9 MB)
  • 009 DĂ©mo _ Improve performance by deactivating the indexes.mp4 (47.7 MB)
  • 008 DĂ©mo _ In search of the perfect index.mp4 (41.1 MB)
  • 004 DĂ©mo _ Let's discover the UNIQUE index.mp4 (41.0 MB)
  • 007 DĂ©mo _ What is the OVER indexing _.mp4 (40.7 MB)
  • 006 DĂ©mo _ Be careful about the duplicate index !.mp4 (39.8 MB)
  • 011 DĂ©mo _ What is a filtered index _.mp4 (38.4 MB)
  • 013 How to choice your clustered index _.mp4 (35.4 MB)
01 1st chapter _ The complete course on Indexes
  • 001 What is a index _.en.srt (2.4 KB)
  • 002 Setting up databases.en.srt (1.3 KB)
  • 002 setup database.sql (0.8 KB)
  • 003 DĂ©mo _ DĂ©finition and crĂ©ation of a clustered index.en.srt (9.4 KB)
  • 003 structure index_UK.sql (2.1 KB)
  • 004 structure index non clustered_UK.sql (2.1 KB)
  • 005 structure index clustered with no clustered_UK.sql (2.2 KB)
  • 007 DĂ©mo _ The table SCAN.en.srt (7.2 KB)
  • 006 SEEK_UK.sql (1.3 KB)
  • 007 Table scan_UK.sql (2.8 KB)
  • 004 DĂ©finition and crĂ©ation of a non clustered index.en.srt (5.7 KB)
  • 003 DĂ©mo _ DĂ©finition and crĂ©ation of a clustered index.mp4 (89.9 MB)
  • 005 Structure of the clustered index with a non clustered index.en.srt (4.4 KB)
  • 006 DĂ©mo _ The table SEEK.en.srt (4.3 KB)
  • 007 DĂ©mo _ The table SCAN.mp4 (74.6 MB)
  • 004 DĂ©finition and crĂ©ation of a non clustered index.mp4 (63.4 MB)
  • 005 Structure of the clustered index with a non clustered index.mp4 (42.3 MB)
  • 006 DĂ©mo _ The table SEEK.mp4 (36.9 MB)
  • 001 What is a index _.mp4 (20.1 MB)
  • 002 Setting up databases.mp4 (15.7 MB)
04 2nd chapter _ Configuring and modifying a database
  • 011 But what is CHECKPOINT anyway_.en.srt (10.0 KB)
  • 014 DĂ©mo_ What is the different database recovery model on your database _.en.srt (7.5 KB)
  • 003 DĂ©mo _ DĂ©finition and crĂ©ation of a filegroup.en.srt (7.1 KB)
  • 007 DĂ©mo _ SINGLE_USER et RESTRICTED_USER, READ_ONLY.en.srt (6.3 KB)
  • 020 DĂ©mo _ Change configurations limited to databases.en.srt (5.4 KB)
  • 022 DĂ©mo _ Why do not activate the DB_CHAINING on your BDD _.en.srt (5.2 KB)
  • 008 Create a database by attaching a file.en.srt (5.0 KB)
  • 002 DĂ©mo _ Define the files when creating the DB.en.srt (4.8 KB)
  • 004 DĂ©mo _ What is the Containment database _.en.srt (4.7 KB)
  • 012 Demo_ Changing the DB owner.en.srt (4.7 KB)
  • 015 DĂ©mo _ What is the MAXDOP on your database _.en.srt (3.5 KB)
  • 024 DĂ©mo _ Discover the accelerated recovery database on SQL Server 2019.en.srt (4.6 KB)
  • 013 DĂ©mo _ What is the TRUSTWORTHY option on a Database _.en.srt (4.5 KB)
  • 021 DĂ©mo _ What is the CHANGE TRACKING on your database _.en.srt (4.5 KB)
  • 025 DĂ©mo _ Be careful on your AUTOGROW settings !.en.srt (4.3 KB)
  • 023 DĂ©mo _ Let's discover the powerful Query Store !.en.srt (4.1 KB)
  • 017 DĂ©mo _ How to change your collation _.en.srt (3.9 KB)
  • 018 DĂ©mo_ Definition and activation of a broker.en.srt (3.9 KB)
  • 009 AUTO options on a database.en.srt (3.9 KB)
  • 006 DĂ©mo _ OFF LINE and EMERGENCY on a database.en.srt (3.8 KB)
  • 019 DĂ©mo _ SET ANSI_NULL and SET QUOTE IDENTIFIER.en.srt (3.8 KB)
  • 049 config limitĂ©e BDD_UK.sql (3.1 KB)
  • 005 DĂ©mo _ Explanation of the compatibility mode.en.srt (3.0 KB)
  • 053 Query3_UK.sql (0.3 KB)
  • 053 Query2_UK.sql (0.2 KB)
  • 016 DĂ©mo_ The CHECKSUM option on your database.en.srt (2.9 KB)
  • 001 What are we going to see in this course _.en.srt (1.8 KB)
  • 050 CHANGE TRACKING_UK.sql (2.8 KB)
  • 047 BROKER_UK.sql (2.8 KB)
  • 043 Different recovery models_UK.sql (2.5 KB)
  • 010 What is the TARGET RECOVERY Time_.en.srt (2.5 KB)
  • 036 RESTRICTED_USER et SINGLE_USERQuery 1_UK .sql (2.4 KB)
  • 051 DB_CHAINING_UK.sql (2.4 KB)
  • 040 CHECKPOINT_UK.sql (2.3 KB)
  • 053 Query1_UK.sql (2.2 KB)
  • 054 AUTOGROW_UK.sql (2.1 KB)
  • 048 ANSI_NULL_UK.sql (1.9 KB)
  • 032 Filegroup_UK.sql (1.7 KB)
  • 037 Creating a database by attaching a file_UK.sql (1.6 KB)
  • 038 Changing options to AUTO on a DB_UK.sql (1.4 KB)
  • 034 Compatibility mode on a database UK .sql (1.3 KB)
  • 031 Define the files when creating the DB_UK.sql (1.2 KB)
  • 045 checksum_UK.sql (1.1 KB)
  • 035 OFF LINE and EMERGENCY on a database_UK.sql (1.0 KB)
  • 033 Activation of the Contained database_UK.sql (1.0 KB)
  • 039 The TARGET_RECOVERY_TIME on a database._UK.sql (0.9 KB)
  • 052 QUERY STORE_UK.sql (0.7 KB)
  • 036 RESTRICTED_USER et SINGLE_USERQuery 2_UK .sql (0.1 KB)
  • 011 But what is CHECKPOINT anyway_.mp4 (77.5 MB)
  • 014 DĂ©mo_ What is the different database recovery model on your database _.mp4 (62.6 MB)
  • 020 DĂ©mo _ Change configurations limited to databases.mp4 (61.7 MB)
  • 007 DĂ©mo _ SINGLE_USER et RESTRICTED_USER, READ_ONLY.mp4 (56.5 MB)
  • 003 DĂ©mo _ DĂ©finition and crĂ©ation of a filegroup.mp4 (56.3 MB)
  • 008 Create a database by attaching a file.mp4 (50.0 MB)
  • 012 Demo_ Changing the DB owner.mp4 (49.5 MB)
  • 022 DĂ©mo _ Why do not activate the DB_CHAINING on your BDD _.mp4 (48.2 MB)
  • 002 DĂ©mo _ Define the files when creating the DB.mp4 (48.0 MB)
  • 025 DĂ©mo _ Be careful on your AUTOGROW settings !.mp4 (47.8 MB)
  • 004 DĂ©mo _ What is the Containment database _.mp4 (47.7 MB)
  • 024 DĂ©mo _ Discover the accelerated recovery database on SQL Server 2019.mp4 (46.2 MB)
  • 013 DĂ©mo _ What is the TRUSTWORTHY option on a Database _.mp4 (42.6 MB)
  • 021 DĂ©mo _ What is the CHANGE TRACKING on your database _.mp4 (41.9 MB)
  • 006 DĂ©mo _ OFF LINE and EMERGENCY on a database.mp4 (40.6 MB)
  • 009 AUTO options on a database.mp4 (39.6 MB)
  • 017 DĂ©mo _ How to change your collation _.mp4 (38.9 MB)
  • 019 DĂ©mo _ SET ANSI_NULL and SET QUOTE IDENTIFIER.mp4 (37.7 MB)
  • 023 DĂ©mo _ Let's discover the powerful Query Store !.mp4 (36.6 MB)
  • 005 DĂ©mo _ Explanation of the compatibility mode.mp4 (35.9 MB)
  • 015 DĂ©mo _ What is the MAXDOP on your database _.mp4 (32.0 MB)
  • 018 DĂ©mo_ Definition and activation of a broker.mp4 (27.2 MB)
  • 016 DĂ©mo_ The CHECKSUM option on your database.mp4 (24.6 MB)
  • 010 What is the TARGET RECOVERY Time_.mp4 (21.2 MB)
  • 001 What are we going to see in this course _.mp4 (19.4 MB)
  • 026 Conclusion on this chapter.mp4 (7.2 MB)
03 Fragmentation on indexes
  • 004 What is the FILLFACTOR_.en.srt (7.2 KB)
  • 005 Rebuild Index Vs REORGANIZE.en.srt (6.3 KB)
  • 002 Example of fragmentation.en.srt (5.2 KB)
  • 001 Why is fragmentation important_.en.srt (4.9 KB)
  • 006 REBUILD INDEX with the option ABORT_AFTER_WAIT.en.srt (4.3 KB)
  • 026 FILLFACTOR_UK.sql (4.1 KB)
  • 003 DĂ©mo _ Tracking page splits.en.srt (2.6 KB)
  • 007 Conclusion on the Index.en.srt (3.5 KB)
  • 024 FragmentationExample_UK.sql (2.2 KB)
  • 025 Tack split page UK.sql (2.2 KB)
  • 025 Tack split page UK_2.sql (1.3 KB)
  • 027 CreateFragmentation_UK.sql (1.5 KB)
  • 027 Rebuild VS REORGANIZE_UK.sql (2.1 KB)
  • 028 REBUILD avec ABORT AFTER WAIT2_UK.sql (0.2 KB)
  • 028 REBUILD avec ABORT AFTER WAIT_UK.sql (2.4 KB)
  • 005 Rebuild Index Vs REORGANIZE.mp4 (62.5 MB)
  • 004 What is the FILLFACTOR_.mp4 (59.4 MB)
  • 002 Example of fragmentation.mp4 (57.8 MB)
  • 006 REBUILD INDEX with the option ABORT_AFTER_WAIT.mp4 (36.6 MB)
  • 003 DĂ©mo _ Tracking page splits.mp4 (29.8 MB)
  • 001 Why is fragmentation important_.mp4 (26.5 MB)
  • 007 Conclusion on the Index.mp4 (20.3 MB)
  • TutsNode.com.txt (0.1 KB)
  • [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)
    • .pad
    • 0 (0.0 KB)
    • 1 (459.4 KB)
    • 2 (192.7 KB)
    • 3 (58.8 KB)
    • 4 (495.7 KB)
    • 5 (24.2 KB)
    • 6 (387.3 KB)
    • 7 (209.2 KB)
    • 8 (61.9 KB)
    • 9 (401.3 KB)
    • 10 (47.7 KB)
    • 11 (293.6 KB)
    • 12 (59.0 KB)
    • 13 (217.1 KB)
    • 14 (507.7 KB)
    • 15 (159.8 KB)
    • 16 (318.1 KB)
    • 17 (403.1 KB)
    • 18 (41.0 KB)
    • 19 (118.1 KB)
    • 20 (41.5 KB)
    • 21 (344.5 KB)
    • 22 (503.9 KB)
    • 23 (172.0 KB)
    • 24 (320.4 KB)
    • 25 (345.2 KB)
    • 26 (321.0 KB)
    • 27 (379.9 KB)
    • 28 (165.2 KB)
    • 29 (130.4 KB)
    • 30 (451.2 KB)
    • 31 (504.0 KB)
    • 32 (308.4 KB)
    • 33 (399.7 KB)
    • 34 (235.4 KB)
    • 35 (365.7 KB)
    • 36 (81.9 KB)
    • 37 (137.3 KB)
    • 38 (281.3 KB)
    • 39 (147.7 KB)
    • 40 (433.9 KB)
    • 41 (442.2 KB)
    • 42 (61.0 KB)
    • 43 (111.1 KB)
    • 44 (503.8 KB)
    • 45 (214.4 KB)
    • 46 (277.5 KB)
    • 47 (495.4 KB)
    • 48 (373.9 KB)
    • 49 (301.1 KB)
    • 50 (219.8 KB)
    • 51 (435.4 KB)
    • 52 (84.6 KB)
    • 53 (275.1 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://inferno.demonoid.pw:3391/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://torrent.gresille.org:80/announce
  • udp://glotorrents.pw:6969/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.pirateparty.gr:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://9.rarbg.to:2710/announce
  • udp://shadowshq.yi.org:6969/announce
  • udp://tracker.zer0day.to:1337/announce
REVERSE-PROXY 🔄 RP (success) | 1028ms | Saved: 11eigPBW... 📄 torrent 🕐 17 Jan 2026, 02:00:09 am IST ⏰ 11 Feb 2026, 02:00:09 am IST ✅ Valid for 24d 23h 🔄 Wait 10m