MSSQL

  Utility Control Point works in an integrated manner within SQL Server and is used to monitor SQL Server. I can say that it is …

  When you want to monitor “SQL Server” servers with a monitoring tool, you must grant the user who will monitor access to WMI. To …

You need to know about Primary Key and Foreign key before you can read this article. You can read the article “What is Primary Key …

  Before reading this article, I suggest you read my article “Identitiy Insert On SQL Server” to see what the identitiy property is in the …

  When we need to transfer data from SQL Server or transfer data to SQL Server, we can use the import export methods in SQL …

  To understand this article, we need to know the following concepts. Page: It is the most basic unit in SQL Server storage. Each Page …

  If your computer is not connected to the domain, you can get this error when you try to connect to a SQL Server in …

  The concept of normalization was created by Edgar F. Codd, the founder of the relational database model. During the design of the tables, we …

You may encounter this error when taking a backup to a NFS Mounted disk. You will see the error through SQL Server as follows. Msg …

  In some cases, you may need to connect to the sql server via SSMS with a different domain account(for windows authentication). You connect to …