Nested Partitioned Views
A few weeks ago I had a customer engagement, where the customer wanted to implement
Nested Partitioned Views. Before we go...
2012-09-27
3,015 reads
SQL Server 2012 AlwaysOn now officially supported by VMware
I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked...
2012-09-27
3,092 reads
An Introduction to SQL Server
There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...
2012-09-27
813 reads
No more NebraSQL
After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?) I have...
2012-09-27
769 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,760 reads
OVER() clause two simple ways on two different days
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,098 reads
SQL Server: Part 4 : Approaching Database Server Performance Issue
In the last three parts, we have discussed about different queries that can be used to list the current state...
2012-09-26
1,754 reads
DBMail on a cluster
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
635 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
901 reads
WIT Wednesday
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-09-26
1,140 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