PASS Update #62
Our most recent Board meeting was Aug 11 & 12 in Ft Lauderdale (located so we could attend SQLSaturday on Saturday)....
2011-08-24
610 reads
Blog Posts
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else....
2011-08-24
2,970 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else. In SQL, we should be well aware of Precision...
2011-08-24
18 reads
Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster
This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node...
2011-08-24
1,305 reads
2011-08-24
7 reads
2011-08-24
31 reads
2011-08-24
8 reads
2011-08-24
9 reads
Replication Agent Logging
To troubleshoot replication agent failures, replication agent profiles can be configured to output verbose agent logs to a text file. ...
2011-08-24
4,430 reads
Season of Satan - Earthquake, Hurricanes, Jitters & Twitter
I read Andy Leonard's Blog on Earthquakes and Technology, who thought a helicopter was landing in his back yard (LOL), and inspired...
2011-08-24
1,193 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