Why I Love SQLBits
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...
2016-05-08
1,235 reads
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...
2016-05-08
1,235 reads
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...
2016-05-08
166 reads
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...
2016-05-05 (first published: 2016-04-25)
2,841 reads
Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...
2016-03-01
319 reads
Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is...
2016-02-28
703 reads
So you’ve been working as a DBA or a BI developer for several years now. You know your stuff very...
2016-02-21
364 reads
Few days ago (28/12) I delivered a full-day seminar about Hadoop Fundamentals. It was part of the Expert Days 2015...
2015-12-30
951 reads
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
551 reads
Have you heard about Hadoop, but never really understood what it’s all about?
Do you need to learn about Hadoop, either...
2015-12-14 (first published: 2015-12-10)
3,421 reads
Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....
2015-11-19
713 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Title pretty much says it. I want to join to a table that has...
Comments posted to this topic are about the item Building a SQL Server Fleet...
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