Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When creating a SQL Login, you can select the Enforce Password Policy option as described in my article “How To Create a Login On …
Read More »MSSQL
Security Policy for SQL Server(secpol.msc)
After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows for the performance of SQL …
Read More »Database Mirroring On SQL Server
Microsoft has announced that it will remove Database Mirroring in the future because it has developed the Always On technology. But since SQL Server …
Read More »SQL Server Replication Types
Replication is one of the High Availability solutions. But it is not usually used as a High Availability solution. We would use SQL Server Always …
Read More »SQL Server Storage Concepts (Page, Extents, GAM, SGAM, PFS, IAM, BCM, DCM)
Page is the most basic unit of SQL Server on storage. Each page consists of 8 KB. The mdf or ndf files that allocate …
Read More »SQL Server Service Is Not Starting Due to Tempdb
SQL Server re-creates tempdb on predefined folders each time sql server service starts. In the article “How To Move The Tempdb Database To Another …
Read More »What is Mounted Drive and How to Create It
We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …
Read More »How To Move The Tempdb Database To Another Disk On SQL Server
I explained how to change the disks of a normal database in the article “How To Change The Disk Of Database Files On SQL …
Read More »SQL Server Startup Parameters
With SQL Server Startup Parameters, the location of certain files in the startup phase of the SQL Server service, and some conditions in the …
Read More »DAC(Dedicated Administrator Connection) On SQL Server
Sometimes SQL Server becomes inaccessible and DBA cannot even intervene. In such cases, there is a back door so that DBAs can find and …
Read More »