Coffee and SQL

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

346 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

328 reads

Third part in my Ai series with databases. When building AI solutions within the...

This month we have a very interesting invitation from Koen Verbeeck. He has hosted...

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...

Comments posted to this topic are about the item How Do the Experts Become...

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Comments posted to this topic are about the item Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?