July Already...
Amazingly its July already, the year is flying by. With a very busy July and August lined up and a...
2016-07-04
413 reads
Gethyn Ellis
BREXIT…IT professionals need a plan… much like the UK government
The events that have unfolded over the last few days since the shock result that the BRExit referendum delivered, has,...
2016-06-28
496 reads
IT Training: Super Duper Deal!!
In the wake of last week’s BREXIT vote and subsequent fallout, I decided to delay making this announcement until today....
2016-06-27
424 reads
SQL Server 2016 RTM – Is Anyone Still Waiting for the First Service Pack?
Well most of the SQL Server news last week focused around the launch of SQL Server 2016. SQL Server RTM...
2016-06-09 (first published: 2016-06-06)
4,212 reads
Word-wrap in SQL Server Management Studio
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-12 (first published: 2016-05-04)
4,297 reads
Putting your Head in the Clouds–An Introduction to Cloud Computing and Microsoft Azure
If you attended David’s session Putting your Head in the Clouds today at SQL Bits today you can download the...
2016-05-07
410 reads
Go and See David’s Session at SQL Bits on Saturday
In yesterday’s blog about the latest version of David’s book on SQL Azure I mentioned David was delivering his SQL...
2016-05-06
397 reads
Free eBook – Azure SQL Databases
PuttingYour Head In the Cloud An Introduction to Cloud Computing and Azure SQLDatabases by David Postlethwaite has been revised in...
2016-05-05
620 reads
Word Wrap in SQL Server Management Studio
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-04
3,006 reads
Weekly Round-up 30 April 2016
It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and...
2016-05-03
368 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
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