Leveraging WHILE LOOP
WHILE LOOP can be used for batch processing and can be helpful if you are dealing with huge data processing. Recently I did an analytics project where I had...
2019-10-09
36 reads
Using indexed views? Don’t forget this important tip.
Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome in the right context!),...
2019-10-09
55 reads
SQL Server Virtual Machines in Azure
Let’s create a virtual machine in Azure that has an imaged copy of SQL Server on it. I want to do this because down the line I want to...
2019-10-09
113 reads
Employees don’t work for you; you work for them
Alex Yates (b | t) is hosting this month’s T-SQL Tuesday (the 119th edition) with asking us to write about something in our IT career that we have changes our minds...
2019-10-15 (first published: 2019-10-09)
770 reads
Dynamic Column Level Security with Power BI and SSAS
Last week I was asked to tackle a requirement by a customer adopting Analysis Services to enable data exploration and ad hoc analysis by their users. One of their...
2019-10-15 (first published: 2019-10-09)
843 reads
T-SQL Tuesday #119 – What changes my mind
T-SQL Tuesday series (the monthly blog party) has been started by Adam Machanic and co-ordinated by Steve Jones. This month’s topic is hosted by my friend Alex Yates. He...
2019-10-08
22 reads
T-SQL Tuesday #119–Changing My Mind
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
22 reads
SQL in the City/PASS Summit
My great organization, Redgate, is doing things a little different this year at PASS Summit. Instead of hosting our own event, we’ve decided to host a pre-con at the...
2019-10-08
58 reads
T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
18 reads
T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
65 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