How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as...
2014-07-14
16,135 reads
Reblog: July 4 to July 10
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-07-11
370 reads
Free Ebooks From Microsoft
Probably you’ve heard about it already, but a quick post just in case – you can download a 100 or so...
2014-07-11
1,003 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we...
2014-07-11
588 reads
Notes from the July 2014 ONETUG Meeting
Rained as I left (early) for the meeting, confirming again why I always leave early – stuff happens (in Orlando, rain...
2014-07-11
677 reads
Speaker of the Month, July 2014
Another month another bunch of great presentations. I almost don’t want to do this any more. It’s hard. I sit...
2014-07-11
568 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this...
2014-07-11
3,456 reads
Friday Followup For July 11, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-07-11
287 reads
Creating a Matrix Infographic in SSRS
With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to...
2014-07-11
1,074 reads
db_ddladmin and the SSMS table designer
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you...
2014-07-10
975 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