Data Governance Policy
What is a Data Governance Policy?
Data governance policy is concerned with how an organization collects, stores, accesses and maintains its...
2016-09-19
2,421 reads
Business Intelligence and Enterprise Architecture
Text Mining Loch Ness Monster Sightings
Text Mining with RapidMiner for Loch Ness Monster Sightings
Text mining involves pulling root words from text in a system. In...
2016-02-11
501 reads
What is RapidMiner
RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner. RapidMiner is an open...
2016-01-21
570 reads
Azure Data Catalog
Azure Data Catalog
Now available in public preview is the Azure Data Catalog. The Data catalog provides an enterprise data repository...
2015-09-08
682 reads
SQL Server 2016 Stretch Database
SQL Server 2016 Stretch Database
One of the features in SQL Server 2016 that you will want to explore is the...
2015-08-17
1,298 reads
Machine Learning Data Sets
Machine Learning Data Sets
When starting out with data mining and machine learning you will need to have access to sample...
2015-08-07 (first published: 2015-08-04)
2,897 reads
SQL Server Polybase (2016)
What is SQL Server Polybase?
Coming in SQL Server 2016 is the ability to query relational tables as well as data...
2015-07-20
1,328 reads
HASSUG BI Developer Presentation on 7/14/2015
I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session...
2015-07-19
647 reads
Leveraging SQL Server Database Schema
Leveraging SQL Server Database Schema
Data warehouses typically pull data from various sources and combine the data into a common repository....
2015-06-24
689 reads
CDO Summit Toronto June 4th
I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th. My session is on...
2015-05-24
446 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
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...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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