Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE...
2012-04-19
45 reads
SQL & BI
Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with...
2012-04-18
232 reads
MDM (Master Data Management) Business Scenario
Introduction
Master Data Management (MDM), the process of creating and maintaining master data. As per definition Master Data Management (MDM) is a set of coordinated processes, policies, tools and technologies...
2011-10-13
408 reads
MDM (Master Data Management) Business Scenario
IntroductionMaster Data Management (MDM), the process of creating and maintaining master data. As per definition Master Data Management (MDM) is...
2011-10-13
1,212 reads
BI on SQL Azure
Introduction
A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data Warehouse (DW) and Business Intelligence (BI) is...
2011-07-20
32 reads
BI on SQL Azure
Introduction
A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data...
2011-07-20
530 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 [email protected] 8 [email protected]If 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