Digging into SQL Server 2012 columnstore index
The SQL Server 11.0 release (code named “Denali”) introduces a new data warehouse query acceleration feature based on a new…
Archive
Category: T-SQL
Count tables’ references and tables’ foreign keys
There are some cases that you do not have any documentations for the database that you are working on and…
How to store a SQL Server database diagram into a file and share it with others?
Sometimes you might feel you need to store the database diagrams in a file basis. I’ve faced to this feeling…
How to hash sensitive data for maximising security in SQL Server 2005 and later versions?
SENSITIVE DATA! It’s an interesting topic! In this post I’m trying to explain how to hash data to increase security…