Presenting Two Sessions at SQLRally
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
983 reads
A Script A Day - Day 22 - Database Backup
Today’s script follows on from Day 16’s script which was about database restores. In a backwards way the script is...
2012-02-27
616 reads
A Script A Day - Day 21 - The HAVING Clause
Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...
2012-02-27
552 reads
Trello: An agile style kan-ban web app that really works
I am no different to many others where I am being asked to work on various projects concurrently and expected...
2012-02-29 (first published: 2012-02-27)
2,903 reads
High Availability 9's
This is very important to understand what is high availability 9's, This is a measurement of high availability where you can tell...
2012-02-27
723 reads
2012-02-27
14 reads
2012-02-27
13 reads
2012-02-27
13 reads
2012-02-27
14 reads
Detect Worst Performing SQL Queries – Part 3
Best way to tune production server is to find out what are the queries executed in a particular duration and...
2012-02-27
887 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