Writes large correct programs


Posted in Links | Leave a comment

SQL Server “Denali”: New Certifications

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:

  • Writing queries with Transact-SQL (T-SQL)
  • ETL Developer or Data Warehouse Developer. People in this role cleanse data using Data Quality Services, develop and manage ETL jobs and packages, and create and implement data warehouses.
  • BI Developer. People in this role implement multi-dimensional data models, implement and maintain OLAP cubes, and create information displays used in business decision making.
  • BI Architect. People in this role are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use.

Four certification exams are planned for SQL Server “Denali” database professionals who do not perform business intelligence functions:

  • Writing queries with Transact-SQL (T-SQL)
  • Implementing, Configuring, and Maintaining  Microsoft® SQL Server®
  • Building, Supporting, and Developing Databases for Microsoft® SQL Server®
  • Designing Database Solutions for Microsoft® SQL Server®

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.

Posted in SQL | Tagged , , , , , , , , , , , | Leave a comment

Entity Framework 4.0 – Learn to Create Databases from the Model

The ADO.NET Entity Framework (EF) is object relational mapping software for ADO.NET, used to develop applications that interact with data. It provides a mapping between the relational database schemas and objects. This technology is helpful for architecting, designing and developing at a conceptual level without worrying about details. ADO.NET Entity Framework allows developers to program against the Entity Relationship (Object) model, as opposed to querying against the relational database, mainly concentrating on the data. The main benefit is to make data oriented applications maintenance friendly.

Read more in following link


Posted in Links | Tagged , , , , | Leave a comment

Windows Application For Backup and Restore Database

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.

If it is successfully completed message appears as follows, otherwise appears message “BACKUP DATABASE not successfully!”

The backup file is saved with name of database and the current date when the backup is occurred.
If we choose Restore option do as follows:

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!”

Hope you liked this simple application and if you have similar ideas please post them.
Posted in Windows Applications | Tagged , , , , , | Leave a comment

Hello world!

Welcome to my blog. This is my first blog.

Posted in Uncategorized | 1 Comment