Effective Permissions on a Database
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,336 reads
Gethyn Ellis
We have a new contributor…
In order to keep the content fresh and the posts flowing here on my blog I have decided to publish...
2011-07-13
596 reads
Can you delete from a view?
I have seen this question come up several times over the last few months. Can you delete from a view?...
2011-07-11
57,694 reads
vCentre Useful Queries: Part II
After posting on twitter last week that I needed something to write a blog post about my good friend Christian...
2011-06-15
684 reads
vCentre Useful Queries: Part I
After posting on twitter last week that I needed something to write a blog post about my good friend Christian...
2011-06-14
852 reads
Planes Trains and Automobiles
I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...
2011-06-10
507 reads
Calling all UK Bloggers…
Amazingly It’s been just over 4 months since I started my list of UK based SQL Server bloggers, and I...
2011-05-03
595 reads
A Royal Wedding: A Day Off
This is a little off topic:
Well Well, it’s the 29th April and all being well in about 2 hours from...
2011-04-29
1,530 reads
It’s a Deal, It’s a Steal…
Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or...
2011-04-27
643 reads
Microsoft Certification Exams: Costs are Increasing
It was announced yesterday that the cost of taking a Microsoft exam will increase from the 1 July. In the...
2011-04-27
2,403 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
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