Handling Type II Dimension with the MERGE Statement
Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS. However, as we all know...
2010-11-17
2,014 reads
Dynamically Backing Up All User Databases in SQL Server
I recently had a request from a client to come up with a routine to do a full compressed database...
2010-11-16
1,422 reads
SQL Server Team-Based Development
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,169 reads
PASS Summit Report 2: Seattle Again?
There is always a lot of talk about the fact that we have been in Seattle several years in a...
2010-11-16
1,163 reads
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
2010-11-16
2,445 reads
SQL Server 2008 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes...
2010-11-16
1,011 reads
The World’s Largest
Each year, the Georgia Bulldogs and the Florida Gators meet on the college grid iron in what’s called the world’s...
2010-11-16
534 reads
PASSMN Meeting Today
Check us out today by either traveling down to Bloomington or jumping in and joining us online. Today Minnesota’s SQL...
2010-11-16
767 reads
PASS Update #47–Election Review Committee
As always, this represents my own views, I’m speaking only for me and not the entire PASS Board.
Early last week...
2010-11-16
681 reads
What's New In Denali for SSRS
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-16
481 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