Autumn Update - Trick or Treat
Its been a busy few weeks for me, most of that outside of gethynellis.com I’m in the process of moving...
2016-11-01
482 reads
Gethyn Ellis
You don't need any Training? OK...I believe you.
This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...
2016-10-13
442 reads
SQL Friday: Weekly Round up 30th September
This week has been a relatively relaxed week for me. I had a one-day onsite event in Cardiff on Wednesday...
2016-09-30
802 reads
How to Setup Kerberos Correctly
David was in Copenhagen this weekend delivering his Kerberos talk Taming the Beast: Kerberos for the SQL DBA to SQL...
2016-09-29 (first published: 2016-09-20)
3,039 reads
Want to Win a Free @LearningTree Course? #LtreRox - @tangentc is the first ever twitter winner!!!
As regular readers of this blog will know I teach some data courses for Learning Tree. Recently Learning Tree has...
2016-09-29
788 reads
Connecting to Twitter with R and RStudio
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect...
2016-09-28
1,162 reads
SQL Relay 2016
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and...
2016-09-27
504 reads
TGI SQL Friday: Weekly Roundup 23rd September
Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the...
2016-09-23
519 reads
Have you Upgraded From SQL Server 2005?
My first Learning Tree SQL Server Newsletter that was sent out back in August was titled SQL Server 2016: Keeping...
2016-09-22
469 reads
Building Oracle 12c on Linux 7 on Hyper-V
David has written a white paper, or short ebook titled building oracle 12C on Linux 7 VM residing on Hyper-V....
2016-09-19
460 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers