Best online courses on SALE – All Courses $9.99

  • January 12, 2018

Bets online courses for only $9.99, the biggest source for web-based learning, is offering courses for $9.99 each to kick off your learning in the new year. Udemy’s main goal to improve living style with a focus on self-improvement. Kick Start your learning on Udemy today! Courses are normally esteemed at $200 or more. […]

Scripts SQL Server

SQL Query to check port number of SQL Server

  • February 9, 2023

We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value VARCHAR(100) DECLARE @RegKey_InstanceName nvarchar(500) DECLARE @RegKey nvarchar(500) SET @InstanceName=CONVERT(nVARCHAR,isnull(SERVERPROPERTY(‘INSTANCENAME’),’MSSQLSERVER’)) –For SQL Server 2000 if(SELECT Convert(varchar(1),(SERVERPROPERTY(‘ProductVersion’))))=8 BEGIN if @InstanceName=’MSSQLSERVER’ Begin SET @RegKey=’SOFTWARE\Microsoft\’+@InstanceName+’\MSSQLServer\SuperSocketNetLib\TCP\’ END ELSE BEGIN SET @RegKey=’SOFTWARE\Microsoft\Microsoft SQL Server\’+@InstanceName+’\MSSQLServer\SuperSocketNetLib\TCP\’ END EXECUTE xp_regread @rootkey = ‘HKEY_LOCAL_MACHINE’, @key […]

Oracle Cloud Database Service Oracle Cloud Computing

All About Oracle Database Cloud Offerings and Features – 2023

  • January 15, 2023

Oracle Database Cloud Offerings Oracle Database is a widely used relational database management system (RDBMS) that is available in various cloud-based offerings and on-premises versions. Oracle Cloud Infrastructure (OCI) provides several options for running Oracle Database in the cloud, including: Autonomous Database: A fully managed, self-driving database service that eliminates the need for manual administration […]

SQL Server AlwaysON Interview Question Always On SQL Server

SQL Server DBA Interview Questions Answers – Always On availability group

  • January 14, 2023

Availability Groups is a feature in SQL Server that allows you to create a group of read-write and read-only replicas of a primary database to provide high availability and disaster recovery. The feature was first introduced in SQL Server 2012 and since then it has been improved and enhanced in later versions. Availability Groups allow […]

Cloud Computing

Top 5 Cloud Computing Certifications of 2018

  • February 6, 2018

Usage of Data has led to companies plan, strategize and execute even more efficiently than before. With an increase in the trend of getting businesses online and moving towards economies of scale, the need of data has increased on the parallel trend.As there is an increase in need of data, it has been compensated with […]

SQL Server Backup\Restore

How to Perform database restore with Database Encryption

Database encryption is the process of changing the information inside database into some ciphertext using encryption keys and appropriate algorithm. This process makes sure even if the hackers get through the firewall and bypass the security, they would require encryption keys to decrypt the information. Database encryption guarantees information security while embeddings or recovering information […]

SQL Server Encryption SQL Server Standards

How to use SQL Server Encryption to Secure data?

SQL Server Encryption Implementation What is Data Sensitivity? Data protection and security is one of the most important aspects of a database design nowadays. Virtually no database today can run without having some kind of sensitive information which has to be protected.This sensitive information can be personal information like PAN card details, SSN numbers, bank […]