Read This Before Your Users Install SSMS 20 https://ift.tt/fNX9Jey SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: When you click Connect, you’re likely going to get an error: The fastest fix is to click the Encryption dropdown, and change it to Optional: And then you’ll […]
Mastering Azure AD Connect – A Comprehensive Guide https://ift.tt/zABDn8g Modern businesses are fast moving toward cloud-based infrastructure. In fact, cloud-based business is not just a trend anymore but a strategic necessity. Microsoft’s Azure Active Directory (Azure AD) has become a frontrunner in this domain. It offers a robust cloud-based identity and access management solution. It’s […]
Windows LAPS Management using Microsoft Intune https://ift.tt/Oc4uelF A local Administrator account is built-in with every Windows machine. This account has full access to the machine, and we cannot delete it. The local admin account is protected with an account password and many organizations manage local admin account passwords using Windows LAPS Management on-premises. The solution […]
Upgrade Your Exchange Rooms: Advanced Options https://ift.tt/vYMLJpr There are several advanced options only available in PowerShell for Exchange Online for setting up rooms. These include giving some users more rights to the room calendars, hiding or showing certain meeting details, and managing the rooms with groups. This post will look at each of these Microsoft […]
Check Your SQL Server Backup Performance & Safety with sp_BlitzBackups https://ift.tt/32o9Fdu Out of all of the scripts in our free First Responder Kit, sp_BlitzBackups is probably the one you’ve used the least. Let’s talk about what comes out of it, and why you should use it more often. First, let’s define two terms: Recovery Point […]
How to install SQL Server on Linux hosted on Windows Server 2019 https://ift.tt/3mJtq7s This article explores Windows Subsystem for Linux (WSL) to run the Linux operating system on Windows OS and configure SQL Server on Linux. Introduction The Windows Subsystem for Linux (WSL) is a way for developers to run Linux directly on Windows 10 […]
Microsoft Endpoint Manager – How to Synchronize Local AD Account to Intune with Azure AD Connect https://ift.tt/2SGDnpS In the previous blog I explained how to create users in Microsoft Endpoint Manager. But what if you already have on-premise infrastructure with users you want to synchronize with Azure AD? It’s possible with Azure AD Connect. Azure […]
Automate SQL database backups using Windows Task Scheduler https://ift.tt/3mPBX70 In this article, we will learn how we can automate the backup of SQL database created in SQL Server Express edition. SQL Server Express edition is a lightweight database that has limited functionalities and resource allocation. The SQL Server Express edition does not support SQL Server […]
Configure long-term backup retention for Azure SQL database https://ift.tt/3d1Z9dI This article configures a long-term backup retention policy for Azure SQL Database. Introduction It is the prime duty of database administrators (DBAs) to ensure all databases are backed up regularly as per the defined backup policy. These backups should be available for restoration on-demand as well […]
Updated First Responder Kit and Consultant Toolkit for February 2021 https://ift.tt/3bxyWTs Along with the usual bug fixes & improvements, this month’s release includes a brand new sp_BlitzAnalysis script from Adrian Buckman. It’s for folks who have an Agent job to log sp_BlitzFirst to tables every 15 minutes, saving wait stats, Perfmon counters, file stats, etc […]
Stack IT News 