Mehboob

" Every cloud has a silver lining "

Archive for February, 2012

Free Private Cloud Training

Posted by Mehboob on 14/02/2012

Free Private Cloud Training! Register Now!

REGISTER NOW

Over 4,000 global IT Professionals registered for the February 21-22, 2012 offering! To accommodate demand, Microsoft is running this course again on April 3-4, 2012. You don’t want to miss it, so register now!

Microsoft Learning and the Microsoft System Center 2012 team are partnering to bring provide IT Professionals an exciting opportunity to learn what they need to know to deploy, manage and maintain Microsoft’s private cloud solution. Leveraging the popular Jump Start virtual classroom approach, the industry’s most gifted cloud experts will show attendees why this new private cloud solution, based on System Center 2012 and Windows Server, has garnered so much attention. Here are the details:

  • Date/Time: April 3-4, 2012 from 9:00am – 5:00pm PST | NEWLY ADDED
    IMPORTANT: The Feb. 21-22, 2012 class is fully booked and closed to new registrations
  • Where: Live virtual classroom (online from wherever you are)
  • Cost: FREE!
  • Target audience: IT Professionals (IT Implementers, managers, decision makers)

COURSE:-

Day 1: Deployment & Configuration
Part 1: Understanding the Microsoft Private Cloud
Part 2: Deploying the Infrastructure Components
Part 3: Deploying the Private Cloud Infrastructure
Part 4: Deploying the Service Layer
Part 5: Deploying the Applications & VMs

Day 2: Management & Operations
Part 6: Managing the Infrastructure Components
Part 7: Managing the Private Cloud Infrastructure
Part 8: Managing the Service Layer
Part 9: Managing the Applications & VMs

INSTRUCTOR:-
Students have the opportunity to learn from and interact with the industry’s best cloud technologists! This high-energy, demo-rich learning experience will help IT Professionals understand why Microsoft private cloud solutions are making a splash in the industry. Here are the instructors for this two-day event!

  • Symon Perriman, Microsoft Technical Evangelist
  • Kenon Owens, Technical Product Manager, System Center Cloud and Datacenter Infrastructure
  • Adam Hall, Senior Technical Product Manager, System Center Application Management
  • Sean Christensen, Senior Technical Product Manager, System Center Service Delivery & Automation
  • Anant Sundaram, Senior Product Manager, System Center Cloud and Datacenter Management

What’s a “Jump Start” Course?
Training specifically designed for experienced technologists whose jobs demand they know how to best leverage new, emerging Microsoft technologies. These advanced courses assume a certain level of expertise and domain knowledge, so they move quickly and cover topics in a fashion that enables teams to effectively map new skills to real-world situations. Check out recordings of the Office 365 Jump Start and the Microsoft Virtualization for VMware Professionals, too!

Register now for the Private Cloud Jump Start

The ten most critical certifications that would assure Americans jobs and advancement in the IT marketplace are:

  1. Project Management Professional (PMP) manages projects to a successful conclusion, on-time, on-budget, and using the resources allocated.
  2. Microsoft Certified IT Professional (MCITP) certifications validate your skills in deploying, designing, and maintaining Microsoft technology such as Windows, SQL, SharePoint and Exchange.
  3. CompTIA’s A+ certification indicates competency to install networks, conduct preventative maintenance, secure them and troubleshoot them.
  4. 4.Cisco Certified Network Associates (CCNA) installs, configures, runs and troubleshoots medium-sized routed and switched networks.
  5. Microsoft Certified Technology Specialist (MCTS) cortication validate your skills on implementing and troubleshooting a particular Microsoft Server technology, such as Windows, SQL, SharePoint and Exchange.
  6. CompTIA’s Network+ certification demonstrates competency to manage, maintain, troubleshoot, install and configure basic network infrastructures.
  7. Cisco Certified Network Professional (CCNP) validates the ability to plan, implement, verify and troubleshoot local and wide-area enterprise networks and work collaboratively with specialists on advanced security, voice, wireless and video solutions.
  8. NetApp Certified Data Management Administrator (NCDA) have proven skills in performing in-depth support, administrative functions, and performance management for NetApp storage appliances running the Data ONTAP operating system in NFS and Windows (CIFS) multiprotocol environments.
  9. IT Infrastructure Library certification (ITIL) demonstrates the expertise of professionals in tech management with a three tiered program of basic, intermediate and advanced certification.
  10. CompTIA’s Security+ certification demonstrates knowledge of system security, network infrastructure, access control and organizational security.

