System Base Tables
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base tables in that article. Today, I want to dive...
2012-01-30
16 reads
System Base Tables
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base...
2012-01-30
1,435 reads
Blogging: Starting a Blog
Following on from the first post in my blogging series Building a Blog I’m just going to take a quick...
2012-01-30
780 reads
SQL server – ISNUMERIC and checking for valid numeric tyopes
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16,...
2012-01-30
1,074 reads
2012-01-29
11 reads
2012-01-29
13 reads
2012-01-29
10 reads
2012-01-29
28 reads
Detect Worst Performing SQL Queries
This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL...
2012-01-29
772 reads
Rebuild System Databases
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...
2012-01-29
3,422 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