How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these,...
2012-05-14 (first published: 2012-05-08)
8,006 reads
May 2012 – Monthly SQL Server Checklist
They say, “April showers bring May flowers.” But what if it doesn’t bring May flowers? What if instead you get...
2012-05-08
843 reads
Finding the Default Trace File
A post more for me than for anyone else, since I’ll look for something in the default trace and I...
2012-05-07
15,794 reads
SSAS: Duplicate Attribute Key Error
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message...
2012-05-07
1,348 reads
The Fantastic 12 of SQL Server 2012
The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the...
2012-05-07
1,046 reads
Updated SQL Rockstar Blogger Rankings
This morning, Thomas LaRock (blog|@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to...
2012-05-07
1,102 reads
Service Broker Sample: Multi-Threading
Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...
2012-05-07
515 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,416 reads
Denali — Day 7: Contained Database
Denali – Day 7 : Contained Database
Contained database is another new feature for sql server 2012 – Denali, earlier version has a big...
2012-05-07
1,231 reads
Moving from Droid X to Droid Razr Maxx
It’s been not quite two years since I moved from a Blackberry to a Droid X. The X turned out...
2012-05-07
544 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