Mr WordPress on Hello world!
The Microsoft certifications for the next version of SQL Server, there will be seven exams:
Four certification exams are planned for SQL Server “Denali” Business Intelligence roles:
Four certification exams are planned for SQL Server “Denali” database professionals who do not perform business intelligence functions:
Since “Writing queries with Transact-SQL (T-SQL)” is required for both roles, and each role has three unique exams, that totals seven exams. That is one more than SQL Server 2008 has, and splits into two roles (“Business Intelligence” and “Database Professionals”), while SQL Server 2008 has three roles (“Database Administrator”, “Database Developer”, and “Business Intelligence Developer”).
These new breakouts seem more logical for today’s environments, and give more importance to business intelligence, which is the direction Microsoft has been going for the last few years. It will be interesting to see what “Upgrade Paths” Microsoft will have for those of us who have taken the SQL Server 2008 exams.
In case that we develop various applications in development computer and want those applications to move on the client computer or any other computer for testing except that we need to copy those files, we need also backup the database and restore it. Other case if we want the end of the day to do database backup because we have modified or added something to it.
From both the aforementioned cases to make the backup and restore database on different computers with faster and easier way, I was inspired to develop a simple windows application called Backup&Restore that will do it without having to open SQL Server Management Studio. The following will describe the use of this application.
First choose if we want to backup or restore database.
If we choose Backup option do as follows:
In field “Server Name” type the name of the server on which is the database for backup, for example “LINDAF \SQL1” where SQL1 is the SQL instance name;
In field “Database Name” type the name of the database you want to make backup;
Click button “Choose Path” and is shown the following dialogue to select the folder where we want to store database backup file. If we choose the folder then press the button “OK”, the path appears and finally press “Run” button.
In case if we want to do restore database “dbTest” to another database for example “dbOther” then we need to check the checkbox “Restore Other Database” and to type name of other database, otherwise press the button “Open File” to select the backup file. Finally press “Run” button. If it is successfully completed message appears as follows, otherwise appears message “RESTORE DATABASE not successfully!”
Welcome to my blog. This is my first blog.