I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.

70-457 Reviewer #02, What is Columnstore Index?

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...

2013-07-10

827 reads

Unlocking “Lock Pages in Memory” Option

Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...

2013-07-08

345 reads

It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...

2013-07-07

327 reads

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...

This is kind of a funny page to look at. The next page has...

A while ago I blogged about a use case where a pipeline fails during...

I have a table I didn't design that has tons of repeating groups in...

Comments posted to this topic are about the item Writing as an Art and...

Comments posted to this topic are about the item String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?