SELECT *
FROM Posts
WHERE Category = 'SQL-G Hacks'

jul
27
2016

SQL Server 2016, Double or Nothing, Always Encrypted with temporal tables

Among the overwhelming amount of new features available for SQL Server 2016, there was one I really wanted to try, maybe because I have never worked with encryption further…

Continue Reading »

may
31
2016

Extended Events File Target Reader

It’s been some time since I started with my first SQL-G Hack, and I think those are precisely the kind of posts you might want to find when searching…

Continue Reading »

abr
26
2016

Shrinking large half-empty MDF

Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it! First I have to say I’m a big fan of DBCC SHRINK, I use it all the time… NO, that was a bad…

Continue Reading »

oct
17
2015

Divide and Conquer Date Search Hack

Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have attended to one of the most valuable SQL Server training you can find (IEPTO2 by @SqlSkills team), I’ve also met really nice people…

Continue Reading »