Although the above certifications may not guarantee you a job (extenuating circumstances must be taken into account), they certainly improve your chances of gaining meaningful and stable employment.

Accelerate your path to MCM
The Accelerated Exam Preparation program goal is to provide a low cost and convenient solution (less time away from work) for SQL Server MCM exam
“” preparation for candidates that are looking for “final mile” assistance, or looking for advanced training around MCM topic areas.

SQL MCM Sessions

A scheduled series of 7 weeks of live online sessions with a SQL MCM Certified Master presenter covering review of an exam topic and open Q&A time! There will be 2 sessions of 2 hours delivered weekly, with each week focusing on one of the 7 Exam topic areas. Learn More

SQL MCM Labs Courses

A 2 month subscription 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. This is an easy to use, anytime access lab environment to practice the skills you need! Learn More
 

Mehboob

SQL & SharePoint Server Adminstrator – MCITP & MCTS

With this Addarr-Blog, i would like to share knowledge that i have learned.  Any feedback will be warmly welcome because i do believe that we can learn from each other.

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

Automatic SQL Server backup

Posted by Mehboob on 10/02/2012

Automatic SQL Server backup solution and also how to back it up online with SecureBackup. I am using Microsoft SQL Server 2008 Express but you should be able to use these instructions for all versions of Microsoft SQL Server 2005 and Microsoft SQL Server 2008. In my machine, the database files are located in the following directory:

D:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

As you may already know, you cannot backup the *.MDF and *.LDF database files directly because they are attached to the SQL Server. You could detach them, back them up, and then re-attach them but then your database will be offline for a period of time.  To solve this problem, we first need to create a SQL file that can be used later to automate our database backup. Here’s how we can do that:

* Create an SQL file here:-
1. Login to Microsoft SQL Server Management Studio.
2. Right click on your database from the “Databases” node.
3. Select “Tasks” -> “Back up…”
4. You are now presented with the “Back up Database” window. In this window you can specify your backup settings. At a minimum, you need to create a destination for your backup. Click the “Add” button and specify a full path name for your database backup in the “File name” field. You will need to use this path name later, so let’s take note of it.
5. You can choose any other backup options that are important to you. Over on the left hand side is “Options”. I would click on that and decide whether you want to use “append to an existing backup set” or “overwrite all existing backup sets”.
6. Once you are finished with your settings, you need to create an SQL file which will be used later for the automated database backup. To create that SQL file, click on the arrow next to “Script” at the top of the window. There will be an option for “Script action to File”. Go ahead and select that option. You will then be able to save your SQL Server Script File. Take note of where you have saved this file as well.

* Create a batch file here:-
Now that we have created the SQL file, we need to create a batch file that can be automatically executed by the Task Scheduler. To create this file, do the following:

1. Now here Open Notepad and enter the following:
sqlcmd -S .\SQLEXPRESS -i “C:\Users\Administrator\Documents\Backup.sql” Of course, substitute the pathname with the pathname of where you saved your SQL file.
2. Save this file and take note of where you saved it.
3. Now, using Windows Explorer, go to the directory of where you created this file and rename it to have a .bat filename extension instead of .txt.

* Set Batch file to run in Windows Task Scheduler:-
We are now ready to add the batch file to the Task Scheduler. Rather than using the Task Scheduler GUI, I prefer to do it on the command line. You can open a command prompt as Administrator or if you are already running as Administrator, you can use Start -> Run. Either way, enter the following:

schtasks /create /sc Daily /st 011:00:00 /tn “Addarr_Task” /tr “cmd /c E:\Users\Administrator\Desktop\Backup.bat”

Again, substitute the pathname above with that of your batch file. Also, set the time specified to something that is desirable for you. In the above example, we run this task at 11:00 AM.

Set SecureBackup to Backup your Database:-

