Catatan

MySQL aria error

 This MariaDB log shows that the server failed to start due to a corrupted InnoDB data file , specifically involving a missing MLOG_CHECKPOINT . Let’s walk through what’s happening and how you can attempt recovery step-by-step. πŸ” What’s Happening? Key Log Line: [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 50981968 between the checkpoint 50981968 and the end 50981959. This means the InnoDB redo log is corrupted — it’s expecting a checkpoint that either doesn’t exist or is unreadable, which prevents InnoDB from initializing. πŸ› ️ Fix Step-by-Step ✅ 1. Backup First! Before trying anything else: Backup the entire MariaDB data directory (default on Windows is usually in C:\Program Files\MariaDB xx\data ). Also backup ib_logfile0 , ib_logfile1 , and ibdata1 . πŸ›‘ 2. Try Forcing InnoDB Recovery Edit your my.ini (or my.cnf ) file and add the following under the [mysqld] section : [mysqld] innodb_force_recovery = 1 Try restarting the MariaDB service. If it still fails,...

MSSQL behaviour loves to eat RAM πŸͺ

 ⚠️ Understanding SQL Server Memory Management SQL Server Memory Usage: SQL Server does not immediately release memory even if tables are truncated or data is deleted. Memory Retention Mechanism: By design, SQL Server retains memory (buffer pool, plan cache) for performance reasons. Memory Clearing is Manual: Reducing SQL Server's memory usage must be done explicitly. Solution: Clear SQL Server Memory Manually To manually clear SQL Server memory and force it to release unused memory: 1. Clear the Buffer Cache DBCC DROPCLEANBUFFERS; 2. Clear the Plan Cache DBCC FREEPROCCACHE; 3. Clear Cache for Specific Database (Recommended) USE [syncdb]; DBCC FREEPROCCACHE WITH NO_INFOMSGS; DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS; Solution: Adjust Maximum Server Memory (Temporary Fix) If SQL Server continues to consume too much memory, limit the maximum memory usage: EXEC sp_configure 'show advanced options' , 1 ; RECONFIGURE; EXEC sp_configure 'max server memory...

Check MSSQL Database Size

Imej
  To check the size of your database in SQL Server , you can use the following query: Chatgpt - Refer this  https://chatgpt.com/share/681c2bc9-c948-8001-8530-d2563ec53c59 1. Check Database Size (Data + Log) USE YourDatabaseName; GO EXEC sp_spaceused; 2. Detailed Database Size (Data and Log Separately) SELECT      name AS FileName,     size * 8 / 1024 AS SizeMB,      max_size * 8 / 1024 AS MaxSizeMB,     physical_name AS FilePath,     type_desc AS FileType FROM sys.master_files WHERE database_id = DB_ID('YourDatabaseName'); 3. Size of All Databases on the Server SELECT      DB_NAME(database_id) AS DatabaseName,     SUM(size * 8 / 1024) AS SizeMB FROM sys.master_files GROUP BY database_id; Analysis and Recommendations: High Index Size: Your index size is almost as large as your data size (4.09 GB for indexes vs 4.83 GB for data). This suggests you may have many indexes , including unused ...

PowerBI: Data Visualisation Assignment

  Refer link:  Keyword on Google: bad data visualization examples bad dashboard examples powerbi link 9 Bad Data Visualization Examples That You Can Learn From - https://www.gooddata.com/blog/bad-data-visualization-examples-that-you-can-learn-from/ Bad Data Visualization: 9 Examples to Learn From -  https://www.luzmo.com/blog/bad-data-visualization Dashboard examples: The good, the bad and the ugly -  https://www.matillion.com/blog/dashboard-examples-the-good-the-bad-and-the-ugly Power BI Dashboard Design: Avoid These 7 Common Mistakes -  https://zebrabi.com/power-bi-dashboard-design/ reddit discussion https://www.reddit.com/r/dataisugly/search/?q=poor+data+visualization+examples&cId=c9ce09ee-ddf4-40c4-8a97-82924c068004&iId=99a2075f-2971-4e17-8c45-ab4557e4c16e

Python ML: Load dataset

Imej
Load data from default repo Just open the command prompt and type code as below > python Python 3.12.2 (tags/v3.12.2:6abddd9, Feb  6 2024, 21:26:36) [MSC v.1937 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information.     >>> import sklearn >>> print(sklearn.__version__)   1.6.1   >>> from sklearn import datasets >>> dir(datasets)   ['__all__', '__builtins__', '__cached__', '__doc__', '__file__', '__getattr__', '__loader__', '__name__', '__package__', '__path__', '__spec__', '_arff_parser', '_base', '_california_housing', '_covtype', '_kddcup99', '_lfw', '_olivetti_faces', '_openml', '_rcv1', '_samples...

SQL Server size limit

Imej
  Truncate to reduce

MSSQL Deadlock

 SELECT * FROM sys.dm_tran_locks; SELECT creation_time, total_rows, text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) order by creation_time desc SELECT      blocking_session_id AS BlockingSession,     session_id AS BlockedSession,     wait_type, wait_time, wait_resource FROM sys.dm_exec_requests WHERE blocking_session_id <> 0;