263 подписчиков
63 видео
14.Custom Color Coding in SSMS Status Bar
02.SQL Server Database Mirroring
42.Password Encryption and Decryption in SQL Server
56.Network-related or instance-specific error
48.Find and Delete duplicates Records from a table in SQL Server
09.How to Compare Two Databases of SQL Server using Visual studio
03.Install SQL Server 2019 and SSMS in Windows 10
32.Create user and give specific database permissions to the user in SSMS
01. How to Setup and send Database Mail in SQL Server 2019 using Gmail Account
13.How to Attach and Detach Databases in SQL Server
30.Change database default locations in SSMS
62.SQL Server OFFSET FETCH
37.Temporary Table in SQL Server
29.Create a New Schema and Change Schema Name Of Table In SQL
54.Scalar Value Function in SQL Server
20.Upgrade Microsoft SQL Server 2017 to 2019 Developer Edition with Step by Step
49.Backup and Restore Database in SQL Server
18.Generate script with Object Explorer Details
16. Backup to multiple locations at the same time (Mirror Backups)
58.Synonym in SQL Server
06.Maintenance plan for Automated Backups and old Backup Cleanup
41.IDENT_CURRENT vs @@IDENTITY vs SCOPE_IDENTITY in SQL Server .
57.EXCEPT / INTERSECT / UNION / UNION ALL Operators in SQL Server
25.Collation in SQL Server 2019
04.Configuring Linked Servers in MS SQL Servers
35.DELETE CASCADE In SQL Server
63.Static Pivot in SQL Server
39.Row_Number() with Partition by in SQL Server
36.UPDATE CASCADE in SQL Server
27.With No Lock in SQL Server
28.Difference between varchar and nvarchar in SQL server
12.Configure SQL Server Log Shipping
05.Configure Transactional Replication in SQL Server 2019 Step by Step
59.Change default databae file and backup Path in SQL Server
19.How to Find which user dropped a Table and database in SQL Server Using SSMS
40.RANK, DENSE_RANK and NTILE in SQL Server
55.Exception Handling in SQL Server
53. Enable and Refresh IntelliSense in SQL Server Management Studio
47.Union and Union all
52.Modify multiple lines at once using vertical region select
45.DBCC CHECKIDENT RESEED
60.Computed Column in SQL Server
46.Create Missing Index From Execution Plan
51.How to Uninstall an Instance of SQL Server
17.Striping SQL Server Database Backups
15.Execute a large SQL Script from Command line
31.Encrypt the stored procedure in sql server
38.Table variable in SQL Server
11.Rename Logical and Physical file names in SQL Server 2019
10. How to import/export data to SQL Server 2019 using the SQL Server Import and Export Wizard
