IBM 22nd Bangalore

Migration procedure & issues
Timely fashion error in sql server

Service pack issues & how to resolve & latest service pack info & roll back procedure
Point in time recovery
Log shipping 2ndary bring to online
Replication issues
2016 to 2014 database migration
Always on configuration & issues

Kennametal interview

 

1. Difference’s between delete & truncate
2. purpose of login & contained database & login and user diff
3. how to configure the log-shipping
4. why system database are in full recovery mode
5. Mirroring procedure
6. Difference between FCI & always on
7. Point in time recovery
8. importance of resource database
9. Migration procedure

 

Merck blue jean interaction 10th June 2019

1. How to migrate SQL server 2005 to 2017 (DMA)
2. SQL query ruining slowly
3.  How can we restrict SA password,
4. Azure backup & restore service vault & bakpac files
5. Always on configuration & cluster
6. always on new features in SQL server 2017

 

 

Enable/Disable SSL/TLS versions via Registry Editor

 

SecureAuth version affected: All

Description:

SSL/TLS may need to be enabled/disabled due to environmental factors or restrictions throughout any given time through the server’s lifespan.

Cause:

TLS versions may be turned off due to security server hardening or cipher/protocol lockdowns.

Resolution:

Enabled or disable TLS/SSL as needed be.

 

1. Open up regedit.exe and navigate to the key location provided:
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols
2. Once here, expand Protocols, there will be the following:
3. To disable or enable a protocol, expand Server or Client, whichever you want to change and adjust the value to the following:Binary:
   0 – off
   1 – on

   Hexadecimal:
   0x00000000 – off
   0xffffffff – on (4294967295)

4. Once the respective changes are made, restart the server for the registry to propagate.