Should a DBA be involved in the physical set up of a Database server? Part 2
Part 1 of this blog talked about the bad experience we had with a badly configured SQL Server. The second...
2011-04-06
1,612 reads
Blog Posts
SQL Injection: It's not just about your data
On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...
2011-04-06
1,116 reads
SQL PASS ERC: How to Score the Interview?
One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...
2011-04-06
1,361 reads
SQL Saturday #63–Dallas
I have been trying to get to Dallas for a SQL Saturday for nearly a year, when the first event...
2011-04-06
1,398 reads
SQL Saturday #63–Dallas
I have been trying to get to Dallas for a SQL Saturday for nearly a year, when the first event...
2011-04-06
873 reads
SQL University: Index Usage
Greetings. Welcome once more to the Miskatonic University branch of SQL University. Does anyone know where to buy some camping...
2011-04-06
887 reads
A SQL Server Hardware Nugget A Day – Day 5
For Day 5, I will be covering a few tools that can be used for hardware identification. Since quite a...
2011-04-05
620 reads
Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali
I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL...
2011-04-05
608 reads
Am I a sysadmin? (or other SQL Server role)
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-05
24,217 reads
Canada Begins Return to Democracy as the ‘Harper Government’ Found in Contempt of Parliament, a First Throughout the Commonwealth – And No Confidence Vote Triggers the Election Race
For over a week now, Canada has begun its return to appearing to be a democracy thanks to a Liberal...
2011-04-05
1,221 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