RAISERROR is one of the most efficient method to raise user created exception based on various situations. And TRY CATCH…
Tips
File Integritry verfication … using File Checksum Integrity Verifier
Lets say you download a file from internet and you want to make sure that this file’s source is legitimate…
Page level recovery in SQL Server 2012
Database corruption can be difficult to detect and sometimes it is very possible that you might not even notice it…
WHO IS … SSRS Report
I know it sounds grammatically incorrect … it should say WHAT IS SSRS REPORT ? But this title is very…
Archiving using 7ZIP commandline
Couple of days back I had to create a script to archive all files from number folders as part of…
Adventureworks in SQL 2012
After trying different RCs, finally this weekend I got time to download SQL 2012 rtm dev edition from my dreamspark…
Powershell … shell on steroids !!
Shell is not a new thing for any older timer … or for folks working with forbidden OSes like Unix…