Right to Learn @BK
Right to Learn @BK
  • 100
  • 1 378 630

Відео

Transparent Data Encryption in SQL Server | TDE in SQL Server | Encryption in SQL | Ms SQLTransparent Data Encryption in SQL Server | TDE in SQL Server | Encryption in SQL | Ms SQL
Transparent Data Encryption in SQL Server | TDE in SQL Server | Encryption in SQL | Ms SQL
Переглядів 1,2 тис.2 місяці тому
Transparent Data Encryption (TDE) is a special case of encryption using a symmetric key. TDE encrypts entire database using a symmetric key called the database encryption key - DEK. TDE does real-time I/O encryption and decryption of data and log files. This encryption is known as encrypting data at rest. Introduced with SQL server 2008. TDE isn't available for system databases. It can't be use...
Contained database in SQL server | How to create a contained database | Ms SQLContained database in SQL server | How to create a contained database | Ms SQL
Contained database in SQL server | How to create a contained database | Ms SQL
Переглядів 1,6 тис.6 місяців тому
Contained databases feature is available at instance level and it is not enabled by default. If we want to create a new database as a contained database, we have to make containment type as Partial in the Options page. Contained database feature provides two containment modes: None - By default each database has its mode set as NONE. This means there is no contained database feature being used....
Resource database in SQL server | 5th System database in SQL server | SQL interview Q&A | Ms SQLResource database in SQL server | 5th System database in SQL server | SQL interview Q&A | Ms SQL
Resource database in SQL server | 5th System database in SQL server | SQL interview Q&A | Ms SQL
Переглядів 2,3 тис.10 місяців тому
The Resource database is a read-only database that contains all the system objects that are included with SQL Server. The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. Changing the location of the resource database is not supported or recommended. Scripts used in this video: SELECT * FROM sys.sysaltfiles WHERE DBID = 32767 To determine the...
How to Capture deadlock in SQL server | Trace deadlock | SQL interview Q&A | Ms SQLHow to Capture deadlock in SQL server | Trace deadlock | SQL interview Q&A | Ms SQL
How to Capture deadlock in SQL server | Trace deadlock | SQL interview Q&A | Ms SQL
Переглядів 7 тис.Рік тому
This video focus on how to capture a deadlock in SQL server. If you are a beginner then this video is for you. Please refer below video reference links that are discussed in this video. What is a deadlock and how it occurs ua-cam.com/video/f66ehM4Gn84/v-deo.html How SQL server choses a deadlock victim ua-cam.com/video/junA5eB8Ifs/v-deo.html T-SQL script to find How many deadlock occured since s...
How SQL server choose a Deadlock Victim | Deadlock Priority in SQL Server | SQL interview Q&AHow SQL server choose a Deadlock Victim | Deadlock Priority in SQL Server | SQL interview Q&A
How SQL server choose a Deadlock Victim | Deadlock Priority in SQL Server | SQL interview Q&A
Переглядів 4 тис.Рік тому
When an instance of SQL Server detects that two sessions are deadlocked, it resolves the deadlock by choosing one of the sessions as a deadlock victim and roll back its transaction (error 1205) and allows other session to move forward. By default, SQL server will choose the least expensive transaction as deadlock victim and roll back its transaction. Least expensive transaction is the one that ...
What is a Deadlock in SQL Server | How a deadlock occur in SQL Server with DEMO | SQL Interview Q&AWhat is a Deadlock in SQL Server | How a deadlock occur in SQL Server with DEMO | SQL Interview Q&A
What is a Deadlock in SQL Server | How a deadlock occur in SQL Server with DEMO | SQL Interview Q&A
Переглядів 6 тис.Рік тому
Deadlock is a condition where two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. SQL Server database engine comes with a deadlock monitor thread that will periodically check for deadlock situations and it will choose one of the process as a deadlock victim and rollback that process. After it rollba...
What is a Blocking in SQL Server | Find blocking and troubleshooting steps | SQL Interview Q&AWhat is a Blocking in SQL Server | Find blocking and troubleshooting steps | SQL Interview Q&A
What is a Blocking in SQL Server | Find blocking and troubleshooting steps | SQL Interview Q&A
Переглядів 16 тис.Рік тому
Blocking is completely normal in SQL Server. You will typically be unaware of the many short blocks happening all the time. Sometimes, blocks take longer than expected to resolve. Blocks of longer duration can create chains, where a blocked process blocks additional processes and so on. This type of blocking scenario is problematic. The concern is not with blocking, but rather excessive blockin...
What are the different locking modes present in SQL | SQL Server Locking modes | SQL interview Q&AWhat are the different locking modes present in SQL | SQL Server Locking modes | SQL interview Q&A
What are the different locking modes present in SQL | SQL Server Locking modes | SQL interview Q&A
Переглядів 12 тис.Рік тому
While objects are locked, SQL Server will prevent other transactions from making any change of data stored in objects affected by the imposed lock. Once the lock is released by committing the changes or by rolling back changes to initial state, other transactions will be allowed to make required data changes. In this video, you will learn about the different types of locks in a SQL server which...
Locking Resources in SQL Server | Lock type | SQL interview Q&ALocking Resources in SQL Server | Lock type | SQL interview Q&A
Locking Resources in SQL Server | Lock type | SQL interview Q&A
Переглядів 6 тис.Рік тому
When a transaction imposes the lock on an object, all other transactions that require the access to that object will be forced to wait until the lock is released and that wait will be registered with the adequate wait type. SQL Server Database Engine can lock the following resources: RID: Used to lock a single row within a table. Key: Row lock within an index. It means primary key, Candidate Ke...
Locking in SQL Server | with DEMO | Why do we need Locking ? | SQL interview Q&ALocking in SQL Server | with DEMO | Why do we need Locking ? | SQL interview Q&A
Locking in SQL Server | with DEMO | Why do we need Locking ? | SQL interview Q&A
Переглядів 14 тис.Рік тому
Locking is the way that SQL Server manages transaction concurrency and it ensures the integrity of the data in the database, as it forces every SQL Server transaction to pass the ACID test. Contents in this video: 1. What is Locking in SQL server 2. Locking hierarchy 3. Why do we need locking 4. Demo on how Locking occurs 5. Locking Resources and Modes of Locking ACID properties in SQL Server u...
ACID properties in SQL server | Atomicity, Consistency, Isolation and Durability | SQL interview Q&AACID properties in SQL server | Atomicity, Consistency, Isolation and Durability | SQL interview Q&A
ACID properties in SQL server | Atomicity, Consistency, Isolation and Durability | SQL interview Q&A
Переглядів 19 тис.Рік тому
A transaction in SQL Server is a group of SQL statements that are treated as a single unit and they are executed by applying the principle “do everything or do nothing” The acronym ACID was created by Andreas Reuter and Theo Harder in the year 1983, however, Jim Gray had already defined these properties in the late 1970’s. Most of the popular databases such as SQL Server, Oracle, MySQL, Postgre...
Log Shipping Tables | Monitor Log shipping using MSDB tables | SQL interview questions | Ms SQLLog Shipping Tables | Monitor Log shipping using MSDB tables | SQL interview questions | Ms SQL
Log Shipping Tables | Monitor Log shipping using MSDB tables | SQL interview questions | Ms SQL
Переглядів 4,1 тис.Рік тому
In this video i have explained about Log shipping tables and how to monitor Log shipping using these tables. select * from msdb.dbo.log_shipping_primary_secondaries To check for secondary server instance select * from msdb.dbo.log_shipping_primary_databases select * from log_shipping_monitor_primary Look for last backup file select * from msdb.dbo.log_shipping_monitor_error_detail Showup detail...
What is a WRK file in SQL server | .wrk file in Log shipping | SQL interview questions | SQL DBAWhat is a WRK file in SQL server | .wrk file in Log shipping | SQL interview questions | SQL DBA
What is a WRK file in SQL server | .wrk file in Log shipping | SQL interview questions | SQL DBA
Переглядів 3,8 тис.Рік тому
Have you ever seen a file with extension .wrk in the log shipping copy folder ?? This video explains what is a WRK file that exists in SQL server during Log Shipping configuration, its purpose\use. Explained with a DEMO. Please do watch. Twin questions .WRK file & .TUF file TUF file : ua-cam.com/video/6zI7fqumdVw/v-deo.html Log Shipping : ua-cam.com/video/S1SaSJZtYzA/v-deo.html
What is a TUF file in SQL server | .tuf file in Log shipping | SQL Interview questions | Ms SQLWhat is a TUF file in SQL server | .tuf file in Log shipping | SQL Interview questions | Ms SQL
What is a TUF file in SQL server | .tuf file in Log shipping | SQL Interview questions | Ms SQL
Переглядів 8 тис.Рік тому
What is a .tuf file in SQL server ?? ::-This is one of the frequently asked interview question and it plays a important role in one of the database high availability and disaster recovery i.e., Log shipping. Transaction Undo File - contains transactions/modifications that were not committed on the source database but were in progress when the transaction log was backed up AND when the log was r...
How to delete duplicate rows in a SQL table | Delete and Avoid duplicate entries in SQL | Ms SQLHow to delete duplicate rows in a SQL table | Delete and Avoid duplicate entries in SQL | Ms SQL
How to delete duplicate rows in a SQL table | Delete and Avoid duplicate entries in SQL | Ms SQL
Переглядів 7 тис.2 роки тому
One or more rows that have identical or same data values are considered to be Duplicate rows. Watch this video to delete duplicate entries in your SQL table and also how to aviod duplicate entries in a table Below are the scripts that are used in this video. create table Table1(id int,name varchar(10)) insert into Table1 values ('101','Prasad') insert into Table1 values ('101','Prasad') insert ...

