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

826 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

326 reads

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Today is Christmas and while I do not expect anybody to actual be reading...

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...

Comments posted to this topic are about the item UNISTR Escape

Comments posted to this topic are about the item Celebrating Tomorrow

In SQL Server 2025, I run this command:

SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";

What is returned? (assume the database has an appropriate collation) A: