Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We are able to create Scalar User-Defined Function in SQL Server 2016 for Memory Optimized tables. For In Memory OLTP and Memory Optimized Tables, I …
Read More »
MSSQL
Generate In-Memory OLTP Migration Checklists(Objects in the Database is practicable to In-Memory OLTP?)
In this article, I will share What is Generate In-Memory OLTP Migration Checklists. If you want to learn What is In Memory OLTP and In-Memory …
Read More »
SQL Server Database Administrator’s Roadmap
In this article, I will describe the tasks and responsibilities of “SQL Server Database Administrator“. I will link to articles about how each item can …
Read More »
UpdateUptimeRegKey: Operating system error 5(Access is denied.)
This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run …
Read More »
Auto Update Statistics in Memory Optimized Tables
With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing …
Read More »
Error When Opening SQL Server 2017 Configuration Manager([0x8004100e])
When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is solved when I follow the …
Read More »
legacy cardinality estimation is not a valid database scoped configuration
When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties, we receive this error. To …
Read More »
Database Scoped Configurations in SQL Server 2016 and SQL Server 2017
We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with Database Scoped Configurations feature of …
Read More »
DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS
What is DBCC FREEPROCCACHE in SQL Server We can reset all plans in the plan cache with DBCC FREEPROCCACHE. Thus, each stored procedure has to …
Read More »
DBCC clondatabase in SQL Server
What is dbcc clondatabase in SQL Server DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database …
Read More »