I often see developers executing the unplanned code on production server when they actually want to execute on the development server. Developers and DBAs get confused because when they use SQL Server Management Studio (SSMS) they forget to pay attention to the server they are connecting. It is very easy to fix this problem. You can select different color for a different server. Once you have different color for different server in the status bar, it will be easier for developer easily notice the server against which they are about to execute the script.
The biggest request we keep on getting in SQL in Sixty Seconds is tricks with SQL Server Management Studio. It seems like SSMS is our favorite tool and we all want to share our neat tricks with everybody. Today I am going to share very popular and most requested SQL Server Tip. Sample data and test database is very common when working in a development environment. A developer often creates interesting samples as well challenging objects in their database. The architects work on databases and hand it over to developers, later developer hand it over to DBA. In simple words, in many cases the database move from one place to another place. It is not always possible to back up and restore databases. There are possibilities when only part of the database (with schema and data) has to be moved.