-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Overview

I'm a SQL Server DBA. I love to explore my knowledge about SQL Server database and have experience with database administration (installing, configuring, maintenance, transaction log shipping, replication, database mirroring etc) also I like to write blogs about these technologies.

How to Run DBCC CHECKDB to Check SQL Database Integrity

Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is supported in databases that contain memory-optimized tables but the validation is only supported in disk-based tables. The DBCC repair option is unavailable in memory-optimized tables and therefore,… Read more

0 comments, 68 reads

Posted in SQL Server Overview on 17 January 2018

Steps to Configure SQL Server to Listen On A Specific TCP Port

Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more

0 comments, 224 reads

Posted in SQL Server Overview on 15 January 2018

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It facilitates the function of data storing and retrieving by the applications which either run on the same or different platforms. The dominant reason behind the deployment of SQL Server on… Read more

0 comments, 980 reads

Posted in SQL Server Overview on 13 January 2018