Lets Go Forward... SQL Server Series..No. 2

Life is full of challenges and twists.Before we Go Forward in this SQL Server series of Posts.

Few things to remember:

1. Forget the Past Failures to make your Future Success.
2. Control your life to move in positive direction.
3. Don't run away from problems..Think twice to Solve them.
4. 'No Procrastination"...Make a Action Plan to set your Goals.
5. After each Completion of your goal,Appreciate your Success.  

Goal : SQL Server Certificaions

Exam	Credit For	Selected Topics
70-461: Querying Microsoft SQL Server 2012	MCSA for SQL Server 2012 MCSE for SQL Server 2012 Data Platform MCSE for SQL Server 2012 Business Intelligence	Create/design tables and views Use joins, sub-queries, new data types and query features Create/design/modify stored process, aggregate functions, triggers Modify data with INSERT/UPDATE/DELETE/MERGE Design/apply user-defined functions
70-462: Administering Microsoft SQL Server 2012 Databases	MCSA for SQL Server 2012 MCSE for SQL Server 2012 Data Platform MCSE for SQL Server 2012 Business Intelligence	Install SQL Server 2012 and related services Create and manage SQL Server instances, including a clustered instance Diagnose and respond to blocking, locking, deadlocking Backup and restore databases Implement and maintain indexes Contrast and compare AlwaysOn technologies
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012	MCSA for SQL Server 2012 MCSE for SQL Server 2012 Data Platform MCSE for SQL Server 2012 Business Intelligence	Design/implement star vs. snowflake schemas, fact tables, dimensions, keys Create/apply project level connection managers, slowly changing dimensions, fuzzy lookups Execute SSIS packages with SSMS, DTEXEC, SQL Server Agent Create, assign, read variables and parameters Plan and implement full and incremental loads for data warehouses Implement solutions with Data Quality Services
70-464: Developing Microsoft SQL Server 2012 Databases	MCSE for SQL Server 2012 Data Platform	Create/implement database objects without using built-in tools Apply data types: CLR, sequential GUID values, spatial Understand relative advantages of database tables, temporary tables, and table variables Create, assign, read variables and parameters Create and alter indexes, including filtered, semantic, XML Optimize queries with execution plans and DTA
70-465: Designing Database Solutions for Microsoft SQL Server 2012	MCSE for SQL Server 2012 Data Platform	Apply physical database issues, such as filestream and file groups Monitor an instance using such tools as Profiler, Perfmon and DMVs Automate (setup, maintenance, monitoring) across multiple databases and multiple instances Design instance-level security, such as logon triggers, transparent data encryption, DDL triggers Manage maintenance administration, such as rebuild vs. defrag indexes, online vs. offline index rebuild Implement high availability via clustered servers, mirroring, replication
70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012	MCSE for SQL Server 2012 Business Intelligence	Implement cubes: build cube with SQL Server Data Tools, configure additive and non-additive measures, and implement many-to-many relationships Create and debug MDX queries Contrast multidimensional and tabular data models Deploy SSAS databases Know SSRS report and design issues, such as crosstab report, drill-down reports, report parameters Configure report data sources and datasets
70-467: Designing Database Solutions for Microsoft SQL Server 2012	MCSE for SQL Server 2012 Business Intelligence	Specify and optimize MDX and DAX queries Use partitioning to speed up the loading of a fact table Design a BI reporting architecture, including such features as linked reports, drill-down reports, sub reports Know when to choose between UDM and BISM Possess a working knowledge of how to implement MDX calculations Design SSIS deployments using the project deployment model, passing values at execution time, sharing parameters between packages

Microsoft Certified Solutions Master

The MCSM level consist of two platforms (SQL Server and Intelligence):

MCSM: Data Platform

Prerequisite: MCSE: Data Platform

• Exam 986: MCSM Data Platform Knowledge

• Exam 986: MCSM Data Platform Lab

• This level of certification will require the completion of Lab-based and Technical exams

MCSM: Intelligence

Prerequisite: MCSE: Business Intelligence Platform

Microsoft Certified Architect

Prerequisite: MCSM: SQL Server and MCSM: Intelligence

MCA: SQL Server

Full requirements are still being finalised.  More information can be found at http://www.microsoft.com/learning/en/us/certification/MCSM-sql-server-data-platform.aspx

Testing Meetup @ Bangalore on Dec 1,2012

BDotNet UG - Dec 1 - Jim Holmes, Test evangelist

B.NET

Microsoft, Signature Building, Embassy Golf Links, Domlur, Bangalore

