IT Knowledgebase Articles

SQL CROSS JOIN queries are used to generate a paired combination of each row of the first table with each row of the second table. This kind of result is called a Cartesian product. In this article, I’ll show you how to use an SQL CROSS JOIN. How does an SQL Cross Join work? The…

As an IT Pro, it is crucial to your organization to make sure that your users receive legitimate emails. Sometimes, Exchange Online Protection (EOP) can flag these emails as spam. Safely creating whitelists — also sometimes referred to as allowlists — for specific domains/email addresses allows you to efficiently manage email flow in your organization and…

In this article, I will explain how to enable Windows 10 auto login to reach the desktop environment without having to enter a username and password. I’ll also outline the pros and cons associated with configuring auto login on this version of Windows. What is auto login on Windows 10? Windows 10 provides robust security…

As an IT admin, preventing your users from using simple or known-hacked passwords has become critical for the overall security of your enterprise. An excellent step to take is to plan for and deploy Azure AD Password Protection. In this article, I’ll walk you through installing the Proxy service and DC agent in your on-premises…

In this first episode, Stephen talks to Microsoft’s Anupam Pattnaik, Product Lead for Teams. In this inaugural show, Stephen and Anupam discuss how IT can control access to the new Teams experience for end users, when Teams 2.0 will become the default experience for everyone, when the new client will reach feature parity with classic…

In this episode of First Ring Daily, Stephen Rose, Petri’s Chief Technology Strategist, talks to Paul and Brad about the most interesting news from Build 2023.

Creating backups is one of the most important duties of an SQL Server database administrator, and there are a number of different ways to back up your most important databases. In this article, I’ll explain how to create a simple SQL backup job using SQL Server Management Studio (SSMS). The different ways to create SQL…

This Week in IT, Stephen Rose meets Richard Campbell, host of RunAs Radio, to discuss all the major AI announcements at Microsoft Build 2023. Including, Windows Copilot, Microsoft Fabric, AI plugins, privacy and security, and the AI hype cycle.

As an IT pro, enhancing your home lab with new capabilities should be a continual process. Being able to simulate and get hands-on experience is crucial, and this is where the Microsoft 365 Developer Program lends you a helping hand. After joining the program, you can sign up for a free, renewable Microsoft 365 E5…

If most organizations understand the need to have a robust disaster recovery (DR) plan, IT Pros should also know that testing these plans is essential. If you don’t implement disaster recovery testing, you won’t know if your plans will work when you need them. And to properly test your DR plans, you may want to break them….