Review: 2013 Land Rover LR4 Overland Journal Edition
The guys at Overland Journal know how to adventure, and adventure well. Their magazines can be found both on coffee...
2014-02-20
905 reads
Restoring Filegroup backups on another server, and why it won't work...
We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.
One...
2014-02-20
4,975 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
512 reads
Lunch with someone new
I met up for lunch with a good friend and former coworker today, and among the topics of discussion was...
2014-02-19
856 reads
Free Mathematics Books – No really .. you want these!
Here is an alphabetical list of online mathematics books, textbooks, monographs, lecture notes, and other mathematics related documents freely available...
2014-02-19
613 reads
PASS Goals Published
Hopefully you got the email today from PASS containing these:
Volunteer GoalsProgram GoalsSQLSaturday GoalsReading them I’m first struck that we often...
2014-02-19
633 reads
Be Nice
Years ago when I was just out of the Marine Corps and found myself as the only IT guy in an...
2014-02-19
441 reads
Windows 2012 for the SQL DBA: .NET 3.5 Fails to Install
Hello Dear Reader! I know it has been a while since last we spoke. Sorry for the long absence. I've...
2014-02-19
847 reads
Taxonomy of Data Scientists
The 10 pioneering data scientists listed here were identified as top data scientists in our previous article entitled data science...
2014-02-19
470 reads
If You Plan to Publish A SQL Script–Some Suggestions
Nothing better than finding a script that does something you need done and often done better than what you’d put...
2014-02-19
731 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