SELECT * FROM Posts WHERE Tags IN ('SQL Server Internals')
I love SQL Server internals, I do and I just said it. Why? because thanks to all the tools, documentation and community members that share their knowledge, folks like me can understand how a super complex piece of software like…
Speaking of security, in SQL Server we have the possibility of authenticating in two different ways, one it is based on Windows Authentication and allow Windows users (from a local computer or Windows domain) to…
So spring time is here and probably you feel like cleaning up your databases, and that’s good. In previous posts…
One of the most interesting things in SQL Server from my point of view are Statistics and how the optimizer interprets them to produce optimal query plans. But today I want to write about something…
Last week we started exploring some of the cool features that the new In-Memory engine (code name Hekaton) has brought into…
TRUNCATE TABLE in SQL Server is well known for what it does as feature, but how it actually works is easily misunderstood, and for long time, the same…