DBA Wiz

The following values are used to determine how table and database names are stored on disk and used in MySQL that is affected by the lower_case_table_names system variable, which can be set while starting mysqld:
lower_case_table_names=0: If the value is set to 0, table and database names are stored on the storage device by using the lettercase that is specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case sensitive. The value of this variable should not be set to 0 if the user is running MySQL on a system that has case-insensitive file names, for example, Windows or Mac OS X. If the user forces this variable to 0 with –lower-case-table-names=0 on a case-insensitive file system and accesses MyISAM tablenames using different lettercases, the index may be corrupted as a result.
lower_case_table_names=1: If the value is set to 1, table names are stored in lowercase on the storage device and comparisons of name are not case sensitive. MySQL is used to convert all table names to lowercase on storage and lookup. It is also applied to database names and table aliases.
lower_case_table_names=2: If the value is set to 2, table and database names are stored on the storage device by using the lettercase that is specified in the CREATE TABLE or CREATE DATABASE statement; however, MySQL is used to convert them to lowercase on lookup. In this value, name comparisons are not case sensitive. It works only on file systems that are not case sensitive.

Ad hoc reports specifically refer to Report Builder reports, and not to reports that can be created using the Report Wizard. An ad hoc report can be created from an existing report model by using Report Builder. Ad hoc reports leverage pre-defined templates and report models to enable information workers to easily and quickly explore business data using data structures and familiar terminology that have been implemented in the report model. Just like other Reporting Services reports, ad hoc reports can be saved and run locally or published to a report server.

Come on friends uCertify is again ready to give you special gifts in the month of July by announcing the annual Freedom Sale!
Choose from over 300 exams, covering all major certification vendors. Second, if, for any reason you are not satisfied with your purchase, simply let us know within 7 days of your order, and we will return your money. How cool is that?! This super guarantee is in addition to our unbeatable 1 year guarantee.

So, what are you waiting for? Hurry! The Freedom offer is valid June 29 – July 6, 2011 only.

Happy Shopping & Happy Learning!
Your uCertify Team

http://www.ucertify.com

The db_dtsltduser fixed-database role secures the SSIS packages that are stored in the MSDB database. The members of the db_dtsltduser fixed database role have the following permissions:
A user can enumerate all packages.
A user can view packages owned by him.
A user can execute packages owned by him.
A user can export packages owned by him.
A user can import all packages.
A user can delete packages owned by him.
A user can change the roles of the packages owned by him.

The members of the db_securityadmin role are allowed to manage database users. They can grant, deny, or revoke permissions from the users. The permissions include adding or removing users from a database and assigning a user to a database-level role. The members of this role can also manage statement and object permissions.

The db_owner database role makes its members the owner of the database. The members can perform any task such as deleting database objects, monitoring the database, executing system stored procedures against the database, etc. A member should be assigned to a database role only when he has to completely control the database.