Disabling Indexes
Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...
2019-02-18 (first published: 2019-01-28)
2,467 reads
Cool Stuff in Snowflake – Part 4: Aliasing all the things
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2019-01-28
798 reads
My alternative to sp_WhoIsActive
I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...
2019-01-28
5,319 reads
How to Encrypt and Restore Your SQL Server Database Backups
We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...
2019-02-19 (first published: 2019-01-28)
11,901 reads
Data Warehousing Tip #6 – Use a consistent unknown member key
In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And...
2019-02-18 (first published: 2019-01-28)
4,020 reads
Docker Swarm
As we studied the basics of Docker and container and containerization , Docker – is a open-source platform to have multiple light...
2019-01-28
424 reads
Central Management Server – not just three boring words
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
18 reads
Central Management Server – not just three boring words
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
21 reads
Can I add a custom reference layer to ArcGIS and use it in Power BI?
(2019-Jan-28) When you work with maps using ArcGIS visual in Power BI, you always have a feeling that it is a...
2019-02-15 (first published: 2019-01-28)
3,019 reads
Last Week Reading (2019-01-27)
Hello guys, a few internet posts that you might find interested. Press Azure SQL Analytics—Automating Deployment Apparently, it wasn’t an...
2019-01-27
184 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