As SQL Server DBAs, we need to be aware of what is occurring within the database server and outside the database server to ensure SQL Server is running without issue. One of the tasks is to monitor free space on the drives where SQL Server files reside and in this tutorial, we look ...
SQL Server allows database administrators (DBAs) to configure and optimize resource usage by offering multiple table storage options and control over the distribution of storage, CPU, and memory. Database servers are a crucial part of your business and need to have consistently high availability. W...
Active Directory Error 0x51 occurred when trying to check the suitability of server '<mains.tabanis.net>'. Error: 'Active directory response: The LDAP server is unavailable'. Active Directory Error 0x51 occurred when trying to check the suitability of server '<servername>'. Error: 'Active di...
One crucial aspect of all databases is the transaction log. The transaction log is used to write all transactions prior to committing the data to the data file. In some circumstances the transaction logs can get quite large and not knowing what is in the transaction log or how much space is...
Hosting: Google Cloud Sql EDIT 1: I deleted 90% of rows from table then I ran OPTIMIZE TABLEtable_namebut it has reduced only 4GB of disk space and it is not reclaiming the free disk space. EDIT 2I even deleted my database and created new DB and table but MySql server still showing...
public class SampleServerSyncProvider : DbServerSyncProvider { public SampleServerSyncProvider() { //Create a connection to the sample server database. Utility util = new Utility(); SqlConnection serverConn = new SqlConnection(util.ServerConnString); this.Connection = serverConn; //Create a comm...
It may be tempting to set this to “all” to capture every SQL statement running on the server, but this may not always be a good idea in reality. On a busy production instance logging thousands of SELECT per minutes, this can generate a huge amount of logging infor...
!> in c# . Check is object null - What are the options? .Net 4 FileLoadException permissions problem With windows service .NET code to extract data from an excel sheet and create a text file having a specific format .Net Core 3.0 Console App. Microsoft.Data.SQLClient is not supported ...
How to add a column with a default value to an existing table in SQL Server? 1611 What are the options for storing hierarchical data in a relational database? 2187 How to check if a column exists in a SQL Server table 2769 How can I prevent SQL injection in PHP? 1962 How to quer...
DATA\XXX.ldf’. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can ...