SQL Homework – May 2020 – Forum Lurking.
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among ... Continue reading
2020-05-04
30 reads
Deleting packages from SSIS Catalog
I was fortunate to attend a training on SSIS by my good friend and SSIS expert Andy Leonard(b|t). We already use the tool for ETL purposes where I work...
2020-05-18 (first published: 2020-05-04)
966 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
30 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
752 reads
ASF 031: Paul Andrew interview
Introduction Paul Andrew. Principal consultant and architect at Altius specialising in big data solutions on the Microsoft Azure cloud platform. Data engineering competencies include Azure Data Factory, Data Lake,...
2020-05-02
9 reads
ASF 031: Paul Andrew interview
Introduction Paul Andrew. Principal consultant and architect at Altius specialising in big data solutions on the Microsoft Azure cloud platform. Data engineering competencies include Azure Data Factory, Data Lake,...
2020-05-20 (first published: 2020-05-02)
151 reads
Data Community #DataWeekender Europe 2020: Ethics in Modern Data
On Saturday May 2 Christine and I are presenting at the Data Community #DataWeekender Europe 2020 online conference, an all-online free virtual popup Microsoft Data Conference hosted by various professionals...
2020-05-02
22 reads
Replicating SQL IN operator in Azure Data Factory
(2020-May-01) There is a current limitation in Azure Data Factory (ADF) to accept only two conditions for the OR function.You won't be able to specify the following expression to evaluate...
2020-05-19 (first published: 2020-05-01)
1,425 reads
Goal Progress–Apr 2020
Time for my monthly progess report on goals. I set goals and had an update last month. This month, I’ve had a reminder for 4 days that says “work...
2020-05-01
24 reads
Running SQL Server on my Mac with Docker
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-01
14 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