February 7, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
- Filter by
- Categories
- Tags
- Authors
- Show all
- All
- Azure App Service
- Azure Architecture
- Azure Blog
- Azure Retirements
- Azure Updates
- Command Line
- Community
- Microsoft News
- Microsoft Security
- Tech Community
- All
- .NET
- Access Azure Cloud Shell from local device
- access control list
- acls
- Active Directory
- Active Directory Management
- Active Directory Sync
- AD DS
- AD DS Migration
- AD Health Check
- Adversary-in-the-middle (AiTM)
- Agentic AI
- agic
- AI
- AI + Machine Learning
- ai foundry
- AI learning
- ai search
- ai services
- AI Skills fest
- AI Skillsfest
- AKS
- alerts
- amba
- AML
- analytics
- Annual Channel
- API Management
- API manager
- api-development
- APIs
- App Configuration
- App Control
- app service
- app-modernization
- Application Gateway
- application gateway for containers
- Application Insights
- application security groups
- Arc Jumpstart
- Archive Storage
- Are agents free in Microsoft 365 Copilot chat
- are copilot pages free
- Are Microsoft Applied Skills Credentials free
- arm
- Article
- Artificial Intelligence
- ASP.NET Core
- aspire
- Audio Notes
- authentication
- authorization
- automation
- availability sets vs zones
- Availability Zones
- AVD
- AVD admin tips
- AVD best practices
- AVD changes 2025
- AVD clipboard redirection
- AVD configuration
- AVD drive redirection
- AVD host pool settings
- AVD printer redirection
- AVD redirection
- AVD security update
- AVD tutorial
- AVD USB redirection
- AVM
- avnm
- aws
- AZ-900
- Azure
- Azure Access Control
- Azure Active Directory
- Azure Activity Logs
- Azure AD
- Azure AD Connect
- Azure AD Sync
- Azure Adaptive Cloud
- Azure Admin Guide
- Azure Administration
- Azure AI
- Azure AI Foundry
- Azure AI Search
- azure ai serach
- azure ai studio
- Azure ai-services
- azure application delivery
- Azure Application Gateway
- azure application gateway for containers
- Azure Archive Storage
- azure availability sets
- azure availability zones
- Azure Backup
- Azure Bastion
- Azure Bastion demo
- Azure Bastion Developer Tier
- Azure Bastion free tier
- Azure Bastion Linux
- Azure Bastion Setup
- Azure Bastion Tutorial
- Azure Bastion walkthrough
- Azure Bastion Windows
- Azure Best Practices
- Azure Bicep
- Azure Blob Storage
- Azure Blob vs File Storage
- Azure Blob vs File vs Disk
- Azure Certificate demo
- Azure Chaos Studio
- Azure CLI
- Azure CLI SSH
- Azure Cloud
- Azure Cloud Architect
- Azure cloud desktop
- Azure Cloud Identity
- Azure Cloud Security
- Azure Cloud Shell from laptop
- Azure Cloud Storage
- Azure Cloud Tutorial
- Azure Compute Fleet
- Azure Conditional Access
- Azure confidential ledger
- Azure Configuration Tutorial
- Azure Container Apps
- Azure Container Instances
- Azure Container Registry
- Azure Container Storage
- azure copilot
- Azure Cosmos DB
- Azure Data Box
- Azure Data Explorer
- Azure Data Factory
- Azure Data Lake Storage
- Azure Data Management
- Azure Data Storage
- Azure Database for MySQL
- Azure Database for PostgreSQL
- Azure Database Migration service
- Azure Databricks
- Azure default outbound access
- Azure DevOps
- Azure DevTest Labs
- Azure Disk Storage
- Azure DNS
- Azure Domain Services
- Azure Edition
- Azure Enterprise Applications
- Azure Entra ID
- Azure Entra Migration
- azure essentials
- Azure Essentials Show
- Azure Event Hub
- Azure explicit internet access
- Azure ExpressRoute
- azure fault domains
- Azure File Share
- Azure File Storage
- Azure Files
- Azure Firewall
- Azure Firewall Manager
- azure firewall policy
- azure fleet
- Azure Front Door
- Azure Functions
- Azure Functions Flex Comsumption
- Azure Global
- Azure HDInsight on Azure Kubernetes Service (AKS)
- azure high availability
- azure hybrid
- Azure Hybrid Benefit
- Azure Hybrid Identity
- Azure Identity Management
- Azure Identity Services
- Azure Image Builder
- Azure Infrastructure
- Azure Key Vault
- Azure Key Vault and Lets Encrypt certs demo
- Azure Key Vault demo
- Azure Kubernetes Fleet Manager
- Azure Kubernetes Service
- Azure Kubernetes Service (AKS)
- Azure Lab
- Azure Load Testing
- Azure Local
- Azure Log Analytics
- Azure Logic App
- Azure Logic Apps
- Azure Machine Learning
- Azure Maps
- Azure Migrate
- Azure Modular Datacenter
- Azure Monitor
- azure monitor baseline alerts
- Azure Monitor Workbooks
- Azure Monitoring
- Azure NAT Gateway
- Azure Native Client
- Azure NetApp Files
- azure network monitoring
- Azure Network Security
- Azure Networking
- Azure Open AI
- azure openai
- azure openai service
- Azure outbound access
- Azure Platform
- Azure Policy
- Azure Portal
- Azure Portal Tutorial
- Azure Private Access
- Azure Private Applications
- Azure Private Link
- Azure Private Subnet
- azure rbac
- Azure RDP settings
- Azure RDP without public IP
- Azure Red Hat OpenShift
- azure regions
- azure routing
- Azure Secure Connectivity
- Azure Security
- Azure Security Best Practices
- Azure Sentinel
- Azure September 2025 changes
- Azure Service Bus
- Azure Setup
- Azure Site Recovery
- Azure Skill Sprint
- azure sla
- Azure SNAT
- Azure Spot Virtual Machines
- Azure Spring Apps
- Azure SQL
- Azure SQL Database
- Azure SQL DB
- Azure SQL Edge
- Azure SQL Managed Instance
- Azure SSH without public IP
- Azure Stack HCI
- Azure Step-by-Step Guide
- Azure Storage
- Azure Storage Access Tiers
- Azure Storage Access Tiers Explained
- Azure Storage Actions
- Azure Storage Best Practices
- Azure Storage Cost Optimization
- Azure Storage Cost Savings
- Azure Storage Demo
- Azure Storage Explained
- Azure Storage for Beginners
- Azure Storage Options
- Azure Storage Overview
- Azure Storage Performance
- Azure Storage Pricing
- Azure Storage Tips
- Azure Storage Tutorial
- Azure Storage Types
- Azure subnet configuration
- Azure subnet demo
- Azure Subscription
- Azure Synapse Analytics
- azure traffic analytics
- Azure Traffic Forwarding
- Azure Traffic Manager custom domain has not been configured in Azure
- azure training
- Azure Tutorials
- azure update domains
- Azure Virtual Desktop
- Azure Virtual Machines
- Azure Virtual Network
- azure virtual network manager
- Azure VM
- Azure VM connection
- azure vm deployment
- Azure VM Internet Access
- Azure VM RDP
- azure vm redundancy
- Azure VM Security
- Azure VM Setup
- Azure VNet Bastion
- Azure VNet default access
- Azure VPN Alternative
- Azure Well-Architected Framework
- azure-ad-b2c
- azure-arc
- azure-b2c
- azureai
- AzureAIFoundry
- AzureAISearch
- azurebicep
- azuredevops
- azureopenai
- azureverifiedmodules
- bash-script
- Bastion Host
- beginners
- best practices
- Bicep
- biceplang
- Bing Search
- Blizzard
- blog
- Book Review
- build
- Business
- Business Intelligence
- C#
- Canceled
- CCAK
- Certificate of Cloud Auditing Knowledge
- Certifications
- Chat GPT
- chatgpt
- client-credentials-flow
- Cloud
- Cloud Architect
- Cloud Audit
- Cloud Cultures
- Cloud Directory Sync
- Cloud Foundation
- Cloud Governance
- Cloud Migration
- Cloud Network Security
- cloud networking
- Cloud PC
- Cloud PC licensing
- Cloud Recovery
- Cloud Rewind
- cloud security
- Cloud Security Alliance
- Cloud Services
- Cloud Storage
- Cloud Storage Tiers
- cloud terminology
- cloud-computing
- CloudFamily
- Cmd
- cmk
- code
- codegeneration
- coding
- Command Line
- command-line-interface
- community
- Community IT event
- Commvault
- Compliance
- compute
- Conditional Access
- Conditional Access Policies
- Connect to Azure VM
- container networking
- containers
- copilot
- Copilot pages explained
- Copilot pages simplified
- copilot pages step by step demo
- cosmosdb
- Cost Management
- cost-optimization
- credential theft
- cryptocurrency mining
- cryptojacking
- csharp
- custom error
- custom-policies
- Cyber Security
- Cyberespionage
- Cybersecurity
- CyberSecurity Certifications
- Cybersecurity trends
- D365
- D365 CE
- D365 F&O
- D365 Sales & CRM
- dashboards
- data
- Data Protection
- Databases
- databricks devops
- Dayforce
- Deleted
- dependabot
- Deploy Azure Bastion
- deployment
- deployment stacks
- dev-containers
- Developer
- Developer Life
- Developer Tools
- Development
- devops
- DevSecOps
- Diagnostic Settings
- diagnostics
- difference between Microsoft 365 Copilot Chat and Microsoft 365 Copilot
- disable default outbound
- distributed-systems
- DNS Configuration
- document-intelligence
- Does Microsoft 365 Copilot use company data to train LLM
- Domain Controller
- Domain Controller Demotion
- dotnet
- ECMA2
- EF Core
- Encryption
- Endpoint management
- Enterprise File Sharing
- Enterprise IT
- enterprise-architecture
- entra
- Entra Configuration
- Entra Connect
- Entra Connect High Availability
- Entra Connect Migration
- Entra Connect Staging Mode
- Entra Connect Step by Step
- Entra Global Secure Access
- Entra ID
- Entra Internet Access
- Entra Private Access
- Entra Private Access Tutorial
- Entra Suite
- entra-external-id
- epac
- error
- error-message
- Event
- event hub
- event-driven-architecture
- Events
- Exchange Online
- Exec posts
- explore microsoft purview portal
- Expressions
- ExpressRoute
- Extended Network for Azure
- external-id
- external-identity
- fail()
- Features
- federation
- Fedora
- fiddler
- File Sharing Security
- FIM
- fine-tuing
- Fine-tuning
- finops
- Firewall
- firewall rules
- Flex Comsumption Deployment
- Forrester Waves
- foundry
- Free AI learning
- Free Assessments Microsoft
- Free Azure Bastion
- Free Microsoft Asessmements
- Free Microsoft Certifications
- Frontline Cloud PC
- FSMO Roles
- gateway api
- genai
- General
- General Development
- Generative AI
- getting started with Microsoft Purview
- Git
- GitHub
- GitHub Actions
- github copilot
- githubcopilot
- Global Secure Access
- Google Cloud Platform
- governance
- gpt4o
- Grafana
- grafana dashboards
- granfeldt
- Graph
- graph-explorer
- grok
- gwctl
- HashiCorp
- HashiCorp Ambassador
- Have I Been Pwned
- header
- Helm
- high availability azure
- homelab
- host
- Hot Cool Cold Archive Tiers
- How to access Azure Cloud Shell locally
- How to take free Microsoft Certifications
- How-to
- http route
- hub
- Hub & Spoke
- hub-and-spoke
- Hugo
- Hybrid
- Hybrid + Multicloud
- Hybrid Cloud
- Hybrid Cloud Authentication
- Hybrid Identity
- Hyper-V
- IaC
- identity
- Identity and access management
- Identity-Based Security
- In development
- In preview
- influencers
- Information Technology
- infrastructure
- Infrastructure As Code
- infrastructureascode
- ingress controller
- Integration
- Internet of Things
- Intune
- Intune Cloud PC
- Intune tips
- Investor Relations
- ipam
- Is Microsoft 265 Copilot free
- ISACA
- IT administration
- IT conference 2025
- IT networking event
- IT Pro
- IT Professionals
- IT Training
- IT Tutorials
- java
- jfk-assassination
- John Towles interview
- jwt-token
- K8s
- KDC Proxy
- KEMP
- Kerberos Authentication
- Key Vault
- kinde
- kmsi
- KQL
- kubernetes
- kubernetes fleet
- kubernetes gateway
- kubernetes gateway api
- kubernetes networking
- Kusto
- kusto query language
- Lab
- Lambda functions
- Landing Zones
- Language Understanding (LUIS)
- Launched
- Learn Azure
- learning
- LINUX
- Linux Virtual Machines
- Living off the land
- LLM
- Load Balancer
- load balancing
- Loadmaster
- Log Alerts
- Log Analytics
- Log Analytics Workspace
- Logic Apps
- Long-Term Servicing Channel
- macOS
- Managed Prometheus
- Management
- Management and Governance
- Management Groups
- masking
- MCP
- mentorship
- mfa
- micro-segmentation
- microsegmentation
- Microsoft
- Microsoft 365
- Microsoft 365 Copilot
- Microsoft 365 Copilot Chat and Microsoft 365 Copilot Explained
- Microsoft 365 Copilot Chat explained
- Microsoft 365 Security
- Microsoft AI Skills Fest
- Microsoft Applied Skills
- Microsoft Azure
- Microsoft Azure Tutorial
- Microsoft Build
- Microsoft Cloud
- Microsoft Cloud PC
- Microsoft Cloud Security
- Microsoft Copilot for Azure
- Microsoft Copilot for Security
- Microsoft Cost Management
- Microsoft Defender
- Microsoft Defender for Cloud
- Microsoft Dev Box
- Microsoft Earnings Results
- Microsoft Entra
- Microsoft Entra Domain Services
- Microsoft Entra ID
- Microsoft Entra ID (formerly Azure AD)
- Microsoft Fabric
- Microsoft Graph
- Microsoft Ignite
- Microsoft Intune
- Microsoft licensing
- microsoft mvp
- Microsoft Purview
- Microsoft purview explained
- Microsoft Purview for beginners
- Microsoft Purview portal
- Microsoft Purview roles and scopes
- Microsoft purview step by step guide
- Microsoft Security
- Microsoft Sentinel
- Microsoft SQL Server
- Microsoft Training
- Microsoft Visual Studio
- microsoft-support
- Migrate Entra Connect
- Migration
- MIM
- Mint Sandstorm (PHOSPHORUS)
- Misc
- MITRE ATT&CK
- ML
- Mobile
- Modern Workplace
- modules
- msal
- multi-cluster load balancing
- multi-cluster networking
- MVPBuzz
- native-authentication
- network
- Network Address Translation
- network rules
- Network security
- network security group
- network security rules
- Network Traffic Filtering
- Network Watcher
- network-tracking
- networking
- Networking Basics
- new
- News
- NodeJS
- NoSQL
- NSG
- nuget
- nxdomain
- nxdomainredirect
- observability
- oidc
- On-Premises AD
- Open AI
- open source
- open-api
- openai
- opensource
- Operating System
- Operational Excellence
- overlay cni
- PaaS networking
- Packer
- patterns
- Performance Efficiency
- Phishing
- Playbook
- Pluralsight
- policy as code
- politics
- postgresql
- postman-testing
- Power BI Embedded
- power-platform
- PowerAutomate
- powershell
- PowerShell Active Directory
- presentations
- Press Releases
- Pricing & Offerings
- Private Endpoint
- private link
- private networking
- privatelink
- privatelinkrealitybites
- Productivity
- profile-edit
- programming
- Progress
- Promote DC
- prompt
- Prompt Engineering
- Prompt Flow
- Prototyping
- proxmox
- public cloud networking
- Public Speaking
- pullrequest
- python
- Quick Post
- ransomware
- Raspberry Pi
- RBAC
- RDP over TLS
- Recent News
- recording
- Regions & Datacenters
- Reliability
- Remote code execution
- Remote Desktop Azure
- Remove Domain Controller
- Resiliency
- responsible-ai
- ResponsibleAI
- REST API
- Retirements
- reverse proxy
- Roles in Microsoft Purview explained
- route table
- routing
- s2s vpn
- SaaS
- SAML
- Sandstorm
- SDK and Tools
- SDKs
- Secure Azure Connections
- Secure Azure VM Access
- Secure File Sharing
- Secure Future Initiative
- Secure Internet Access
- Secure Remote Access
- Secure SMB Access
- Secure Web Gateway
- security
- security admin rules
- Security Baseline
- Securtiy
- Semantic Kernel
- Sentinel
- Server Manager
- Service Endpoint
- service endpoint policy
- Service Management
- Services
- SIEM
- signature
- Sleet
- SMB Configuration
- SMB over QUIC
- SMS
- snyk
- SOAR
- software-architecture
- Software-Defined Networking
- software-design
- software-developer
- software-development
- software-engineering
- speaking
- Speech
- Speech to Text
- sql
- SQL Interview
- SQL Server
- SQL Server on Azure Virtual Machines
- SSH Azure VM
- Star Blizzard (SEABORGIUM)
- static code analysis
- Static IP Azure
- Step by Step Azure Key Vault and certificate demo
- storage
- Storage Accounts
- Storage Replicas
- Storm
- string split
- Survey
- swagger
- system administrator
- Tech conference Dallas
- Tech Guide
- Tech Tutorial
- Technical
- Technology
- terminology
- Terraform
- Terraform Tests
- test
- test-automation
- testing
- Text Analytics
- Thomas Maurer
- thought-leadership
- TLS 1.3 Encryption
- Token theft
- totp
- trace
- traffic analytics
- traffic filtering
- Traffic Manager
- Traffic Manager 404 Website not found
- traffic visibility
- Transaction Optimzed
- troubleshooting
- tutorial
- Uncategorized
- updated
- user-defined route
- User-Defined Routing
- validation
- vibe-coding
- Video
- Virtual desktop infrastructure
- Virtual Machine Scale Sets
- Virtual Machines
- virtual network
- virtual network flow logs
- Virtual Network Gateway
- virtual network service endpoint
- Virtual WAN
- Virtualization
- VNet
- VNet Flow Logging
- vnet flow logs
- vnet service endpoint
- vpn
- VPN Alternative
- VPN Gateway
- vpn site-to-site
- vscode
- Web
- web app
- web application firewall
- Web Content Filtering
- Web Filtering Policy
- webapp
- Well-Architected
- Well-Architected Framework
- WellArchitectedFramework
- What are adaptive scopes in Microsoft Purview
- what are Copilot pages?
- What are Microsoft Applied Skills Credentials
- what is Microsoft 365 Copilot chat
- what is Microsoft Purview
- Why Earn a Microsoft Applied Skills Credential?
- Windows
- Windows 11
- Windows 365
- Windows 365 Business
- Windows 365 Enterprise
- Windows 365 explained
- Windows 365 Frontline
- Windows 365 licensing
- Windows 365 management
- Windows 365 tutorial
- Windows 365 vs AVD
- Windows AD
- Windows Admin Center
- Windows Console
- Windows Server
- Windows Server 2022
- Windows Server 2025
- Windows Server Administration
- Windows Server Azure Edition
- Windows Server Comparison
- Windows Server Datacenter
- Windows Server Deployment
- Windows Server Features
- Windows Server Hotpatching
- Windows Server Licensing
- Windows Server Service Channels
- Windows Server Standard
- Windows Server Summit
- Windows Server Tutorial
- Windows Subsystem for Linux (WSL)
- Windows Terminal
- Windows Terminal Azure Cloud Shell
- Windows Virtual Desktop
- Windows Virtual Machines
- Workbooks
- Workplace Ninjas
- Workplace Ninjas US
- workspace-ip-access
- WSL
- xai
- XDR
- yaml
- Year In Review
- Zero Trust
- Zero Trust Azure
- Zero Trust Networking
- zone redundant storage
- All
- Adrian Hills
- Aidan Finn
- Alan Kinane
- Az Advertizer
- Azure Community Enthusiasts
- azurefeeds
- Carlos Mendible
- Charbel Nemnom
- Cloud Native Weekly
- Dan Rios
- Daniel Bradley
- Daniel McLoughlin
- Daniel Scott-Raynsford
- Darren Robinson
- David O'Brien
- Dieter Gobeyn
- Freek Berson
- George Ollis
- Greg Low
- Gregor Suttie
- Imran Rashid
- Jake Walsh
- Jaliya Udagedara
- James Cook
- Jamie Maguire
- Jesse (JSON) Loudon
- Joe Carlyle
- John Kilmister
- John Lokerse
- John Savill
- Jose Moreno
- Leo Visser
- Luke Murray
- Maik van der Gaag
- Mark Tinderholt
- Matt Felton
- Nicholas Chang
- Nicola Delfino
- Olivier Miossec
- Peter De Tender
- Pixel Roberts
- Rod Trent
- Rory Braybrook
- Roy Kim
- Sam Cogan
- Sarah Lean
- Simon Waight
- Stanislav Zhelyazkov
- Sucheta Gawade
- Tao Yang
- Thomas Maurer
- Thomas Thornton
- Tobias Zimmergren
- Travis Roberts
- Vukašin Terzić
- Will Velida
February 7, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. Excel is fascinating in how […]
February 6, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 6, 2025
I’ve made several posts about joins but one option that I haven’t talked about as yet, are what are called non-equi joins. These are less common, […]
February 5, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 5, 2025
One thing you might not have considered is that a table can also be joined to itself. Imagine that I want a list of employees, but […]
February 4, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 4, 2025
Of course, you might also need to join more than two tables. The example above shows how to do that. I started with the Orders table, […]
February 3, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A while back, we added […]
February 3, 2025
After discussing LEFT OUTER JOIN, you might wonder if there is also a RIGHT OUTER JOIN. There is, and it’s the reverse of the left one. […]
February 2, 2025
Another request that I received a while back, for a new function in our free SDU Tools for developers and DBAs, was to be able to […]
February 2, 2025
The next type of join that I want to discuss in these posts is a left outer join. We use this mostly, when we know that […]