Everything SQL related and then some
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…
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…
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…
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…
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: To accomplish this…
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…