
Storage Spaces Direct (S2D) for SQL Server Failover Cluster Instances (FCI)?
With the introduction of Windows Server 2016 Datacenter Edition a new feature called Storage Spaces Direct (S2D) was introduced. At a very high level, this solution allows you to pool together locally attached storage and present it to the cluster as a CSV ... continue reading

Build a Company in #Azure Video
Content – The Azure Portal 00:05:00 – Networking in Azure 00:10:12 – Azure Virtual Machines 00:22:16 – Containers and Kubernetes Orchestration 00:50:57 – Directory Services and Azure AD 01:03:39 – DevTest Labs 01:18:23 – Backup and Disaster Recovery 01:29:48 – ... continue reading

Clustering FileServer Data Deduplication on Windows 2016 Step by Step #sofs #winserv #ReFS #WindowsServer2016 #Dedupe
Building a File server in Server 2016 isn’t that different tan in Server 2012R2 except there are different options, ReFS, DeDupe and a lot more options. As we start with the basic file server clustered and using ReFS and Data ... continue reading

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads
Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer) and Shail Batra (Principal Software Engineering Manager) for sharing their migration story with the Azure SQL Database product team. Microsoft uses an internally written service called MSAsset to manage ... continue reading

Quick Reference: Recovery Options for Post-Mortem Debugging for Windows and Virtual Machines
Hi everyone, Robert Smith here to talk to you today a bit about crash dump configurations and options. With the wide-spread adoption of virtualization, large database servers, and other systems that may have a large amount or RAM, pre-configuring the ... continue reading

SQL Server 2017 on Linux webcast series
The world’s leading database is now available on Linux by bringing Microsoft SQL Server to Linux, Microsoft continues to embrace open source solutions. SQL Server 2017 brings the best features of the Microsoft relational database engine to the enterprise Linux ... continue reading

How to upgrade ConfigMgr to the latest version along with upgrading OS and SQL
Here is a step by step upgrade path from System Center Configuration Manager 2012 SP2 hosted on Windows Server 2012 R2 to System Center Configuration Manager 1702 or later hosted on Windows Server 2016. These steps can be used if ... continue reading

Modernize Windows Server backups with Azure Backup
This blog post was authored by Shivam Garg, Principal PM, Azure Backup. Are you still using traditional Windows Server Backup (WSB) to back up your servers to locally attached media or network shares? It’s time to take a hard look ... continue reading

In-Memory OLTP Indexes – Part 1: Recommendations.
In-Memory OLTP Indexes In-Memory OLTP technology, available in Azure SQL Database and SQL Server, can significantly help you in improving the performance of applications that require high throughput and low latency online transaction processing, high volume concurrent data ingestion (Internet ... continue reading

Protecting Domain Administrative Credentials
Hello, Paul Bergson back again with today’s topic of preventing your Domain Administrators and other privileged identities from logging into Tier 1 and Tier 2 devices. Credential theft protection is always an important step in protecting the enterprise. While your ... continue reading