SQL Server database snapshot feature provides you to have a read-only copy of your current database. You can create a snapshot only on the server which is actual db located. In other words, you can’t create a snapshot on any other server than the server that host your actual database. We use snapshots for solving [...]
Dynamic Management Views and Functions feature comes with SQL Server 2005 version. They provides some information about system, and what is going under when SQL Server running. So you can use DMV and DMF objects to monitor the system and tune it. These object located under sys schema and names are start with the dm. [...]
I had presented to computer engineering students at the Eastern Mediterranean University and Cyprus International University about developing SQL Server and ADO.NET on different times.