Breaking: SQL Server 2014 RTM in two weeks
Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted...
2014-03-18
820 reads
Parallel Data Warehouse (PDW) benefits made simple
I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret. So let me give a...
2014-03-18
2,469 reads
Where is my Availability Group?
In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the...
2014-03-21 (first published: 2014-03-18)
2,978 reads
Finding Mistakes
Ever had that moment where you start getting errors from code that you’ve tested a million times? I had that...
2014-03-18
784 reads
Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!
I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server...
2014-03-18
529 reads
A Minute About Minute Key
You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let...
2014-03-18
734 reads
Performance improvements in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-18
1,269 reads
DBAs should be on CLOUD 9 - IT Trends
For all the talk and initial fear that the DBA is going the way of the Dodo (pronounced doh-doh) (an...
2014-03-18
2,104 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 1
This post is part of the SQL Community Project #DBAJumpStart by John Sansom.
“If you could give a DBA just one...
2014-03-18
772 reads
A New Day at #Ntirety
We - the rank-and-file employees at Ntirety - received word yesterday that we had been acquired by Hosting, a cloud and network...
2014-03-18
591 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