During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
MySQL – FOUND_ROWS() Function for Total Number of Rows Affected
In SQL Server you get the number of rows affected with @@ROWCOUNT. In MySQL, you can find the total number of rows with FOUND_ROWS().
SQL SERVER – Backup Randomly Failing with Error 112 (There is not enough space on the disk.)
Solving puzzle is something everyone would love. IHere is the puzzle which they wanted me to solve for Error 112.
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
Is your application ready for In-Memory tables? A client upgrading from SQL Server 2005 asked me, so here is the InMemory OLTP Migration Assistant script.
SQL SERVER – Identifying Database Default Locations for Data and Logs
Going back to basics can still teach you something new. Here are ways to identify the Database Default Locations for data and log files in SQL Server.
SQL SERVER – Huge Transaction Log in Snapshot Replication!
The log kept growing and sys.databases showed REPLICATION as the reuse wait. Here is how I found why the transaction log in snapshot replication was not reused.
MySQL – Different Methods to Know Current User
Why check the current user in MySQL? For audits, permissions and custom logic. Here are the methods, from user() and current_user() to mysql.user.