MSBI TIPS - Collection of dailly notes

I want to be able to see when a backup file was created. Does SQL Server provide a way to add the current date and time to my backup file fi...

Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment...

Logic reusability is one of the most practiced aspects of database development. For example query / business logic developed in stored proc...

System stored proc sp_refreshview updates the metadata for the specified non-schema-bound view. Persistent metadata for a view can become...