PASS Events
PASS Summit
PASS Summit is the world’s largest and most intensive technical training conference for Microsoft SQL Server and BI professionals....
2014-06-10
683 reads
PASS Virtual Chapter Events: June 2014
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2014-06-10
623 reads
PowerShell – Perfmon Counters into CSV File – Multiple remote servers
Introduction
This script can be used for exporting specified performance counter values from multiple remote target servers to CSV file. The...
2014-06-10
630 reads
PowerShell – Perfmon Counters into CSV File – Multiple remote servers
Introduction
This script can be used for exporting specified performance counter values from multiple remote target servers to CSV file. The...
2014-06-10
1,535 reads
Editorial: Space Hoarders
I wrote Space Hoarders for SQLServerCentral, a discussion of why we – the DBA’s of course – are always blamed for the...
2014-06-10
479 reads
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...
2014-06-13 (first published: 2014-06-10)
2,062 reads
Data loss in clustered index occurs when you run online build index in SQL Server 2012
Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.
This morning I checked my...
2014-06-12 (first published: 2014-06-10)
2,747 reads
SQLSaturday #294 DBA 4 Dummies - post event commentary...
Had an awesome time at #SQLSat294 in Philly (MS HQ in Malvern, PA to be exact). Was great seeing the...
2014-06-10
1,546 reads
SQL Server High Availability and Disaster Recovery Options
Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the...
2014-06-11 (first published: 2014-06-10)
3,424 reads
2014-06-10
8 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