If you get the error “This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED”, it means that you are probably using different endpoints on …
Read More »
If you get the error “This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED”, it means that you are probably using different endpoints on …
Read More »This article contains script to find deleted objects in sql server. It happened to every database administrator. Application developers or your supervisors may ask you to find out who deleted …
Read More »What is Page Splits in SQL Server? As it is known, there are 8KB areas called Page in the file base of SQL Server and 8 of them (8 X …
Read More »Sometimes you may need the transfer table from SQL Server to HDFS. In this article we will examine that but first you may want to know more about Sqoop. What …
Read More »SQL Server 2019 AlwaysOn Availability Group on Docker Container Part 1 SQL Server started to support Linux with the 2016 version. Along with the 2017 and 2019 versions, it started …
Read More »We will install SQL Server 2019 on Ubuntu 18.04 in this article. Our Server Resource Information: CPU : 4 RAM : 16 Disk : 80 gb Installation Steps: Step 1: …
Read More »Conversion operations in datetime data types often cause poor performance but they are always the ones that are overlooked. We will examine the Cast and Convert Performance in SQL Server …
Read More »In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS and click properties. You will see general information on the …
Read More »With SQL Server 2017, a new dmv named sys.dm_tran_version_store_space_usage was announced to find out which database uses how much space due to row versioning in tempdb. Especially if you are …
Read More »Tables created with SELECT INTO prior to SQL Server 2017 could not be created on a filegroup other than the PRIMARY filegroup. Now we can create the tables we created …
Read More »