Blogging – goal achieved – 72 days early
So I started blogging in 2016: So why blog….now? It is very interesting going back and reading that first blog post. It was mostly thanks to my late great...
2019-10-21
36 reads
HeyMo0sh
“xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun” – git in terminal does not work after macOS upgrade to Catalina
This blog post is how to get git going after upgrading to Catalina (10.15). I use git as a method of storing all my presentations and work files. It...
2019-10-19
1,785 reads
GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)
This blog post is about the situation where after upgrading to the latest macOS version 10.15 – also known as Catalina – you may not be able to share...
2019-10-18
73 reads
The Data platform has evolved – so too must the DBA.
This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...
2019-07-22
295 reads
“An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found” – during SQL Server 2017 install
This blog post is about a situation that initially perplexed me – I was installing SQL Server 2017 onto a new DEMO machine – running Windows Server 2019. This...
2019-07-19
28,366 reads
Quick 6 month check – how are those learning goals going…?
So in January I wrote a blog post on some goals I had this year: Some of my goals for 2019 It’s now July – how are things going?...
2019-07-19
19 reads
How to resolve ‘Login failed for user’ and sa password lost (Error 18456)
This blog post explains how to get into SQL Server if you have lost your sa password or you have...
2019-03-11 (first published: 2019-02-23)
4,553 reads
Can you speak at my User Group or Conference? No? Sweet As – can you help people register please?
This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing...
2019-03-07
302 reads
Authentication considerations for your applications when migrating to Azure SQL Managed Instances
This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...
2019-01-29
356 reads
Azure SQL Managed Instance – full blown SQL Server in the cloud….?
This blog post is one that I have had percolating in the background since around November 2018.
My good mate John...
2019-01-29
1,182 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers