Archive

Posts Tagged ‘SQL Server 2012’

MCSA in 90 days… & lot of resources

Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts. Here is the link: 90 Days to MCSA – where you have 6 videos, 3 per Windows 2012 and 3 others for SQL Server 2012 MCSA Certification prep. There are also some additional resources like Discussion Forums and Resource Wikis. In the right corner, you have another resource, Certification Challenge where you can find more and more info about Certs path!

A good news for the Exams, is that you can win a voucher to save 20 % + Second Shot for free (just in case if you failed!!!), check here, a great offer from Microsoft Virtual Academy – another great resource for the courses about the SQL Server.

Knowledge is the Power – Learning is the key!

Learn & Enjoy!

 

Ctrl+R in SSMS 2012

After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like in early versions, and one of the most shortcut key that I had problem after my installation of the SQL Server 2012 in the SSMS has been well known shortcut Ctrl+R to remove the last results pane from the SSMS! Ok lets take a look few steps how to activate it in the new SSMS of the SQL Server 2012:

Select > Tools > Customize … click “Keyboard”

In the list window scroll down and find to select “Window.ShowResultsPane”
Go to “Use new shortcut in:” – select “SQL Query Editor”
Go to “Press shortcut keys” text box and press Ctrl+R
Click “Assign” and finally OK!

Now, when you execute a select statement in SSMS and you have results set, you can remove them, pressing Ctrl+R, that is very often used from the Developers and DBA to clear the results pane!

This is very little help and enjoy it!

Stay Tuned…!

New road to the SQL Server 2012 Certifications

MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old way was with MCTS (DBA, DB Dev & BI) and MCITP (DBA, DB Dev & BI) series.

Now, the new way is to earn the MCSA pack that is in combination of 3 exams:

Exam 461 - Querying MS SQL Server 2012
Exam 462 – Admin a MS SQL Server 2012
Exam 463 – Implementing DataWarehouses with SQL Server 2012

Also the upgrade road is available, so everything you need in details are here.

After MCSA Certification series for the SQL Server 2012 that is in the same level like MCTS and where these certifications validates a set of core SQL Server 2012 skills that are relevant across multiple solution areas, the next level will be MCSE for the SQL Server 2012 that are more specific type:

Data Platform – for building and administering data solutions including Cloud.
BI – Business Intelligence solutions and reports.

Data Platform = MCSA + Exams (464 & 465)
BI = MCSA + Exams (466 & 467)

Upgrades are available also for both MCSE Certifications on SQL Server 2012 …for more info >>> Data Platform & BI  

Stay Tuned and wish you success with new certifications! 

Tech Days Albania 2012

I’m very excited for the invitation to present at TechDays Albania 2012, which will be held on April 19, 2012 in Tirana. The event will be held on the perfect environment of the Tirana International Hotel. Well, for the first time we have only Albanian speakers except our guest Karl Davies Barrett. I will be honored to present Top 10 reason to Love SQL Server 2012 for Developers, where I will try to bring really ten things that are attractive for the developers in SQL Server 2012.

In parallel with the Tech Days Albania 2012, the Microsoft will organize also the IT Camp which is totally oriented to the Cloud Technology.

Agenda for the Tech Days Albania 2012:

What’s New – Windows 8

It’s Windows reimagined and reinvented from a solid core of Windows 7 speed and reliability. It’s an all-new touch interface. It’s a new Windows for new devices.

Windows Identity Foundation

The Windows Identity Foundation helps simplify user access for developers by externalizing user access from applications via claims and reducing development effort with pre-built security logic and integrated .NET tools.

10 reason to love SQL Server 2012 for the Developers

Microsoft SQL Server is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.

MVC 4 for Web Applications

ASP.NET MVC 4 is a framework for developing highly testable and maintainable Web applications by leveraging the Model-View-Controller (MVC) pattern. The framework encourages developers to maintain a clear separation of concerns among the responsibilities of the application – the UI logic using the view, user-input handling using the controller, and the domain logic using the model.

Take a ride on the Metro Application Platform

What should you be doing to prepare for Windows 8, and to what extent will you have to revise your existing skill set? This session answers these questions and more as it takes you under the hood and demonstrates how to write Metro applications

What’s New in Visual Studio 11

This section contains information about some of the important enhancements to Visual Studio 11 Beta

I will put the list of the speakers who will cover the agenda above:

Arben Murtaj – Microsoft Albania, Technology Strategist
Karl Davis Barrett (@karl_db) - Developer Platform Evangelist @ Microsoft
Elton Ropi - Software Architect at ikubINFO
Dukagjin Maloku (@DugiDBA)- Leader of the Albanian SQL Server Users Group
Betim Drenica (@betimdrenica)- Leader of the Albanian .Net Users Group
Arian Celina (@ariancelina)- Software developer

Stay Tuned

Categories: Events, SSC Tags: , ,
Follow

Get every new post delivered to your Inbox.

Join 880 other followers