SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,925 reads
Blog Posts
ACID
What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the...
2010-09-17
2,207 reads
CakeWrecks
Recently I had a student point me to CakeWrecks, a blog about good cakes gone bad.The post from today has...
2010-09-17
557 reads
Do You Have Influence? Part 2
I started writing on influence last week and promised some comments on how to build influence and credibility. There are...
2010-09-17
1,360 reads
I Don't Want to Share!
I know we were taught to share in kindergarten, but there are some things that should not be shared. In...
2010-09-17
576 reads
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that's been useful to me recently. This MDX statement creates...
2010-09-17
2,481 reads
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
498 reads
SQL Saturday #52 in Denver
Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held...
2010-09-17
648 reads
SQLSaturday #52 – Colorado Here I Come!
Well, I’ve been waiting to book hotel and rental car for SQLSaturday #52 – Colorado because I wasn’t sure if my...
2010-09-17
357 reads
StreamInsight sample from my 24HOP session
As announced in my StreamInsight session at 24HOP you can download the session material
from here.
Within the next weeks I will...
2010-09-17
539 reads
Blogs
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...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
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