Saturday, December 1, 2012 from 10:30 AM to 1:00 PM (IST)

Bangalore, India

Speaker Bio:

Jim Holmes, Test Automation Veteran and Telerik Test Studio Evangelist.

Session 1: 

Title: UI Test Automation Isn’t All Shiny Toys.

Session 2: 

Title: Avoiding Brittle UI Tests

Note: Please register at eventbrite if you are making it to the UG meet.

Ticket Information

TYPE	END			QUANTITY
FREE	Dec 1, 2012	Free		1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30

Register

TechDays 2013 - Chennai

Event ID: 1032536819 Chennai Trade Centre CTC Complex NandambakkamChennai 600 089India Product(s):  Windows 8 and Windows Phone. Audience(s):  Developer Generalist. Register for Event Starts: 05 December 2012 08:30 Ends: 05 December 2012 23:00 Time zone: (GMT+05:30) India Register

I am looking for Change... Lets Start with a New Series of Learning

Hello,

I always look for a change in what i do.

Why a Change?

"Change" - This word has a power in it,it can transform an ideas to thoughts and to make it reality.

Now this series of posts will be silent witness to the battles and struggles,to reach where i want to be.

I have started my journey as "Dot Net Developer" and Now At Present as a "Software Tester"..but the destination is not predefined.

New Series

I am hoping this series of posts will be useful and the series of articles will be  posted regularly.

This series of topics will be on "SQL Server" - My Favorite Technology.

Inspiration Quote:

"I’ve failed over and over and over again in my life and that is why I succeed – Michael Jordan"

Introduction to Go & Google Cloud Offerings @ Bangalore,Nov 30

Time: 2.30pm  - 5.30pm

Fee: Free Entry

Agenda:

Introduction to GO Speaker : Sathish V J

Introduction to the Google Cloud for Developers Speaker: Lynn Langi

Venue

Google India Pvt. Ltd
No. 3, RMZ Infinity - Tower E
3rd, 4th, and 5th Floors
Old Madras Road
Bangalore, 560 016
India
Phone: +91-80-6721-8000

SAP TechEd @ Bangalore on Nov 28-30

jQuery Gems Book by Greg Sidelnikov released...

Buy jQuery Gems - A jQuery Tutorial book by Greg Sidelnikov

Click on Buy Now...

SQL Server UG Meet @ Bangalore - Nov 24,2012

Microsoft User Group - Developer Day @ Hyderabad,Nov 24,2012

Developer Day – November 24, @ S&P Capital IQ (Hyderabad)

Interesting News: 

 S&P Capital IQ is hiring Software Engineers & Architects (Microsoft Developer Technologies) for their Hyderabad location and they will be at the event on 24th November to meet & interact with you. So be there and do not miss this opportunity at any cost. And do not forget to bring along your CV !

Session details are as follows:
--------------------------------------------------------------

2.00 pm - 2.15 pm : Opening Keynote by Amit Bansal (co-founder, HelloWorldGeeks.com).

2.15 pm - 3.15 pm : Hidden facts of .NET 4.5 language jems by Abhishek Sur (co-founder, HelloWorldGeeks.com, MVP)

Abstract: Languages are essential component of any developer technology. .NET languages have been enhanced a lot recently. This session will introduce new language features and show the internals of its implementations to help you decide when and where a feature could be optimally utilized.

3.15 pm - 3.30 pm : Session by S&P Capital IQ HR Team.

3.30 pm - 3.45 pm : Refreshments.

3.45 pm - 4.45 pm : Panel Discussion (open ended) on Microsoft Developer Technologies

Abstract: Feel free to ask any developer related question to our expert panel comprising of Ramesh Viswanathan (S&P Capital IQ), Abhishek Sur & Himabindu Vejella (Microsoft). Do not miss this opportunity to interact with our expert panel in an open ended discussion around Microsoft Developer Technologies.

4.45 pm- 5.00 pm : Closing note.

--------------------------------------------------------------

Date: November 24' 2012, Saturday

Time: 1.00 pm to 5.00 pm

Venue: S&P Capital IQ,
       SDE Prameela Techno Park, Survey No.12P, Kondapur Village,
       RR Dist, Hyderabad
       Opposite to Jayabheri Silicon valley or Google office

Parking: Parking arrangements have been made in SP Capital premises.

(Note: The event will start sharp at 1.30 pm. Please come by 1.00 pm for registration. Please bring a valid photo ID. For any clarifications, feel free to call Mamita Sinha at +91 9007009017)