Hello there, User management is very important in our database systems. We prefer DBAs to create or use more windows authentication instead of sql authentication. …
Read More »Tag Archives: sql
SQL Server Cursor
Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML …
Read More »SQL 2017 In-Memory Table
Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this …
Read More »Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL
Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …
Read More »