SQL Server & Windows Server

How to Fix ‘Incorrect Information in File’ Error in MySQL?

Several MySQL users have reported encountering the ‘Incorrect information in file’ error while accessing the tables in the database after system restart or sudden system crash. One of…

SQL Server & Windows Server

How to fix SQL Database Restore Failed: ‘Database in Use’ Error

MS SQL database files are susceptible to corruption and consistency issues. If your database is corrupted or damaged, you can restore the database from backup.However, sometimes, while restoring…

SQL Server & Windows Server

How to Repair Corrupt MySQL Database

Corruption in MySQL Server database can occur due to several hardware and software issues. Some common issues include, bugs in software, faulty applications, bad sectors on the hard…

PowerShell SQL Server & Windows Server

Windows 10 Get / set System Time zone using PowerShell

on the date option and select Adjust Date/Time and from there you can change the time zone. Recently I was testing some code for different time zone but…

SQL Server & Windows Server

How to Remove Database from Suspect Mode in SQL Server 2012?

Summary: This post discusses why a database goes into SUSPECT mode. Also, it explains the methods to remove database from suspect mode in SQL Server 2012. You may…

SQL Server & Windows Server

Product Review – Stellar Repair for MS SQL

Problem My SQL Server 2008 R2 database was stuck in suspect mode. The database was no longer accessible. I tried restoring it by setting it to ‘EMERGENCY’ mode…

SQL Server & Windows Server

How to Restore MS SQL Database After Power Failure

Introduction: If your company operates constantly (24/7) your servers are always on. Sometimes you may face power failure due to the maintenance of some power stations. In order…

SQL Server & Windows Server

Database Filegroup(s) and Piecemeal Restores in MS SQL Server

Introduction: Since SQL Server preserves data in a version, those facts need to move somewhere, but where does it shift? In which Filegroups come into play in SQL…

SQL Server & Windows Server

Process to Restore SQL Database From Backup In Single User Mode

SQL Server from Microsoft is one of the best and vastly used relational database management system. This application can be used to organize and maintain data. To deal…

SQL Server & Windows Server

How to fix SQL Server database corruption after power outage

Introduction: Sometimes due to the power outage or power shortage, we have to face some hardware or software issues regarding our system (computer). And when you log in…

Adnan Amin

Adnan Amin

Microsoft MVP since 2015 and Senior Microsoft Consultant. Practical Microsoft 365 guides and free PowerShell scripts for SharePoint, OneDrive, Teams and Copilot admins.

Microsoft MVP badge - view Adnan Amin's MVP profile

About me · LinkedIn · GitHub · YouTube

Get new posts by email

One short email a week with the new Microsoft 365 guides and PowerShell scripts. Unsubscribe any time.

Recent Posts
Graph sharedWithMe deprecated featured image: sharedWithMe goes quiet this month
Microsoft Graph sharedWithMe and recent stop returning
SharePoint unique permissions report featured image: who broke inheritance
Unique permissions report for a SharePoint site
Anyone links SharePoint featured image: every Anyone link in one CSV
How to find Anyone links on a
SharePoint OTP retirement featured image: old guest links stopped working
Guests getting access denied on old SharePoint
Featured image: three ways to find SharePoint sites with Copilot blocked using Restricted Content Discovery
Three ways to find which SharePoint sites