Technical Presenters – Make your point
I caught this blog post, Who says technical presentations can't be engaging?, today thanks to Dana Coffey (@crazeegeekchick on Twitter). ...
2009-08-03
336 reads
Blog Posts
The Basic Truths about Data
In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that...
2009-08-03
402 reads
What's new in Sql Server 2005
Its very difficult to write what all new in Sql server 2005, almost everything is new... the complete engine has...
2009-08-03
731 reads
Brian Knight’s Texas Tornado Tour!
Its been fun and fulfilling getting neck deep into the Central Texas Capitol Area Users of SQL Server again after...
2009-08-02
501 reads
Fusion-IO Update
I’ve done all the testing I can do for now. There were some unexpected developments that I will cover in...
2009-08-02
557 reads
LinkedIn References
One of the interesting features of LinkedIn is the ability to post a reference about a connection. If you think...
2009-08-02
880 reads
Active August #1
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...
2009-08-01
624 reads
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
2009-08-01
1,129 reads
Revive your User Group, part IV
Over the past three posts in this series entitled “Revive your User Group”, I’ve shared some of best practices that...
2009-08-01
523 reads
Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,415 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