Filetable–Nesting folders and files
In previous posts I showed how to create a folder in a Filetable and also how to the create (and...
2014-05-12
1,094 reads
Writing Another Question of the Day
The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...
2014-05-12
360 reads
Last Weeks Top “Reading” Links #83
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-12
879 reads
Notes From SQLSaturday #298
The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....
2014-05-12
433 reads
Making a Difference – #SQLFamily
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,213 reads
SQL Saturday Houston
I spoke for my first time at a SQL Saturday in Houston this past week. I had a lot of...
2014-05-12
736 reads
How to Fix that Never-Ending Join Dragging Down the Whole DB Server Instance – Pre-Populate the Largest Bugger in Temp with Indexes
Now that it has been a
good five years I have been blogging away here and on SSC, the editors recently thanked
us...
2014-05-12
1,064 reads
Boost the performance of the VMware vSphere Web Client
Ever since it was released, the vSphere Web Client is not the most responsive of web GUIs. After some digging,...
2014-05-12
438 reads
Add Node to Windows Server 2008 Cluster
Steps : Add Node to Windows Server 2008 Cluster
1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node
2)...
2014-05-12
1,902 reads
Presentation slides for Houston SQLSaturday
Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info). Here are the abstracts and PowerPoint links:
Best...
2014-05-12
924 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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