Windows Server

Windows Server logo small Microsoft Windows Server 2016 logo

Windows Server (2016, 2012, 2008, 2003 and R2 versions) articles. With Windows Server 2012 R2 you can scale to run your most important workloads with robust recovery options. You’ll achieve value quickly with a wide range of cost-effective, high-performance storage options and simplified delivery of multi-tenant IT services. You can build, deploy, operate, and monitor applications on premises and in the cloud. Empower users with secure access to corporate resources on the devices they choose.

Microsoft SQL Server database: security, performance, code, T-SQL, PowerShell and information

(featured image credit: Freddy2001 on Wikipedia)

File cabinet image

Manually failover all databases in an SQL Server Database Mirroring configuration

How to manually failover an SQL Server database mirroring session? How to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017+. This can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I’ll show you …

Manually failover all databases in an SQL Server Database Mirroring configuration Read More »

Working with file attributes in PowerShell

Working with PowerShell’s Get-ItemProperty to get file attributes may boost your work productivity. It’s often easier to getting things done if you have a more generic way of doing something. Here is how to use Get-Item and Get-ItemProperty in PowerShell to perform and streamline day to day tasks like installing or updating software based on file versions. …

Working with file attributes in PowerShell Read More »

Show Buttons
Hide Buttons