The time specified in the Task Scheduler step above is important because you need have SecureBackup automatically backup the database file after the task is complete. Since the backup took place at 11:00, you can setup SecureBackup to run the backup at say, 3:00 AM. This way you will have the most recent backup.

From within the SecureBackup software, you need to create or edit an existing  Backup Job and include the location of the backup file that you chose in step 4 of “Create and SQL File” above. If the file isn’t listed and you can’t select it from within SecureBackup, it’s because Windows Task Scheduler has not run your batch file yet. To run the batch file, simply double click on it from within Windows Explorer. It may take anywhere from 10-20 seconds to, possibly, a few hours depending on how large your database is. Once complete, you will have your database backup file and can select that file from within SecureBackup. You will also be able to schedule the Backup Job around how long it took for that batch file to complete.

You now have an automated backup solution for your Microsoft SQL database complete with a secure online storage solution.

Note: You can be able to use these instructions for all versions of Microsoft SQL Server 2005 and Microsoft SQL Server 2008.

Mehboob

SQL & SharePoint – MCTS

 

 

Posted in MS SQL Server | Tagged: , , , , , | Comments Off

Microsoft SQL Server 2012 On March 7

Posted by Mehboob on 02/02/2012

Microsoft Partners Platinum:-

Microsoft SQL Server 2012 On March 7th

Microsoft plans to launch SQL Server 2012 in three editions Enterprise, Business Intelligence and Standard. The Business Intelligence version will feature Power-View data discovery tool, data-quality services and many more useful features.

SQL Server is reducing the number of editions from 6 down to 4 (excluding all the different appliances here).  Those editions will be Express, Standard, Business Intelligence (BI), and Enterprise Edition. The express edition will still be a free edition with limited
functionality.

Microsoft rolled much of the SQL Server 2008 R2 Datacenter edition licensing rights into the SQL Server 2012 Enterprise edition, so the old Datacenter edition will disappear as a top product-line offering. Developer, Express and Compact editions will still be available after the SQL Server 2012 product is released, Microsoft indicated.

Enterprise Edition:-

The Enterprise edition is an all-inclusive product in terms of its features, and Enterprise Edition is majorly for for mission critical applications and large scale data warehousing.  This means that the Enterprise Edition will hold all the new features that are being introduced.

The Enterprise Edition of SQL Server 2012 will include all the features of the BI Edition as well as the Standard Edition.

Business Intelligence (BI) Edition:-
The Business Intelligence edition is a new product offering with 2012. It includes BI features while also including all of the features in the Standard edition. The new edition between the

Standard Edition and the Enterprise Edition called the BI Edition.  The BI Edition will include all the features of the Standard edition plus some extras. The licensing for the BI edition will only be available in a Server+CAL model.  There is no CPU core license available for the BI Edition. While the standard edition supports 16 cores for the database engine, the BI edition supports up to 20 cores for the database engine.  All of the BI services (SSAS, SSIS, SSRS) will support up to the OS maximum number of cores.

The BI edition will include the following features:-

•Data Quality Services
•Master Data Services
•Power View
•Power Pivot for SharePoint Services
•Semantic Model
•Advanced Analytics
The BI Edition will not include the following features:
•Advanced Auditing
•Transparent Data Encryption
•Column Store Index
•Data Compression
•Table/Index Partitioning
•Always On

Standard Edition:-
Microsoft recommends the Standard edition for basic database, reporting and analytics capabilities, according to its white-paper.  Standard edition will be available in either a Server + CAL license model or a CPU Core license model.  The costs for a server license or a CPU Core license remain the same as they were under SQL Server 2008 R2. 

There are some things to note about Standard Edition which are changing from prior editions. As for the support for other features in the standard edition of SQL Server 2012 not a lot of the details have been made available yet.  For the complete support features you’ll have to wait until we get closer to the release of the product.

The standard edition will NOT include the following features:-
•Data Quality Services
•Master Data Services
•Power View
•PowerPivot for SharePoint Services
•Semantic Model
•Advanced Auditing
•Transparent Data Encryption
•Column Store Index
•Data Compression
•Table/Index Partitioning
•Always On

Looking forward any comments, will be great.

Mehboob

Posted in MS SQL Server | Comments Off

 
Follow

Get every new post delivered to your Inbox.