How to reset password for all users in WordPress site within MYSQL databases

A typical installation of WordPress usually has MySQL database as the backend, recently I found a need to reset the password for multiple users in one go. Here is how it was achieved. First install MYSQL Workbench on the required machine. MySQL Workbench can be downloaded here. Identify the database and the connection string details…

SQL 2019:- sp_estimate_data_compression_savings

This procedure allows us to estimate the potential space savings on a table before we apply a compression algorithm. It’s not exactly a new feature of SQL 2019 because it was also available in SQL 2017 however it now provides information on Columnstore indexes as well. The reason why this is important is because we…

SQL 2019:- sys.dm_db_page_info

So we have a new DMF to allow us to view details for the page something I do very often during trainings using the DBCC Page Utility. I figured this DMF would be pretty useful since I can be queried and joined with sys.dm_db_database_page_allocations to provide some interesting insight on the underlying pages mapped directly…

SQL 2019:- APPROX_COUNT_DISTINCT

A function that might prove useful when querying very large datasets, it provides a count of distinct values for any column in the database except text,ntext , image data types. Why would this be useful? In many cases we see that an approximate count of the rows is sufficient and we don’t really need an…

To accomplish this action, set property PartitionScheme

SSMS 18.X error when creating NonClustered index This seems to be a bug in SSMS as the index can be created using TSQL just fine here is the full error message. TITLE: Microsoft SQL Server Management Studio ——————————   Exception has been thrown by the target of an invocation. (mscorlib)   —————————— ADDITIONAL INFORMATION:  …

Installing SQL 2019 CTP 2.0

It’s finally out and it’s going to be awesome but there is only one way to find out, so here is the very first step, installing SQL SERVER. The trail version CTP 2.0 can be downloaded from the below link. You have four different installers. https://www.microsoft.com/en-us/sql-server/sql-server-2019 SQL for Windows SQL for Linux SQL in Docker…