Untrusted FK's demo + ADS notebooks
Back in 2012 at SQLSaturday Pensacola, I did a lunch-time lightning talk on indexing, which was supposed to have a big finale on how FK's could silently help with...
2019-05-29
19 reads
Demo: Predictive Modeling using R and SQL Server Machine Learning Services
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-05-28
46 reads
Demo: Predictive Modeling using R and SQL Server Machine Learning Services
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-06-17 (first published: 2019-05-28)
730 reads
Leadership Part 1: Team building
One of the most challenging aspects of being a good leader is building a team that can support the initiatives you will set forth. Without a team that will...
2019-06-14 (first published: 2019-05-28)
465 reads
Container: More on Volumes
In my last post I showed how you can create a volume with your container. I then showed a few things you can with a container using a volume....
2019-06-17 (first published: 2019-05-28)
245 reads
What is a distributed transaction?
A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading
2019-06-13 (first published: 2019-05-28)
828 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week’s video on YouTube. Thanks to you, we just crossed the 2k subscriber mark! Over the past several week’s I’ve been exploring ways to rewrite queries to improve...
2019-06-13 (first published: 2019-05-28)
3,774 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
40 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
11 reads
Speaking at Events
G’day, I recently got the opportunity to speak at the “PASS Marathon, The New World of Data Privacy”. I had not spoken at a virtually event for quite some...
2019-05-28
15 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers