Mehboob

" Every cloud has a silver lining "

Archive for November, 2011

SQL Tools

Posted by Mehboob on 30/11/2011

SQL Server Tools

IT Database professionals (database administrators, sql developers, Business Intelligence developers, report builders) require SQL Server tools for :

SQL Database Management Tools
Data Modeling Tools
SQL Monitoring Tools
SQL Tracing Tools
SQL Auditing Tools
Performance Tools
Optimizing / Optimization Tools
Building SQL Jobs
Business Intelligence Tools for developing Business Intelligence applications
DTS Converting and DTS Migration Tools
Data Importing Tools and Data Exporting Tools
Data Transformation – ETL Tools
SQL / T-SQL Rapid Development Tools
SQL Formatter (SQL Formatting Tools)
SQL Server Query Tool
SQL Backup Tools
Database Restore
Log Management
Deployment Tools for deployment of database objects like script deployment, sql job deployment
dealing with high number of servers
Compare Data
Compare Database Schemas and SQL Database Objects
Script Data in Database Tables
Building Reports / Report Development
Intellisense or Autocomplete in SQL Editor
Documenting SQL Objects or Database Documentation

In this list of tools for SQL Server in which users can find sql tools download links from the product developers and software vendors. There are hundered and thousand of tools out there but most of DBA used this tool.

SQL Server Management Tools

EMS SQL Management Studio for SQL Server
SQL Management Studio for SQL Server provides a complete package for all common SQL Server tasks for database administrators and developers.

DBArtisan
DBArtisan is a database administration tool from Embarcadero which aims the maximum availability, performance and security of databases including MS SQL Server DBArtisan provides powerful GUI editor and wizards for DBSa in order to speed routine tasks while minimizing errors for increades productivity.

EMS SQL Manager for SQL Server
EMS SQL Manager for SQL Server is a MS SQL Server administration and database development tool.

Discovery Wizard for SQL Server from Quest Software.
Quest Software is being developing a very useful and handy tool for SQL Server administrators. The SQL tool is in Beta phase and MS SQLServer administrators can download free.
This SQLServer tool enables administrators to gather information about the SQL Server installations in their network.

And what makes this tool unique is that SQL admins can see the users and the network traffic connecting to those MS SQL Server instances and watch this traffic within a period of time.
A must tool for SQL Server administrators especially for those administrators that are new in the company and want to get a summary of the existing MS SQL Server instances in their company network.

Tools for SQL Server – Database Desing and Data Modeling Tools

Embarcadero ER/Studio is a data modeling tool enables database designers document and re-use data assets. ER/Studio enable database desingners reverse engineering so making it easier to analyze and optimize existing SQL Server databases. BI-Tools.

Embarcadero Schema Examiner
Schema Examiner can be used to validate database design errors, and find out schema errors. Schema Examiner prepares sql scripts for resolving the found schema problems.
Schema Examiner can be used to identify problems like missing relationships between sql tables, or incorrect relationships, disabled triggers, required missing indexes on sql tables, etc.

SQL Dependency Tracker

Tools for SQL Server – SQL Monitor and Database Monitoring Tools

SQL Response
SQL Response is a sql monitoring tool SQL Server administrators require much. SQL Response monitors the health of the SQL Server instance and the activity on the server. Administrators can build alerts for notification of problems when they occur on the server. It is easy to monitor sql deadlocks, blocking processes or problems like long running and resource consuming queries.

Zero Impact Sql Monitor
Zero Impact SQL Monitor is an other tool for SQL Server that is used as database monitoring tools. Zero Impact SQL Monitor enables database administrators to monitor performance of their SQL Server database systems without any affect.

SecureSphere Database Activity Monitoring
SecureSphere Database Activity Monitoring is a compact tool for major databases like SQL Server for sql monitoring, auditing and reporting.

SQL Server Tools to Compare Schema

SQL Compare
SQL Compare can be used to compare schemas of two different databases and synchronize SQL database schemas of the sql databases by DDL sql commands. SQL Compare can especially be used between development and test databaases or test and production databases.

DB Comparer for SQL Server
EMS DB Comparer for SQL Server compares SQL Server databases and finds schema differences between sql databases.
DB Comparer for SQL Server prepares sql scripts that can be used to eliminate the database schema differences between SQL Server databases and synchronizing sql database structures.

dbForge Schema Compare for SQL Server
dbForge Schema Compare for SQL Server is used for schema comparison and synchronization between different sql databases. dbForge Schema Compare enables analyze the differences in database structures of development, test and production databases environments. It can build scripts and propagate the desired modifications to a target SQL Server database.

SQL Server Tools Compare Data and Data Synchronization

Data Sync
Data Sync is a data compare and data synchronization tool. An important feature of Data Sync tool from Spectral Core is that Data Sync can compare and synchronize data between two different database servers.

SQL Data Compare
SQL Data Compare is a handy tools for SQL Server professionals in order to compare data in sql tables and if required synchronize SQL database contents by generating sql DML scripts like insert, update or delete.

dbForge Data Compare for SQL Server
dbForge Data Compare for SQL Server enables database workers for easy data comparison and synchronization between different SQL Server databases.

SQL Comparison SDK
SQL Comparison SDK supplies developers an API for reaching Data and Schema comparison tools of Red Gate.

Data Comparer for SQL Server
EMS Data Comparer for SQL Server is a powerful data compare and synchronization tool. Data Comparer for SQL Server can create automatic scripts for eliminating data differences between SQL Server database tables.

SQL Server Backup Tools – SQL Backup and SQL Server Backup Compression Software

SQL Server professionals can find more related information on sql backup compression at SQL Backup Compression Default Option in MS SQL Server 2008 sp_configure Command.
They can also refer to SQL Server Backup Compression Software for more detailed review of SQL Server backup compression software and SQL Server tools for sql backup compression.

SQL Backup
SQL Backup from Red-Gate is a complete sql tool to compress, encrypt and monitor SQL Server backups for SQL Server administrators.

LiteSpeed for SQL Server
One of the SQL Server tools of Quest Software company is the SQL Server Backup and Recovery Tool “LiteSpeed for SQL Server”. LiteSpeed offers secure encrypted backups and fast sql backup compression method for saving from sql backup time and backup storage space. It is also possible using LiteSpeed Backup and Recovery Tool for SQL Server to restore individual database objects. You can also download a 15 day free evaluation and free trial download of this SQL Server Backup and Recovery tool.
For a detailed review on LiteSpeed please refer to LiteSpeed Backup SQL Server Backup Compression Tool.

Task Automation Tools for SQL Server

DB Mail
DB Mail is an automation tool not for sending e-mails from most common databases but can manage automation of sending e-faxes, SMS and cell phone messages, etc. DB Mail is a perfect tool for automating messaging needs of a database application.

Tools for SQL Server Development

Rapid SQL
Rapid SQL from Embarcadero is a tool for database and application developers which can be used to produce high quality SQL code faster. Rapid SQL supports team work environments that will boost the outcome of teams. Rapid SQL easies sql coding and source code control, database object management, reverse-engineering and deployment of a database schema.
Rapid SQL also supplies profiling tools for application and sql developers.

SQL Sets
One of the SQL Server tools that I have found very interesting as well as very useful is the SQL Sets from PrimalBits Software. SQL developers and test teams can create snapshots of data that will be affected during tests before starting the test. After the test is completed sql developers and test team members can create the same snapshot with new data that are changed during the test processes. Comparing two data sets it will be easier to understand what has happened and what went wrong during tests.

SQL Sets also enables SQL users to create Portable Data Documents which are query based data which can be saved and shared between collaborating teams and members. Users can add annotations into portable data documents to highlight important issues related with data. One additional feature of SQL Sets SQL Server tool is SQL developers and SQL Server administrators can easily export sql data in various formats. Developers interested in SQL Sets tool can download the 14-day free trial version from product download page.

SQL Multi Script
SQL Multi Script enables deployment of multiple sql scripts to multiple MS SQL Servers by executing each script on each database with a single click in this tool. SQL Multi Script easies database management tasks on multi servers for administrators. Developers can query multi databases parallel and aggregate results of their queries in case of need.

SQL Assistant
SQL Assistant is a SQL Server tool from SoftTree Technologies. In fact database developers can this database development tool not only for SQL Server but for Oracle, DB2, MS Access, MySQL, etc. Code snippets, SQL syntax check, format code, refactoring, test data generation, unit test, compare code are all very useful features of this SQL Server tool.

SQL Refactor
SQL Refactor can be used by sql programmers for refactoring and formatting sql code in their work.

SQL Prompt
SQL Prompt enables intelligent code completion known as intellisense for sql developers to be used on SQL Server query editors.

SoftTree SQL Assistant
SoftTree SQL Assistant enables a high code quality and accuracy with increased speed in database development and sql coding for database administrators and developers.

DatabaseSpy
DatabaseSpy is a multi-database query editor which enables sql developers to work on one query editor tool on all common databases. DatabaseSpy is also a database design tool for sql administrators.

EMS Advanced Query Builder
EMS Advanced Query Builder is an sql query editor tool in order to build sql statements like Select, Insert, Update and Delete. Query Builder tool has the advantage to work with major databases and with its visual GUI building sql statements is easier without any knowledge of SQL.

EMS SQL Query for SQL Server
EMS SQL Query for SQL Server is a sql query editor tool with a visual editor interface as well as the text query editor. SQL query editor tool also displays query execution plans for t-sql developers.

Toad for SQL Server, SQL Server Management and Development Tool-Set for SQL Administrators and SQL Developers from Quest Software. The development tool for SQL Server “Toad for SQL Server” brings the power of MS Visual Studio and SQL Server Management Studio (SSMS) together and makes it easy for DBA ‘s and developers their daily tasks.

For example, comparing schemas and synchronizing schemas. Also data compare and synchronization is made easier. It is possible to run an SQL script on more than one instances so developers can work on multiple SQL Server instances using the Toad for SQL Server. Besides these, managing SQL Server jobs is an additional feature for this SQL Server tool.

SQL Server Tools – Test Data Generator

SQL Data Generator
Red-Gate SQL Data Generator is a SQL Server tool for developers or testers in order to ease production development stages with automatically populating sql databases with realistic test data. You can refer to tutorial Create Test Data using SQL Data Generator as an example on this tool.

Data Generator for SQL Server
Data Generator for SQL Server can be used by database testers and application programmers to generate test data for MS SQL Server database tables. There is also a tutorial for Creating test data using EMS Data Generator for SQL Server as an example on this sql data generation tool.

Datanamic DB Data Generator
Database developer can use DB Data Generator as a SQL Server tool for creating meaninful test data in order to test their applications. One of the features of DB Data Generator is that it can use a well enough mask for string values while generating test data. If you want more information on this tool please read my review at SQL Data Generator – Generate Test Data for SQL Server Using Datanamic DB Data Generator Tool.

SQL Server Tools for Documentation

SQL Doc
SQL Doc is a handy documentation tool for sql developers who wants to document their databases. SQL Doc can create database documentation from database schema and build descriptions for database objects like tables, views, and even for columns. Documentation includes internal or external database dependencies for the related database objects.
Developers can build database documentation in HTML format or MS Word format.

Document! X 2008
Document! X documentation tool helps admins and developers creating and maintaining the documentation of databases including MS SQL Server.

Documenter for SQL Server
Documenter for SQL Server enables SQL Server database administrators prepare a full documentation of their databases covering all of the database objects. DBAS can prepare quickly cross-linked HTML documentation or Windows Help File (in CHM format) documentation of all database objects by parsing database properties.

SQL Server References

SQL Safari
SQL Safari is a reference resource for SQL Server administrators and sql developers. SQL Safari enables full access to most appretiated SQL Server books from Safari Books Online

 

SQL Server Database Schema Management Tools

SQL Packager
SQL Packager tools is used to package and compress schema and the database contents of a SQL Server database.

 

SQL Server Log Management Tools

SQL Log Rescue
SQL Log Rescue is log analysis tool which IT professionals can use for viewing details in SQL Server logs and information on database transactions. DBAs can also use SQL Log Rescue records in order to get lost data back in case you have accidentally delete, or modify data in a database.

SQL Audit Tool

DB Audit Expert
DB Audit Expert is a professional sql auditing tool for SQL Server. System, database and security administrators as well as auditors can use DB Audit Expert as an sql audit tool.
DB Audit Expert enables tracking and analyzing database activity about database security, data access and usage, data creation, data updates or data deletion.

SSW SQL Auditor
SSW SQL Auditor or SQLAuditor is a tool for big development teams to ensure Quality Assurance. Database designers can trace if best practice standards are applied to the SQL Server application by running SQL Auditor. SQL Auditor sql audit tool can be assumed as the FxCop for SQL Server development teams. This tool can find database desing problems and fix them, can identify sql naming problems, can find missing relations, missing primary keys, foreign keys, etc.

Lumigent Audit DB
Audit DB is a sql auditing software package from Lumigent. Audit DB is a perfect solution for data auditing and security policy management. SQL Server database administrators can easily detect unauthorized access to data and can follow privileged database users activity. Security administrators can publish security policies and can ensure and control that the security policy management is working successfully. One more important feature of the Lumigent Audit DB sql auditing software is that it comply with data protection and data security regulations like 21CFR11, Basel II, HIPAA, PCI, SB1386, Sarbanes-Oxley, etc.

ApexSQL Audit
ApexSQL Audit is an sql auditing tool from Apex. It can track DML statements and save audit data into an other seperate SQL database.
ApexSQL Audit tool has also command line support.

OmniAudit
OmniAudit SQL Server Auditing tool is easy to install and easy to use sql audit tool. By activating OmniAudit on any database, table and field, database administrators can identify which field in which table has been altered by which user. SQL auditing tool also reports before update and after update data values as well as change time. OmniAudit also fullfills the Compliance Requirements of regulations like FDA Part 11, HIPAA, PCI-CISP, Sarbanes-Oxley, etc.

Business Intelligence Tools (BI Tools)

PrismCubed
PrismCubed enables developers and database professionals build business intelligence applications within short periods of time. PrismCubed provides ETL (Extract – Transform – Load) functions with huge amounts of data. Provides a simply interface for users to filter data, analyze data and visualize data.

DTS xChange
DTS xChange is one of the most searched tools in the market which convert DTS packages to SSIS 2005 or SSIS 2008 packages. The Business Intelligence tool DTS xChange from Pragmatic Works Software can successfully migrate existing SQL Server 2000 DTS packages to new SQL Server Integration Services SSIS packages. A very little manual work is left to SQL BI developers after DTS xChange is used for migration DTS packages.

Your opinion, suggestions and comments are highly appreciated.

Mehboob

SQL – SPS DBA, MCTS

 

Posted in BI-DW, MS SQL Server | Leave a Comment »

Info SQL Server 2012 RC

Posted by Mehboob on 30/11/2011

Download SQL Server 2012 RC

Microsoft has released the new SQL Server product Microsoft SQL Server 2012 Release Candidate 0 (RC0) on 17th of November, 2011 for Data Platform professionals to evaluate and analyze what is new in SQL Server 2012. The SQL Server 2012 RC0 downloads are better organized and the main sub-product lines within the SQL Server Data Platform has been highlighted with seperate downloads options for SQL Server administrators and SQL Server developers.

You can continue Microsoft Downloads web portal to download Microsoft SQL Server 2012 Release Candidate 0 (RC0). But unfortunately this main SQL2012 download page offers a unique download .iso image file “ENU\SQLFULL_ENU.iso” with 4.4 GB in size. This single SQLFULL_ENU.iso image download contains both x86 and x64 editions of SQL Server 2012 RC0 so it may be unreasonable to download and both SQL Server 2012 editions.

I’ll suggest database administrators and transact-sql developers to check the SQL Server 2012 download page on Microsoft Beta Experience.

As you can see from above screenshot of the Microsoft Beta Experience SQL Server download page, IT professionals can download and try evaluation version in 32-bit version or in 64-bit version options. Of course SQL Server 2012 is available in languages US English, French, Italian, German, Portuguese, Spanish, Russian, simplified Chinese, traditional Chinese, Japanese and in Korean for the first Release Candidate RC0 version.

32-bit and 64-bit SQL Server 2012 download files are around 2.15GB
 

 

Download Sample Database AdventureWorks for SQL Server 2012

Microsoft SQL Server 2012 database administrators and T-SQL developers can download sample database AdventureWorks for SQL Server 2012, Denali CTP3. A sample database like AdventureWorks will be very helpful to demonstrate the capabilities of SQL Server Database Engine, and other database components in action. Especially for new enhancements, AdventureWorks database built for this task is great help for SQL Server developers and SQL Server administrators.

Download AdventureWorks Sample Database
AdventureWorks sample database for SQL Server 2012, Denali CTP3 can be downloaded from HERE CodePlex. If link doesn’t work so please visit www.codeplex.com

Microsoft SQL Server 2012 CTP3 Download

Microsoft SQL Server 2012 Denali CTP3 is released at 07/13/2011 for SQL Server IT professionals to enable them review the next version of SQL Server from first hand. The data platform administrators and developers can free download MS SQL Server 2012 Denali CTP3 version from Microsoft Beta Experience portal using url https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/. The current SQL Server 2012 download is provided in 32bit and 64 bit binaries in English, French, German, Portuguese, Spanish, Italian, Chinese, Japanese and Russian.

Before downloading below setup files, remember that Microsoft renamed the SQL Server Denali as SQL Server 2012 which was expected as SQL Server 2011 or SQL11. If you meet so called SQL Server 2011 or SQL11 versions, remember that these are the CTP releases of the early beta versions of SQL Server 2012.

SQL Server Denali CTP3 download includes 4 SQL Server download files :

For 32 bit SQL Server 2012 installation files :
SQL Denali LCA EN.html, 1 KB ReadMe file
SQLFULL_x86_ENU_Install.exe, about 94 KB installation file
SQLFULL_x86_ENU_Core.box, about 1.7 GB x86 32-bit SQL Server 2012 Edition
SQLFULL_x86_ENU_Lang.box, about 570 MB

For 64 bit SQL Server 2012 installation files :
SQL Denali LCA EN.html, 1 KB ReadMe file
SQLFULL_x64_ENU_Install.exe, about 94 KB installation file
SQLFULL_x64_ENU_Core.box, about 1.8 GB x64 64-bit SQL Server 2012 Edition
SQLFULL_x64_ENU_Lang.box, about 620 MB

For free download of SQL Server 2012 Express edition and new SQL Express LocalDB edition, IT professionals can go to Microsoft Downloads portal Denali Express Core CTP3 download page.

Download Microsoft SQL Server 2012 CTP1 (aka SQL Server Denali CTP1)

Microsoft has released the next version of SQL Server, Microsoft SQL Server 2012 code-name SQL Server Denali CTP1 (Community Technology Preview 1) on 11/8/2010.
SQL Server database professional waiting first SQL Server 2012 CTP before the new year.
As assumed Microsoft has released MS SQL Server 2012 for free community download.
As we have used to, the first release of SQL Server Denali is the Community Technology Preview 1 or Microsoft SQL Server 2012, Denali CTP 1.
SQL Server database administrators and developers can find the Microsoft SQL Server 2012 download links below.

Please note that it is possible that in next months we will ne presented a new version of SQL Server 2012 Denali CTP which will contain less bugs, more stable, more functional.
This next version will be named as Microsoft SQL Server 2012 CTP 2. I will announce the SQL Server 2012 CTP download links here as soon as the next CTP is released. I assume that the next CTP of SQL Server 2012 release date will be within 4 months.

After SQL Server 2012 CTP releases (Community Technology Preview), we will be able to try free SQL Server 2012 Beta version. Just a few months later the RTM release of the Microsoft SQL Server 2012 will be released to manufacture. You can find the Microsoft SQL Server 2012 download links for various builds here in this page.

Microsoft SQL Server 2012 CTP Download

SQL Server Denali CTP1 download includes 4 SQL Server download files :

Readme SQL Server Denali CTP1, 12 KB read me file. Download from “http://download.microsoft.com/download/A/6/B/A6BA76B8-BA7D-4408-A93A-F5EF8A1E1DD5/Readme_SQLServerDenaliCTP1.htm” Readme

SQLFULL_x86_ENU.exe, about 1.3 GB x86 32-bit SQL Server 2012 Enterprise Evaluation Edition download from “http://download.microsoft.com/download/A/6/B/A6BA76B8-BA7D-4408-A93A-F5EF8A1E1DD5/SQLFULL_x86_ENU.exe”
SQLFULL_x64_ENU.exe, about 1.5 GB x64 64-bit SQL Server 2012 Enterprise Evaluation Edition download from “http://download.microsoft.com/download/A/6/B/A6BA76B8-BA7D-4408-A93A-F5EF8A1E1DD5/SQLFULL_x64_ENU.exe” X64 version

It is also possible to download SQL Server Denali in .iso image file mode :
SQLFULL_ENU.iso about 2.8 GB in size downloadable from “http://download.microsoft.com/download/A/6/B/A6BA76B8-BA7D-4408-A93A-F5EF8A1E1DD5/SQLFULL_ENU.iso” SQL Server 2012 Full

Please note that starting with SQL Server 2012, Denali CTP 1 Itanium based installations are not supported any longer.

Before starting to download SQL Server 2012 CTP 1, note that SQL Server Denali is only supported on Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, or on Windows Vista Service Pack 2 operating systems.
So if you are still using Windows XP computers, it is not possible to install SQL Server 2012 Denali on Windows XP.
For further SQL Server 2012 Requirements please refer to Microsoft SQL Server 2012 Requirements.
Mehboob

SQL – SPS DBA – MCTS

Posted in MS SQL Server | 3 Comments »

SharePoint 2010 Architectures

Posted by Mehboob on 28/11/2011

Provided by:  Ricky Kirkham, Microsoft Corporation

Technologies for Creating SharePoint Applications. Provided by:Eric White, Microsoft Corporation

 

Posted in SharePoint | Comments Off

Windows 8

Posted by Mehboob on 23/11/2011

Microsoft created the Windows 8 setup process with A & B types of users in mind:

A.People who want to easily upgrade without any hassle; and
B.People who want to run a clean install and tap into advanced options to control their disk and partition settings.

One of the first enhancements can be found in the delivery of Windows 8.

Beyond offering the new OS on a standard boxed DVD, Microsoft will also make it available to customers via the Web. Users can download and even install the product directly online from start to finish.

The Web setup process also integrates the product key, sparing people from having to manually enter it. Users who want more control over the installation can also run an advanced setup from a DVD or USB key.

Microsoft has also combined several tools to simplify the Windows 8 upgrade. In Windows 7, the company offered both an upgrade advisor to tell users which applications were compatible with the new OS and Windows Easy Transfer to save and restore key files and settings. Now both tools are fully integrated into the Windows 8 setup.

So a user who upgrades to Windows 8 will encounter one single end-to-end process and as few as 11 clicks, compared with the four different products and up to 60 screens required to jump to Windows 7.

Windows 8 users should also see the entire upgrade fly by faster. For Windows 7, each needed file and document would be moved one by one and then moved back once the installation was done. The Windows 8 installation will move entire folders instead, thereby speeding up the process. Other tweaks also promise a quicker upgrade experience.

Finally, advanced users and IT professionals alike will be able to choose from a range of options to give them full control over their upgrades and migrations.

Improving the setup experience

Minimizing restarts after automatic updating in Windows Update

Designing search for the Start screen

“With Windows 8 setup we have greatly improved both speed and ease of use, while still retaining all of the advanced setup functionality that many customers will demand,” St. Pierre explained. “We have integrated what was once many separate steps for people to perform when preparing and starting their setup into a streamlined user experience, with a fast and reliable setup engine under the hood.”

Posted in MS Windows | Comments Off

MCM SQL Server 2008

Posted by Mehboob on 23/11/2011

Did you know that based on the Microsoft Certifications you’ve achieved, you meet the certification prerequisites for the Microsoft Certified Master (MCM) SQL Server 2008 certification?

Consider taking your career to the next level with MCM SQL Server 2008. Through virtual classroom and self-paced training, online practice labs, and challenging exams; the MCM program provides the most experienced and talented IT professionals with worldwide validation and recognition of their in-depth technical expertise in using SQL Server.

Why become an MCM for SQL Server 2008?
When you earn MCM certification, you join – and can share knowledge with – an exclusive community of top SQL Server experts worldwide. Your name and technical services will be promoted on the Microsoft website. You can stand out to your employer and customers because your certification is proof of your advanced technical expertise in SQL Server. In a 2010 survey of MCMs, over 60% of respondents reported that the MCM certification increased their requests for participation in active projects. Moreover, Microsoft Partners have told us that they have won customer engagements primarily because they have MCMs on staff.

Get ready for the MCM Exams
Microsoft offers a number of options to help prepare candidates for the required Knowledge Exam and Lab Exam for MCM SQL Server 2008:

SQL Server 2008 MCM Accelerated Exam Preparation Program
The program has two components:

  • SQL MCM Sessions: A scheduled series of seven weeks of live online sessions with a presenter who is a SQL Server MCM, covering review of an exam topic and open Q&A time. There will be two two-hour sessions delivered weekly, with each week focusing on one of the seven Exam topic areas. Sessions start November 29, 2011 and seats are limited.
  • SQL MCM Labs: A two month subscription to an anytime-access lab environment for practicing with 20 SQL MCM-level labs in a hosted SQL Server VM environment. The labs will be associated with the weekly exam topics. Lab access starts November 21, 2011 and continues until January 20, 2012.

You may choose either or both of the two components, based on your learning needs. Find out more and register.

Anytime access to practice labs
Want to make use of the same practice labs described above, but don’t need the full two month subscription? Subscribe to one week or one month of lab access instead. These options are available NOW, so register today.

Additional Preparation Resources
Microsoft also provides a collection of free preparation resources including MCM SQL Server 2008 instructor video lectures, as well as recommended books and white papers.

With exam preparation resources so readily available, and the benefits of certification so apparent, now is the time to achieve recognition as one of the top SQL Server experts in the world. Visit the MCM SQL Server 2008 program website to learn more about taking your career to the next level with MCM certification.

Microsoft Certified Master Program Team:  Contact us with questions

Recently i achived my certification for SharePoint 2010, Configuration & SharePoint Administrator 2010 certification – MCTS.

 

Mehboob

SQL-SPS DBA – MCTS

Posted in MS SQL Server | Comments Off

10 advices to young people

Posted by Mehboob on 07/11/2011

Bill Gates’ 10 advices to young people

May be this is not a right place to publish Bill Gates artical but it is worth to read it.

Before retiring in July 2008, Bill Gates gave the following advices to high school students. You can get good learning experience to enhance yourself and get motivated from these valuable advices.

“Life is not fair – get used to it.” The world is never fair. You know this. You can never change the whole world. Injustice still exists in the current society, so you should try to adapt.

“The world won’t care about your self-esteem”. The world will expect you to accomplish something before you feel good about yourself. Your extreme self-esteem may make your job inconvenient. Don’t attach too much significance on your self-esteem as people care about your achievements rather than it.

“You will NOT make 40 thousand dollars a year right out of high school. You won’t be a vice president with car phone, until you earn both.” Normally you can’t be rich if you have just finished high school. However to become an executive, you need to obtain both: a high school certificate and the money.

“If you think your teacher is tough, wait till you get a boss. He doesn’t have tenure.” Don’t complain that your boss is tough. When you are at school, your teachers always stand by you whenever you meet problems. However if you have thought that all your problems really come from the hard requirements of your teachers, you shouldn’t look for a job. Simply if there aren’t strict demands from your company, you will do nothing and quickly become unemployed. Then nobody will give you a hand.

“If you mess up, it’s not your parents’ fault, so don’t whine about your mistakes, learn from them.” Don’t blame your failure on your destiny. All you need now is to stay calm and start from scratch.

“Before you were born, your parents weren’t as boring as they are now. They got that way from paying your bills, cleaning your clothes, and listening to you talk about how cool you are. So before you save the rain forest from the parasites of your parent’s generation, try delousing the closet in your own room.”

You should show your gratefulness to your parents for spending most of their lives for your living and growth. All the “outdated” of your parents today is the price they have to pay for your growth.

“Your school may have done away with winners and losers, but life may not. In some schools, they have abolished failing grades and they’ll give you as many times as you want to get the right answer. This doesn’t bear the slightest resemblance to ANYTHING in real life.”

Keep in mind that you can always become a leader, so that you will have more motivation to strive for your career.

“Life is not divided into semesters. You don’t get summers off and very few employers are interested in helping you find yourself. Do that on your own time.”

Don’t always wait for holidays or you will be left behind your colleagues. That backwardness means elimination and unemployment.

“Television is NOT real life. In real life people actually have to leave the coffee shop and go to jobs.”
Everybody likes watching TV, but you shouldn’t watch it too much. As that actually isn’t your life and your thinking will be influenced. You yourself have to determine your own life.

“Be nice to nerds. Chances are you’ll end up working for one.”

You should be nice to everyone. Life has happenings you could never expect. Be open to your boss; don’t say bad things behind his back as it will bring you nowhere.

7 Key Lessons from a Greatest Leader of all times – Bill Gates

After more than three decades of entrepreneurship, Bill provided a great sense of achievement for himself and revolutionized the rest of the computer industry. Out of his experiences, he shares key lessons to guide us all through.

Success comes with a Great Vision

“Every business and household must have a computer and must run Microsoft software”, was the basic guiding vision of Bill Gates. When people in the world were not even aware of the software industry’s future, when people were unaware of the unknown, here was a man who had full confidence on his gut feel, and had the passion and zeal to take the vision the farthest possible way. He was almost there achieving his vision. This clear vision of him won him success and glory and made him the richest person in the world for 13 continuous long years.

Failures are learning lessons:

Bill Gates says “Your most unhappy customers are your greatest source of learning.” This says that Bill Gates was never afraid of losing and went on to win a lot of deals because of this. While the Microsoft windows operating system is the widely used in the world, there are a good number of criticisms and unhappiness about the software among the users. While many of them used to get bugged using Microsoft products, Bill Gates did not easily give up. He took all those as nice lesson and is improving every single day.

Higher the Self Esteem the better it gets

When you start achieving something big, there will be people who would want to make fun of your efforts, criticize and try to pull you down. The stronger you stand the bolder you get the faster these negatives fade.

Opportunity knocks once

Bill Gates took up the accountability of being the Chief Software Architect; Bill Gates was nurturing Microsoft by building a wide spectrum of products. This was not just to capitalize on the knowledge but also to provide the best by understanding the requirement of the people. He did not wait for people to ask what they wanted and instead made a revolution of creating an opportunity for himself and his company by innovating. He did not sit and do something that anyone could, but he took the reins into his hands to take Microsoft to these great heights.

Action Speaks Louder

This is one never mentioned secret of success. Action is the key word, when logic never drives us its emotions. We must have that emotional strength in us to act, to perform. Bill Gates as a small young boy never had anything to lose which he kept telling his good friend Paul Allen. When he had several odds against him such as the American Law and several cases against him, he still without fail took action by developing more software, which the people wanted. This made him a super star overnight. If not for Bill Gates, Microsoft would have not seen the light today of what it gets. This was because of his persistence and constant delivery of ideas to his Goals and vision.

He was a drop out from one of the world’s best universities the Harvard and not everyone from there went to achieve great heights like Bill Gates did, which reiterates the basic fact that education is just a tool for success and does not define success itself. During the convocation address at the Harvard university, Bill Gates mentioned that good he came when they were graduating and not when during the time when they joined the university else they would have changed their mind.

Trust- An unwritten rule for great leadership wisdom

Right from day 1 at Microsoft, Bill Gates was very open to the ideas. This he also proved later when Steve Balmer stepped into the shoes of Bill Gates and became the CEO of the company. He always believed that there is no end to learning from people, from books and so on. “I really had a lot of dreams when I was a kid, and I think a great deal of that grew out of the fact that I had a chance to read a lot”, says Bill Gates. Ready for more ideas to float around which will make sure that the same culture of innovation continues in Microsoft even without his presence.

Success must never get on to the head

This is by far the best lesson what we learn from Bill Gates. At a tender age of 21, Bill Gates had achieved many a things beyond money and fame. This did not allow him to stop achieving and always had the drive to achieve great heights. “If I’d had some set idea of a finish line, don’t you think I would have crossed it years ago?” quote Bill Gates with utmost passion and determination.

Never stop learning was the Mantra of Bill Gates which he follows until date. This makes him a Great Leader of our times. He will always be remembered as an icon and even without his presence in Microsoft; he would still be regarded as a great inventor and a real genius with respect to Business, Technology and Entrepreneurship.

More info visit here ..

 

Posted in BI-DW, Cloud, MS SQL Server, MS Windows, SharePoint | 1 Comment »

SQL Server Code Name “Denali”

Posted by Mehboob on 03/11/2011

SQL Server Code Name “Denali” CTP3

Reason to Love SQL Server 2012
SQL Server 2012 helps enable security and compliance with added built-in security and IT controls.

 

Download Microsoft System Center 2012 Pre-Release Products

See how they can help you manage your physical and virtual IT environments. Also watch the TechNet Edge video Mobile Device Management in Configuration Manager 2012 and check out Private Cloud Deployment with Service Template in VMM 2012.

Posted in MS SQL Server | 1 Comment »

 
Follow

Get every new post delivered to your Inbox.