The BI Journey: The Journey Begins
Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after the initial success, plans are made to sustain and grow the project.
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
Group Managed Service Accounts (gMSAs) in SQL2016
Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON
Practice Those Scripts
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
What’s Better, CTEs or Temp Tables?
Brent get's asked this question a lot, so here he has set up an example with the Stack Overflow database. His query’s goal is to find the top 5 Locations, and list the users who live in those top 5 Locations, alphabetized by their DisplayName.
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
Using VMware VMDKs for SQL Server Database Cloning
Learn how you can clone a database with a VMDK virtual disk to store your data.
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft made SQL Server images on Docker available. In this article, Carlos Robles explains how to get started with Docker when running macOS.
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
SandDance in Azure Data Studio
In this tip we look at how to use SandDance a powerful data visualization tool that is an extension to Azure Data Studio.
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