Last Week Reading (2019-03-03)
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare...
2019-03-03
312 reads
SSMS tip: Splitting the same query window
This is a trick I use in SQL Server Management Studio at least once a week.
Today’s scripts will be screenshots...
2019-03-18 (first published: 2019-03-02)
3,205 reads
Transforming Data With Azure Data Factory Data Flow
Azure Data Factory (ADF) offers a convenient cloud-based platform for orchestrating data from and to on-premise, on-cloud, and hybrid sources...
2019-03-01
2,099 reads
Cruel Joke: Prevent SQL Server From Starting, and With (Almost) No Indication Why
(last updated: 2019-03-07 @ 15:40 EST / 2019-03-07 @ 20:40 UTC )
I ran across something the other day that I thought would be...
2019-03-15 (first published: 2019-03-01)
3,723 reads
Practical Web Scraping–More Reading
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-03-01
628 reads
Restoring a Database from Azure
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This...
2019-03-01
521 reads
Published in the ISACA Journal!
In my effort to write more regularly, I’ve branched out a bit to write in the audit and compliance space....
2019-03-01
274 reads
Data story behind a Global Fishing Power BI report
(2019-Mar-01) The first time I heard about the Data For A Cause initiatives was at one of the Power BI meetups in Toronto....
2019-03-01
823 reads
It’s always parameter sniffing: Line Endings
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
957 reads
What Data Is Being Sent Externally By Power BI Visuals?
As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...
2019-02-28
61 reads
Blogs
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...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
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