Speaking at MagicPASS on May 28, 2014
If you’re wondering who the mystery speaker is – it’s me! I’ll be doing two presentations at Magic Pass on May...
2014-05-08
341 reads
SQLSaturday in Houston
This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info). I hope to see you...
2014-05-08
790 reads
Recent Event Recap
These last few weeks have been quite a blur of projects, travel, and end-user training, and I’m enjoying every bit...
2014-05-08
735 reads
Getting Local Books Online
One of the things that’s annoyed me in the last few versions is that Books Online isn’t smoothly installed for...
2014-05-08
891 reads
The Importance of Networking
In a survey conducted by Business Network SW, the organization found that 87% of businesses partake in some form of...
2014-05-08
596 reads
SQL Server is not a toy
I began my career working with Sybase on UNIX. Everything was done via the shell. There were strong practices in...
2014-05-08
798 reads
Artikel „SQL Server 2014 – Neues Fundament“ in iX Ausgabe 5/2014, Richtigstellungen zu In-Memory OLTP und ColumnStore Indexes und warum AlwaysOn nicht gleich Always On ist
Article “SQL Server 2014 – New Fundament” in iX Issue 5/2014, corrections in In-Memory OLTP and ColumnStore Indexes, and why AlwaysOn...
2014-05-08
1,235 reads
Size Matters: 2 Products to Accelerate SQL Traffic
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,187 reads
Secure Coding
I was looking recently for some sort of guideline that would help me ensure that code was securely written. I...
2014-05-07
841 reads
Help - I Need a List of my Maintenance Plan Jobs *and* Schedules!
UPDATE - Jason Brimhall (blog/@sqlrnnr) pointed out after reading this post that there is a more inline way to do a...
2014-05-07
7,802 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