From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal. Now, we can provision Microsoft fabric easily using Microsoft PowerBI premium per capacity or using...
2023-06-23 (first published: 2023-06-05)
475 reads
This blog post aims to provide an overview of Azure Storage Accounts. It will explain how to create them and use them effectively. Azure Storage Account Azure Storage Account...
2023-05-19 (first published: 2023-05-03)
499 reads
In my previous post, we explored the basics of creating First Azure Data Factory. Today, I want to delve deeper into the process of creating and configuring pipelines within...
2023-05-15 (first published: 2023-05-01)
320 reads
What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your...
2023-05-08 (first published: 2023-05-01)
735 reads
What is Azure Resource Group? Azure Resource Group is a powerful feature that enables effective organization and management of resources in the Azure cloud. A Resource Group is a...
2023-05-01
161 reads
Azure SQL Database is a cloud-based database service that offers scalability and flexibility to handle large workloads. It’s based on Microsoft SQL Server Database Engine and provides a managed...
2023-04-30
115 reads
It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially...
2023-04-17 (first published: 2023-03-31)
1,156 reads
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
2019-05-16 (first published: 2019-05-04)
507 reads
An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error:
Msg 18752, Level...
2018-09-19 (first published: 2018-09-10)
8,042 reads
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to...
2018-09-19
1,155 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers