This week’s post I’ll talk about two new features that don’t seem to get on well. Let’s make them behave and work together as a team Among the overwhelming amount of new…
Category: SQL-G Hacks
You will need these hacks to be a Real SQL-G
Extended Events File Target Reader
Getting useful information from Extended Event files is sometimes very tedious as you have to use XML queries and even PIVOT, what can be a better plan? It’s been some time since I…
Shrinking large half-empty MDF
Shrinking your database is not a best practice (sometimes can be acceptable) but it might be trickier than you expect Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it!…
Divide and Conquer Date Search Hack
Divide and Conquer Date Search Hack (because binary search sounds boring) Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have…