КОМЕНТАРІ

  • @Ganeshay-996
    @Ganeshay-996 19 годин тому

    how to vm create and configuration with ms server

  • @aniketshelke9201
    @aniketshelke9201 7 днів тому

    Thank you bro ❤

  • @harithad1757
    @harithad1757 8 днів тому

    need session on performance tuning and also how to identify cpu and memory issues

  • @davidnunoo804
    @davidnunoo804 9 днів тому

    Great video! your videos are so detailed and well explained with practical examples.

  • @harithad1757
    @harithad1757 10 днів тому

    Amazing

  • @Ganeshay-996
    @Ganeshay-996 11 днів тому

    how to connect network to linux vm if want sharing like linux

  • @Ganeshay-996
    @Ganeshay-996 11 днів тому

    good job brother and more vdo plz update every topic

  • @michelleurbano0809
    @michelleurbano0809 13 днів тому

    Thank you for the vid. Very helpful but is the modify file to a new location also applies to the file inside in a filegroup? Or you need to modify filegroup syntax then just change the filepath of the data file there? Or is there any extra step? When changing the location of the database file inside a filegroup

  • @AmanuelIctsolution-ro1oc
    @AmanuelIctsolution-ro1oc 15 днів тому

    Thanks

  • @shivaselvan8858
    @shivaselvan8858 16 днів тому

    Excellent work! Keep rocking!

  • @meghana4284
    @meghana4284 17 днів тому

    You explained the concepts very clearly. All your videos are very informative

  • @sagarkoltharkar2656
    @sagarkoltharkar2656 19 днів тому

    Excellent

  • @Ganeshay-996
    @Ganeshay-996 20 днів тому

    but getting error i am unable to access another instance

  • @satishchowdary1390
    @satishchowdary1390 21 день тому

    Good way of explanation very useful

  • @satishchowdary1390
    @satishchowdary1390 21 день тому

    Great learning

  • @azlannohara1208
    @azlannohara1208 23 дні тому

    Can we export with the filename follow the current date?

  • @murghachronicles715
    @murghachronicles715 26 днів тому

    How did you create Windows Failover Cluster? Is this a separate machine or is this some kind of feature which needs to be enabled on both SQL Server nodes?

  • @bennyrokkam8753
    @bennyrokkam8753 Місяць тому

    THANKS FOR THE VIDEOS

  • @harishsagar344
    @harishsagar344 Місяць тому

    Thanks for keeping video it’s very Detailed

  • @egorkosenkov4476
    @egorkosenkov4476 Місяць тому

    Thank you very much!!! Trofimovich is going to be satisfied =))))))))))))))))

  • @SudarshanReddy897
    @SudarshanReddy897 Місяць тому

    great video..have one doubt that if we want to failover multiple databases just say like 20db's, how can we do at a time?

  • @anthonycurreri1543
    @anthonycurreri1543 Місяць тому

    Good video, one correction, The Standard Edition of SQL server has basic availability groups included. That limits you to 1 database per group but you can have an unlimited number of groups.

  • @srimahesh5352
    @srimahesh5352 Місяць тому

    Nice explanation but while we tired I got an error

  • @aakashlko92
    @aakashlko92 Місяць тому

    Can you please explain the step of creating master key with strong password? What is exactly this step do at backend of architecture?

  • @seliii3.__
    @seliii3.__ Місяць тому

    Thank U <3

  • @yadavajitkumarashokkumar3302
    @yadavajitkumarashokkumar3302 Місяць тому

    Hii sir can u I aapka distribution database se error hatane wala vidoe dekh ke to aaj mera error solve ho gya because aaj subh se mai replication ka error leke baitha tha my manager totally fired on me but your video are save me bus ek problem hai uska bhi video bna dijiye please mera next month server migration hai aur mera subscriber database new server per move hone ja rha hai to jab hum new server per subscriber ka db restore krenge n publisher se replication bnayenge to wo publisher ka data replicate kr dega jabki publisher me mera do not delete statement hai to sara data subscriber per rhta hai aur agr migration ke time replication break krke phir se banaunga to table ka data delete kr dega to phir se publisher ka data hi rhega I want video my subscriber data are still in the table replicate only thoes data which have new on publisher table n not in subscriber

  • @gouthami_pittala
    @gouthami_pittala Місяць тому

    How to get to know travel is on or off

  • @tusharkaushik79
    @tusharkaushik79 Місяць тому

    Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-05-11T16:20:45). Exception Message: Could not connect to mail server. (No such host is known).

  • @tahirhanyildizoglu1461
    @tahirhanyildizoglu1461 Місяць тому

    thank you for the practical information

  • @cvaz000
    @cvaz000 Місяць тому

    Thank you! Helped me a lot!

  • @HiranthaIddamalgoda
    @HiranthaIddamalgoda Місяць тому

    Nice. Well explained. Thank you

  • @RohitKumar-cg9ns
    @RohitKumar-cg9ns Місяць тому

    Plz tell how to import excel file qsl severe

  • @oyegolii5039
    @oyegolii5039 Місяць тому

    how to check which name is avilable in window level for creating a new login

  • @naveen_nanda
    @naveen_nanda Місяць тому

    Big fan anna.... Big fan💗💗💗

  • @richardwaldron1684
    @richardwaldron1684 2 місяці тому

    Excellent demo, I finally understand their purpose and function, including how ti do a restore. Thanks for sharing

  • @saikumarkakarla9924
    @saikumarkakarla9924 2 місяці тому

    Hi bro How are you. Thanks for come back after long days🤝. Very thanks for this concept . Very easy to understood.

  • @BN-ys1sj
    @BN-ys1sj 2 місяці тому

    Hi sir your explanations are very good. I appreciate you covering everything that a person would use.

  • @michelleurbano0809
    @michelleurbano0809 2 місяці тому

    Hi , great video with precise elaboration! In the first solution, you have deleted the record from publisher after deleting the record from subscriber because the publisher wont recognize the deletion from the subscriber thats why you have to re-add it on the publisher. Am I getting it right?

  • @skyp6051
    @skyp6051 2 місяці тому

    Thank you sir

  • @learncodingintamil-python8774
    @learncodingintamil-python8774 2 місяці тому

    Hi bro , i have configured a named instance with all tcp connection enabled with port number , however i cant able to connect to the instance in remote machine , i canable to connect in local machine. Why?

  • @ChromaGraph
    @ChromaGraph 2 місяці тому

    Explanation was very clear and anyone with limited knowledge can understand and perform the task, I am not much in to DB however over customer has no knowledge about it and got to help, with this video my job is done, thanks Bro.

  • @sqltechzpestechz7053
    @sqltechzpestechz7053 2 місяці тому

    I have one doubt. For ex primary db gets deleted and u restore the secondary db with recovery then after that how to bring the copy db to the primary from where its gets deleted

  • @Panahon_
    @Panahon_ 2 місяці тому

    HOW ABOUT IN SQLWORKBENCH OR MYSQL

  • @rajendraprasad9040
    @rajendraprasad9040 2 місяці тому

    Excellent vedio to easy understand

  • @smart-vh4xs
    @smart-vh4xs 2 місяці тому

    Hi bro , I have one doubt Weekly Full backup at every Sunday 12pm Remaining all days differential back up Monday to Saturday Every 30 minutes log back up At the Sunday full backup was crashed how can we recovery the point in time recovery please let me i have faced in this interview at yesterday

  • @anandprakashtiwari1457
    @anandprakashtiwari1457 2 місяці тому

    Is it clustered setup

  • @izztqhrmanov820
    @izztqhrmanov820 2 місяці тому

    thanks bro

  • @samkuwait7839
    @samkuwait7839 2 місяці тому

    Conflict concept explained very well and excellent thanks bro..😎

  • @toprerishi
    @toprerishi 2 місяці тому

    Is Mirror possible for SQL Express?

  • @jayanthKamineni
    @jayanthKamineni 2 місяці тому

    Nic video bhai, love from Pakistan ❤❤❤