Index fragmentation in SQL Server 2016 – Microsoft Q&A

Accepted answer. When you define an index, you have a server-wide default fill factor that is normally set to 100 (or 0, which has the same meaning). The default fill factor is fine in many cases, but it will cause a page split. A correctly chosen fill-factor value can reduce potential page splits by providing enough space for index expansion …

https://learn.microsoft.com/en-us/answers/questions/539679/index-fragmentation-in-sql-server-2016

Migrate to Azure file shares using RoboCopy | Microsoft Learn

Show 6 more. This migration article describes the use of RoboCopy to move or migrate files to an SMB Azure file share. RoboCopy is a trusted and well-known file copy utility with a feature set that makes it well suited for migrations. It uses the SMB protocol, which makes it broadly applicable to any source and target combination, supporting …

https://learn.microsoft.com/en-us/azure/storage/files/storage-files-migration-robocopy

Windows Server documentation | Microsoft Learn

Windows Server documentation. Windows Server is the platform for building an infrastructure of connected applications, networks, and web services, from the workgroup to the data center. Get Started.

https://learn.microsoft.com/en-us/windows-server/

Storage Spaces overview | Microsoft Learn

Storage Spaces overview. Storage Spaces is a technology in Windows and Windows Server that can help protect your data from drive failures. It is conceptually similar to RAID, implemented in software. You can use Storage Spaces to group three or more drives together into a storage pool and then use capacity from that pool to create Storage Spaces.

https://learn.microsoft.com/en-us/windows-server/storage/storage-spaces/overview

Microsoft Cybersecurity Reference Architectures – Security …

Download the file here. The reference architectures are primarily composed of detailed technical diagrams on Microsoft cybersecurity capabilities, zero trust user access, security operations, operational technology (OT), multi-cloud and cross-platform capabilities, attack chain coverage, azure native security controls, and security …

https://learn.microsoft.com/en-us/security/cybersecurity-reference-architecture/mcra

Use SCEP certificate profiles with Microsoft Intune

Profile: Select SCEP certificate. Or, select Templates > SCEP certificate. For Android Enterprise, Profile type is divided into two categories, Fully Managed, Dedicated, and Corporate-Owned Work Profile and Personally-Owned Work Profile. Be sure to select the correct SCEP certificate profile for the devices you manage.

https://learn.microsoft.com/en-us/mem/intune/protect/certificates-profile-scep

Move SQL server database storage – Microsoft Q&A

Our organization has purchased new SAN for the SQL database. The SQL server is configured as a two nodes failover cluster where one node is active and the other is passive and databases are stored on the current running SAN.

Kindly assist in how we can change our SQL databases from the current SAN to the new SAN without any downtime.

Thanks in advance.

https://learn.microsoft.com/en-us/answers/questions/1141832/move-sql-server-database-storage

NTFS overview | Microsoft Learn

NTFS continuously monitors and corrects transient corruption issues in the background without taking the volume offline (this feature is known as self-healing NTFS, introduced in Windows Server 2008). For larger corruption issues, the Chkdsk utility, in Windows Server 2012 and later, scans and analyzes the drive while the volume is online …

https://learn.microsoft.com/en-us/windows-server/storage/file-server/ntfs-overview

What is a driver? – Windows drivers | Microsoft Learn

In the most fundamental sense, a driver is a software component that lets the operating system and a device communicate with each other. For example, suppose an application needs to read some data from a device. The application calls a function implemented by the operating system, and the operating system calls a function implemented by the driver.

https://learn.microsoft.com/en-us/windows-hardware/drivers/gettingstarted/what-is-a-driver-

diskpart | Microsoft Learn

san: Displays or sets the storage area network (san) policy for the operating system. select: Shifts the focus to a disk, partition, volume, or virtual hard disk (VHD). set id: Changes the partition type field for the partition with focus. shrink: Reduces the size of the selected volume by the amount you specify. uniqueid

https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/diskpart