Detaching corrupt databases
Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...
2016-10-04
612 reads
PowerShell: Extending Modules – System Parameter measurement
The Microsoft Technet Guru Award (August 2016) winning article – Silver
PowerShell: Extending Modules – System Parameter measurement
PowerShell: Extending Modules – System Parameter measurement
Abstract
The...
2016-10-03
976 reads
Rename a Server with PowerShell
I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default...
2016-10-03
1,594 reads
Correlated Datetime Columns
SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...
2016-10-13 (first published: 2016-10-03)
1,812 reads
Mastering Index – Clustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take...
2016-10-03
533 reads
Becoming a Microsoft MVP
I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...
2016-10-03
647 reads
Future DBA – Big Data -MongoDB 1
We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution...
2016-10-03
491 reads
Query Store – Quick Tour
The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”....
2016-10-03
463 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...
2016-10-02
759 reads
An observation about Unicode in SQL Server Management Studio
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,271 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers