Mehboob

" Every cloud has a silver lining "

Archive for December, 2011

Hadoop Tutorial

Posted by Mehboob on 15/12/2011

Tutorial Hadoop or MapReduce can be a task if you get your hand dirty at the start. Most of IT people say it is future tech, let start from very basics .. This tutorial covers the basics of distributed systems design. The pre-requisites are significant programming experience with a language such as C++ or Java, a basic understanding of networking, and data structures & algorithms.

What Is Apache Hadoop?

Start with very basics of MR with http://code.google.com/edu/parallel/dsd-tutorial.html

Then go for the first two lectures in http://www.cs.washington.edu/education/courses/cse490h/08au/lectures.htm

A very good course introduction to MapReduce and Hadoop. Read the seminal paper http://labs.google.com/papers/mapreduce.html

and its improvements in the updated version at
http://www.cs.washington.edu/education/courses/cse490h/08au/readings/communications200801-dl.pdf

Then go for all the other videos in the U.Washington link given above to understand distributed systems in detail (optional).

Try youtubing the terms Map reduce and Hadoop to find videos by ORielly and Google RoundTable for good overview of the future of Hadoop and MapReduce

Then off to the most important videos – Cloudera Videos
http://www.cloudera.com/resources/?media=Video

And Google MiniLecture Series
http://code.google.com/edu/submissions/mapreduce-minilecture/listing.html

Along with all the Multimedia above we need good written material Documents:

Architecture diagrams at hadooper.blogspot.com are good to have on your wall Hadoop: The definitive guide goes more into the nuts and bolts of the whole system where as Hadoop in Action is a good read with lots of teaching examples to learn the concepts of hadoop. Pro Hadoop is not for beginners pdfs of the documentation from Apache Foundation

http://hadoop.apache.org/common/docs/current/

And 

http://hadoop.apache.org/common/docs/stable/

Will help you learn as to how model your problem into a MR solution in order to gain the advantages of Hadoop in total.  HDFS paper by Yahoo! Research is also a good read in order to gain in depth knowledge of hadoop distributed file system Try the http://developer.yahoo.com/hadoop/tutorial/module1.html link for beginners to expert path to Hadoop.

All this for Hadoop lover. Install Hadoop on Ubunto Server through this vedio, no aduio, just hang on with this so you can make it.

Hadoop Part 1 – Install Ubuntu Server 10.04

Part 2

Part 3

Part 4

Part 5

 

 Mehboob

SQL – SPS  DBA – MCTS

Posted in Cloud | 2 Comments »

Microsoft Learning Product

Posted by Mehboob on 12/12/2011

Microsoft Learning Product:  Each course may have two related files: a zipped (.zip) file that contains content in .pdf and .xps formats, and an executable (.exe) file that contains other supplemental content.  Instructions here we go ..

1. In the Course Number field below, enter your course number, and then click Find to find your course.

2. Next to your course, click the related links to download the supplemental course materials.

3. When the Download dialog box appears, click Save and then select a destination on your computer or other storage device where you want to save your supplemental course materials.

