Grant View Server State
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
95,365 reads
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
95,365 reads
One of the items I always flag when performing a health check on a server is whether backups are being...
2014-03-28 (first published: 2014-03-25)
3,611 reads
Hi all, I’ve started a new job with eBECS which is a Microsoft Gold Partner in the ERP Business. Since...
2014-03-25
793 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31 (first published: 2014-03-25)
2,367 reads
Tomorrow evening I have the honour of speaking at Microsoft’s office in Clausen, Luxembourg. The session I will be presenting...
2014-03-25
792 reads
Tomorrow at 11am PST I will be holding a free webinar, hosted by Tegile Systems, entitled ‘Avoiding Common SQL Server Virtualization Pitfalls‘.
The...
2014-03-24
772 reads
Once again it is an honor to attend such a great event and meet up with other like minded geeks....
2014-03-24
478 reads
This coming weekend is the SQL Saturday #287 in Madison, Wisconsin. It’s my first time at this particular SQL Saturday,...
2014-03-24
629 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-24
1,387 reads
Nice to have a SQL track! Looked like it averaged 20-25 attendance per session.Ran smooth, thanks to Esteban Garcia and...
2014-03-24
527 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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