Understanding Azure Storage Options
The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.
Expect the Unexpected with DiRT
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
UNION vs. UNION ALL in SQL Server
Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
Proactive Performance Tuning
Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.
Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework
This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.
HSA for Training
Is there a good way to ensure employees get trained? Steve has a few thoughts today on an idea that could help.
It's More Than What You Know
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
What’s in that database? Getting information about routines
There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
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