Course Title Content file Executable file
2124C Programming with C# 2124C-ENU-Companion.zip (17.8 MB) 2124C-ENU-Allfiles.exe (741 KB)
2261C Supporting Users Running the Microsoft Windows XP Operating System 2261C-ENU-Companion.zip (6.66 MB) None
2262B Supporting Users Running Applications on a Microsoft Windows XP Operating System 2007 2262B-ENU-Companion.zip (1.53 MB) 2262B-ENU-Allfiles.exe (69.2 MB)
2272C Implementing and Supporting Microsoft Windows XP Professional 2272C-ENU-Companion.zip (7.44 MB) None
2273B Managing and Maintaining a Microsoft Windows Server 2003 Environment 2273B-ENU-Companion.zip (57.2 MB) 2273B-ENU-Allfiles.exe (39.1 MB)
2274C Managing a Microsoft Windows Server 2003 Environment 2274C-ENU-Companion.zip (30.5 MB) 2274C-ENU-Allfiles.exe (39.1 MB)
2275C Maintaining a Microsoft Windows Server 2003 Environment 2275C-ENU-Companion.zip (2.76 MB) 2275C-ENU-Allfiles.exe (298 MB)
2276C Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts 2276C-ENU-Companion.zip (1.91 MB) 2276C-ENU-Allfiles.exe (62.5 KB)
2277C Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services 2277C-ENU-Companion.zip (22.9 MB) 2277C-ENU-Allfiles.exe (77.5 KB)
2285B Installing, Configuring, and Administering Microsoft Windows XP Professional
2310D Developing Web Applications Using Microsoft Visual Studio 2008 SP1 2310D-ENU-Companion.zip (15.2 MB) 2310D-ENU-Allfiles.exe (235 MB)
2349B Programming with the Microsoft .NET Framework (Microsoft Visual C# .NET) 2349B-ENU-Companion.zip (6.45 MB) 2349B-ENU-Allfiles.exe (1.74 MB)
2556A Developing Mobile Applications Using the Microsoft .NET Compact Framework 2556A-ENU-Companion.zip (5.60 MB) 2556A-ENU-Allfiles.exe (2.62 MB)
2559B Introduction to Visual Basic .NET Programming with Microsoft .NET 2559B-ENU-Companion.zip (17.0 MB) 2559B-ENU-Allfiles.exe (1.20 MB)
2609A Introduction to C# Programming with Microsoft .NET 2609A-ENU-Companion.zip (4.93 MB) 2609A-ENU-Allfiles.exe (13.4 MB)
2779B Implementing a Microsoft SQL Server 2005 Database 2779B-ENU-Companion.zip (3.11 MB) 2779B-ENU-Allfiles.exe (882 KB)
2780B Maintaining a Microsoft SQL Server 2005 Database 2780B-ENU-Companion.zip (3.21 MB) 2780B-ENU-Allfiles.exe (24.9 MB)
2791A Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services 2791A-ENU-Companion.zip (2.44 MB) 2791A-ENU-Allfiles.exe (7.20 MB)
2792A Implementing and Maintaining Microsoft SQL Server 2005 Integration Services 2792A-ENU-Companion.zip (2.60 MB) 2792A-ENU-Allfiles.exe (866 KB)
2793A Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services 2793A-ENU-Companion.zip (2.92 MB) 2793A-ENU-Allfiles.exe (6.94 MB)
2823B Implementing and Administering Security in a Microsoft Windows Server 2003 Network 2823B-ENU-Companion.zip (21.7 MB) 2823B-ENU-Allfiles.exe (226 MB)
2830B Designing Security for Microsoft Networks 2830B-ENU-Companion.zip (34.1 MB) 2830B-ENU-Allfiles.exe (40.6 MB)
2933A Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006
2956B Core Foundations of Microsoft .NET 2.0 Development
2957B Advanced Foundations of Microsoft .NET 2.0 Development
3938C Updating Your Skills from Microsoft Exchange Server 2000 or Microsoft Exchange Server 2003 to Microsoft Exchange Server 2007 SP1 3938C-ENU-Companion.zip (3.00 MB) 3938C-ENU-Allfiles.exe (186 KB)
4994A Introduction to Programming Microsoft .NET Framework Applications with Microsoft Visual Studio 2005 4994A-ENU-Companion.zip (1.54 MB) 4994A-ENU-Allfiles.exe (11.7 MB)
4995A Programming with the Microsoft .NET Framework Using Microsoft Visual Studio 2005 4995A-ENU-Companion.zip (1.54 MB) 4995A-ENU-Allfiles.exe (20.9 MB)
5047B Introduction to Installing and Managing Microsoft Exchange Server 2007 SP1 5047B-ENU-Companion.zip (2.80 MB) 5047B-ENU-Allfiles.exe (98.7 KB)
5049A Managing Message Security Using Microsoft Exchange Server 2007 5049A-ENU-Companion.zip (3.59 MB) None
5050A Recovering Messaging Servers and Databases Using Microsoft Exchange Server 2007 5050A-ENU-Companion.zip (1.88 MB) None
5060A Implementing Microsoft Windows SharePoint Services 3.0 5060A-ENU-Companion.zip (5.40 MB) None
5061A Implementing Microsoft Office SharePoint Server 2007 5061A-ENU-Companion.zip (93.4 MB) 5061A-ENU-Allfiles.exe (2.55 MB)
5115B Installing, Configuring, and Troubleshooting Windows Vista 5115B-ENU-Companion.zip (41.5 MB) None
5118B Supporting Windows Vista and Applications in the Enterprise None
5927A Microsoft Office Project 2007, Managing Projects 5927A-ENU-Companion.zip (2.83 MB) None
5928A Microsoft Office Project Server 2007, Managing Projects 5928A-ENU-Companion.zip (2.87 MB) 5928A-ENU-Allfiles.exe (345 KB)
6066A Developing Managed Applications for Windows Mobile 6 6066A-ENU-Companion.zip (4.21 MB) 6066A-ENU-Allfiles.exe (11.0 MB)
6067A Developing Native Applications for Windows Mobile 6 6067A-ENU-Companion.zip (4.10 MB) 6067A-ENU-Allfiles.exe (6.62 MB)
6158C Updating Your Microsoft SQL Server 2005 Skills to SQL Server 2008 None
6214A Effective Team Development Using Microsoft Visual Studio Team System 2008 6214A-ENU-Companion.zip (3.36 MB) None
6215A Implementing and Administering Microsoft Visual Studio 2008 Team Foundation Server 6215A-ENU-Companion.zip (3.95 MB) None
6231A Maintaining a Microsoft SQL Server 2008 Database 6231A-ENU-Companion.zip (4.16 MB) 6231A-ENU-Allfiles.exe (313 KB)
6231B Maintaining a Microsoft SQL Server 2008 R2 Database 6231B-ENU-Companion.zip (4.11 MB) 6231B-ENU-Allfiles.exe (73.0 MB)
6232A Implementing a Microsoft SQL Server 2008 Database 6232A-ENU-Companion.zip (4.21 MB) 6232A-ENU-Allfiles.exe (222 KB)
6232B Implementing a Microsoft SQL Server 2008 R2 Database 6232B-ENU-Companion.zip (3.47 MB) 6232B-ENU-Allfiles.exe (38.1 MB)
6292A Installing and Configuring Windows 7 6292A-ENU-Companion.zip (3.79 MB) None
6293A Troubleshooting and Supporting Windows 7 in the Enterprise 6293A-ENU-Companion.zip (3.51 MB) None
6294A Planning and Managing Windows 7 Desktop Deployments and Environments 6294A-ENU-Companion.zip (4.42 MB) None
6317A Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to SQL Server 2008 DBA Skills
6331A Deploying and Managing System Center Virtual Machine Manager
6367A Introduction to Object-Oriented Programming with Microsoft Visual Studio 2008 6367A-ENU-Companion.zip (4.19 MB) 6367A-ENU-Allfiles.exe (48.9 MB)
6368A Programming with the Microsoft .NET Framework Using Visual Studio 2008 6368A-ENU-Companion.zip (4.06 MB) 6368A-ENU-Allfiles.exe (90.3 MB)
6416C Updating Your Network Infrastructure and Active Directory Technology Skills to Windows Server 2008 6416C-ENU-Companion.zip (4.85 MB) None
6416D Updating Your Windows Server 2003 Technology Skills to Windows Server 2008 None
6417B Updating your Applications Infrastructure Technology Skills to Windows Server 2008 None
6418C Deploying Windows Server 2008 None
6419A Configuring, Managing, and Maintaining Windows Server 2008 Servers 6419A_ENU-Companion.zip (5.73 MB) 6419A-ENU-Allfiles.exe (46.5 MB)
6419B Configuring, Managing and Maintaining Windows Server 2008-based Servers None
6420B Fundamentals of Windows Server 2008 None
6421B Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure 6421B-ENU-Companion.zip (4.12 MB) None
6422A Implementing and Managing Windows Server 2008 Hyper-V 6422A-ENU-Companion.zip (2.21 MB) None
6423A Implementing and Managing Windows Server 2008 Clustering None
6425B Configuring and Troubleshooting Windows Server 2008 Active Directory Domain Services 6425B-ENU-Companion.zip (2.87 MB) None
6425C Configuring and Troubleshooting Windows Server 2008 Active Directory Domain Services 6425C-ENU-Companion.zip (4.05 MB) None
6426B Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory 6426B-ENU-Companion.zip (3.79 MB) None
6426C Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory 6426C-ENU-Companion.zip (3.32 MB) 6426C-ENU-Allfiles.exe (25.6 MB)
6427A Configuring and Troubleshooting Internet Information Services in Windows Server 2008
6428A Configuring and Troubleshooting Windows Server 2008 Terminal Services 6428A-ENU-Companion.zip (2.20 MB) None
6429A Configuring and Managing Windows Media Services for Windows Server 2008 6429A-ENU-Companion.zip (3.04 MB) 6429A-ENU-Allfiles.exe (39.0 MB)
6430B Planning for Windows Server 2008 Servers 6430B-ENU-Companion.zip (3.67 MB) None
6431A Managing and Maintaining Windows Server 2008 Network Infrastructure Servers
6432A Managing and Maintaining Windows Server 2008 Active Directory Servers
6433A Planning and Implementing Windows Server 2008 None
6435A Designing a Windows Server 2008 Network Infrastructure 6435A-ENU-Companion.zip (2.85 MB) None
6436A Designing Active Directory Infrastructure and Services in Windows Server 2008 6436A-ENU-Companion.zip (4.12 MB) None
6437A Designing a Windows Server 2008 Applications Infrastructure 6437A-ENU-Companion.zip (3.09 MB) None
6438A Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 None
6445A Implementing and Administering Windows Small Business Server 2008 6445A-ENU-Companion.zip (3.13 MB) 6445A-ENU-Allfiles.exe (6.55 MB)
6446A Implementing and Administering Windows Essential Business Server 2008 None
6451B Planning, Deploying, and Managing Microsoft System Center Configuration Manager 2007 6451B-ENU-Companion.zip (5.22 MB) None
6744A Configuration et résolution des problèmes en utilisant Internet Information Services dans Windows Server® 2008
6745A Internetinformationsdienste in Windows Server® 2008: Konfiguration und Problembehandlung
10231A Designing a Microsoft SharePoint 2010 Infrastructure 10231A-ENU-Companion.zip (3.70 MB) 10231A-ENU-Allfiles.exe (3.60 MB)
10232A Designing and Developing Microsoft SharePoint Server 2010 Applications 10232A-ENU-Companion.zip (4.09 MB) 10232A-ENU-Allfiles.exe (62.7 MB)
10233A Designing and Deploying Messaging Solutions with Microsoft Exchange Server 2010 10233A-ENU-Companion.zip (3.41 MB) None
10262A Developing Windows Applications with Microsoft Visual Studio 2010 10262A-ENU-Companion.zip (4.29 MB) 10262A-ENU-Allfiles.exe (43.2 MB)
10263A Developing Microsoft Windows Communication Foundation Solutions with Microsoft Visual Studio 2010 10263A-ENU-Companion.zip (3.44 MB) 10263A-ENU-Allfiles.exe (9.48 MB)
10264A Developing Web Applications with Microsoft Visual Studio 2010 10264A-ENU-Companion.zip (4.8 MB) 10264A-ENU-Allfiles.exe (56.6 MB)
10265A Developing Data Access Solutions with Microsoft Visual Studio 2010 10265A-ENU-Companion.zip (4.21 MB) 10265A-ENU-Allfiles.exe (120 MB)
10266A Programming in C# with Microsoft Visual Studio 2010
10267A Introduction to Web Development with Microsoft Visual Studio 2010 10267A-ENU-Companion.zip (5.87 MB) 10267A-ENU-Allfiles.exe (304 MB)
10324A Implementing and Managing Microsoft Desktop Virtualization 10324A-ENU-Companion.zip (4.51 MB) None
10325A Automating Administration with Windows PowerShell 2.0 10325A-ENU-Companion.zip (3.57 MB) 10325A-ENU-Allfiles.exe (2.67 MB)
10337A Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 10337A-ENU-Companion.zip (3.76 MB) 10337A-ENU-Allfiles.exe (11.1 MB)

Download or run exe file, good luck.

Any feedback will be warmly welcome because i do believe that we can learn from each other.

Mehboob

MS SQL & SharePoint Server Adminstrator – MCITP & MCTS

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

Database Engine Tools

Posted by Mehboob on 06/12/2011

Microsoft SQL Server 2008 includes a complete set of tools and command prompt utilities that allow users, programmers, and administrators to:

* Administer and configure SQL Server.

* Determine the catalog information in a copy of SQL Server.

* Design and test queries for retrieving data.

* Copy, import, export, and transform data.

* Provide diagnostic information.

* Start and stop SQL Server.

Command prompt – CMD – utilities that come with Microsoft SQL Server

Utility Description Installed in
bcp Utility Used to copy data between an instance of Microsoft SQL Server and a data file in a user-specified format. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
dta Utility Used to analyze a workload and recommend physical design structures to optimize server performance for that workload. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
dtexec Utility (SSIS Tool) Used to configure and execute an Integration Services package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility. <drive>:\Program Files\Microsoft SQL Server\100\DTS\Binn
dtutil Utility (SSIS Tool) Used to manage SSIS packages. <drive>:\Program Files\Microsoft SQL Server\100\DTS\Binn
Deployment Utility (Analysis Services – Multidimensional Data) Used to deploy Analysis Services projects to instances of Analysis Services. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn\VShell\Common7\IDE
osql Utility Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
Profiler Utility Used to start SQL Server Profiler from a command prompt. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
rs Utility Used to run scripts designed for managing Reporting Services report servers. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
rsconfig Utility Used to configure a report server connection. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
rskeymgmt Utility Used to manage encryption keys on a report server. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
sqlagent90 Application Used to start SQL Server Agent from a command prompt. x:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn
sqlcmd Utility Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
SQLdiag Utility Used to collect diagnostic information for Microsoft Customer Service and Support. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
sqllogship Application Used by applications to perform backup, copy, and restore operations and associated clean-up tasks for a log shipping configuration without running the backup, copy, and restore jobs. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
sqlmaint Utility Used to execute database maintenance plans created in previous versions of SQL Server. x:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
sqlps Utility Used to run PowerShell commands and scripts. Loads and registers the SQL Server PowerShell provider and cmdlets. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
sqlservr Application Used to start and stop an instance of Database Engine from the command prompt for troubleshooting. x:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
Ssms Utility Used to start SQL Server Management Studio from a command prompt. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
tablediff Utility Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology. <drive>:\Program Files\Microsoft SQL Server\100\COM

Any comments will be learning point.

Mehboob

SQL & SPS DBA – MCTS

Posted in MS SQL Server | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.