Getting Started With DocumentDB
I’ve put this off for too long. It’s time to get my feet wet with some new tech.
Step 1 is...
2015-10-14
564 reads
Drill Down with Power BI Visualizations
A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...
2015-10-14
420 reads
Drill Down with Power BI Visualizations
A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...
2015-10-14
2,040 reads
Dynamically Read event_file Data
There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...
2015-10-14
12 reads
Dynamically Read event_file Data
In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...
2015-10-14
855 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
33 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
80 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning...
2015-10-14
1,657 reads
SSMS in High-DPI Displays: How to Stop the Madness
I spent the last few weeks travelling a lot compared to my usual routine and I got quickly fed up...
2015-10-14
41,330 reads
Auditing Needs Reporting
No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...
2015-10-13
9 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