SQL Server 2014 New Features
SQL Server 2014
Below is a listing of the SQL Server 2014 new features and where you can find more information...
2014-07-02
1,948 reads
The Selection Process
According to this post from Amy Lewis (PASS Board of Directors) there were 943 abstracts submitted for the 2014 PASS...
2014-07-02
576 reads
The Case Of the Downward Pointing Arrow-Question of the Day
The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at...
2014-07-02
443 reads
Above Reproach
It’s been a busy few weeks in the world of PASS, lots of good conversations that I’ve followed with interest,...
2014-07-02
873 reads
Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !
The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since...
2014-07-02
9 reads
Speaking at ONETUG on July 10, 2014
I’ll be presenting SQL Server Performance for Developers to the members of the Orlando .Net User Group (ONETUG) on July...
2014-07-02
484 reads
Cumulative Update – 13 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 13th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the...
2014-07-02
17 reads
HA and DR Precon in Denver
I’ll be doing a precon for SQLSaturday #331 in Denver Colorado on September 19th, 2014 titled “A Day of High Availability and...
2014-07-02
686 reads
Statistics and Natively Compiled Procedures
Statistics are one of the single most important driving factors for the behavior of the query optimizer. The cardinality estimates...
2014-07-03 (first published: 2014-07-02)
2,207 reads
Argenis and the unicorn hoodie
Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a...
2014-07-02
700 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