What was I thinking? Deleting myself from localdb?
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
328 reads
How Do You Know You’re Good At Your Job?
You’ve been working as a DBA for X number of years. How do you know you’re good at it? Heck,...
2015-07-13
612 reads
Thoughts on Power Query and SSIS
Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10,...
2015-07-13
2,566 reads
Power BI General Availability Announced: July 24, 2015
On Friday, James Phillips, Microsoft VP of Business Intelligence, announced the general availability of the new Power BI Business Analytics...
2015-07-12
258 reads
Power BI General Availability Announced: July 24, 2015
On Friday, James Phillips, Microsoft VP of Business Intelligence, announced the general availability of the new Power BI Business Analytics...
2015-07-12
776 reads
Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen
I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...
2015-07-11
237 reads
Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen
I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...
2015-07-11
669 reads
COLUMNSTORE INDEX… DEMO
COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...
2015-07-11
2,558 reads
Columnstore Indexes – part 59 (“Aggregate Pushdown”)
Continuation from the previous 58 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
SQL Server 2016 brings a number of...
2015-07-11
838 reads
Do you know about Whatsapp web?
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of distinctively decent competitors they have within the space of...
2015-07-11
14 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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