2019-06-19
845 reads
R Language
SQL Server and R with dplyr Package Examples for mutate, transmute, summarise, group_by, pipe and filter
In this second part of this tip series we take a look at the dplyr package for R that can be used to query data using the R Language with SQL Server and build data visualizations.
2019-06-07
2019-06-05
611 reads
2019-05-29
498 reads
2019-05-24
Converting data from long to wide and from wide to long simplified: tidyverse package
Are you interested in guest posting? Publish at Da...
2019-05-23
2019-05-22
738 reads
2019-05-22
Part 2: Simple EDA in R with inspectdf
Quickly and easily explore your data set in R with the Inspectdf function!
2019-05-20
Earthquake Analysis (4/4): Cluster Analysis
Interested in guest posting? We would love to share your codes and ideas with our community.
Category
Basic Statistics
Tags
Data Visualisation
Maps
This is the fourth part of our post series about the exploratory...
2019-05-20
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...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
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