Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
To understand this article, we need to know the following concepts. Page: It is the most basic unit in SQL Server storage. Each Page …
Read More »
MSSQL
SSPI handshake failed with error code 0x8009030c and The login is from an untrusted domain and cannot be used with Windows authentication
If your computer is not connected to the domain, you can get this error when you try to connect to a SQL Server in …
Read More »Normalization Concept
The concept of normalization was created by Edgar F. Codd, the founder of the relational database model. During the design of the tables, we …
Read More » The operating system returned the error ’59(An unexpected network error occurred.)’ while attempting ‘FlushFileBuffers’ on ‘myDB.BAK’
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 …
Read More »How To Connect SQL Server via SSMS(SQL Server Managemet Studio) With Different Domain Account
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 …
Read More »Policy-Based Management(Special Character Control in Database Names-Database Facet)
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »Cannot open backup device ”. Operating system error 3(The system cannot find the path specified.)
You have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …
Read More »How To Restore Encrypted Backup To Another Instance On SQL Server
First you should restore your certificate to this instance. You can restore your certificate with the help of following script. You must write the …
Read More »Encrypted Backup On SQL Server
You can encrypt your backups with SQL Server’s own encryption method in order to avoid the risk of unauthorized access to the backup. You …
Read More »The Select permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’
When you see an error, such as in the following screenshot, you may consider why your database is trying to access a hidden system …
Read More »