How to Data Compress Varchar(MAX)
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
8,036 reads
SSIS: Transfer SQL Server Object using SMO
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,583 reads
Visio 2010 Forward Engineer Add-in
Somehow I missed this gem that’s been around for quite a while so I thought I would share it in...
2012-08-08
2,406 reads
Three Generations of Toshiba Portege Laptops Compared
Since I am a bit of a hardware enthusiast, I tend to buy new computer hardware a little more often...
2012-08-07
2,047 reads
Removing a DDL Trigger
In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d...
2012-08-07
951 reads
SQL Server: List Explicit Permission on Database for Login and Database Role
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,501 reads
Colorado SQL - August 2012
This month Kevin Kline will be presenting "End to End Troubleshooting" at the Boulder, Colorado Springs, and Denver SQL Meetings
Summary:...
2012-08-07
643 reads
SQL Server 2012 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-08-07
1,045 reads
PASS Update #2 - February 2012 Recap
During the January board meeting we were told that attendance at the 2011 Summit exceeded expectations and as a result...
2012-08-07
630 reads
PASS Update #1 - January 2012 Recap
When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...
2012-08-07
966 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
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...
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