What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
14 reads
Blog Posts
Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
992 reads
Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
711 reads
Free SQL Server Training for the Week of September 20, 2010
Monday
PASS Data Warehousing/BI Virtual Chapter - Adaptive BI: Engineering a BI Solution - Davide Mauri
Tuesday
SQL Lunch - Restartability in SSIS - Kyle Walker
Pragmatic Works...
2010-09-20
662 reads
Home Theater Upgrades
Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home...
2010-09-20
624 reads
Kimball University: Microsoft Data Warehouse in Depth
Several years ago, late 2006, I decided to focus my career on Data Warehousing and Business Intelligence (DW/BI). I was...
2010-09-20
1,174 reads
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
In my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers....
2010-09-20
908 reads
PASS Update #43
Last Friday saw the end of the 2010 PASS election and it was very nice to find out I had...
2010-09-20
633 reads
Review: Choosing to Cheat
Cross-posted from The Goal Keeping DBA blog.
I first heard about this book at SQL Saturday #51 when I was talking...
2010-09-20
868 reads
Roadtrip! SQL Saturday #53 - Kansas City
After speaking this coming weekend in Denver at SQL Saturday #52, I’m heading to SQL Saturday #53 in Kansas City...
2010-09-20
829 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