Recent Reading: The Food Network, And The White House!
I haven’t posted much on books lately, here are two that are different:
Inside the Food Network. Definitely some gossip, but...
2014-06-03
353 reads
Busy Busy Weeks, Finally Some Good News! SQL 2008 / 2008 R2 Will Get Their Final Service Pack!
We will actually be getting our final Service Pack!
The information can be found here. You may still want extended support...
2014-06-03
661 reads
I'm A Candidate For The 2014 PASS Nomination Committee
The 2014 PASS election cycle begins today when voting opens for the Nomination Committee (NomCom) and I'm one of eleven...
2014-06-03
1,122 reads
Attaching All Databases with PowerShell–Attaching Missing Databases
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-06-03
1,296 reads
Columnstore Memory Grant Issue
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...
2014-06-03
2,206 reads
SQL Server 2014 Cluster Installation Steps
Steps for SQL Server 2014 Cluster Installation :-
1) Lunch SQL Server Installation Center
2) Enter Product Key
3) Accept License
4) Check Global...
2014-06-03
12,604 reads
I’m A Candidate For the PASS 2014 Nominating Committee
I submitted my application for the NomCom on May 21 and after the review process we’re now in “campaign week”....
2014-06-02
659 reads
Announcing SQL Summer Camp
A new way to train in SQL Server.
I had an idea a few years back about a training event unlike...
2014-06-02
681 reads
Last Weeks Top “Reading” Links #86
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-06-02
427 reads
PASS 2014 Nomination Committee
I’m officially on the slate and running for the PASS 2014 Nomination Committee!
Why should you vote for Ryan?
I love the PASS...
2014-06-02
621 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