SQL Server 2012

  1. Home
  2. Capacity Building
  3. Previous Initiatives
  4. Microsoft Innovation Centre
  5. Skills Accelerator Program
  6. SQL Server 2012

Microsoft SQL Server 2012 helps unlock exciting new insights with pervasive data discovery across mounds of structured, unstructured and cloud data sources backed by Managed Self-Service BI, credible consistent data and large-scale data warehousing and analytics solutions.

SQL Server 2012 offers agility to quickly create and scale solutions that solve challenges and fuel new business opportunity from server to private or public cloud linked together with common tools for optimized productivity and cutting-edge developer technologies—build once, deploy and manage wherever.

Accomplishments

Workshop

Session

Workshop - February 02, 2012

 Top
The event comprised of 4 hour long learning & evangelism activities on SQL Server 2012.
 
Agenda
  • Introduction of Features released in 2005 and 2008
  • T-SQL Enhancements in 2012
  • File Stream and File Table
  • Availability Features
  • Reporting Services
  • Overview of Azure Features in SQL Server 2012
  • New IDE Features (Juneau)
  • LocalDB (Zero Deployment Configuration)

About the Trainer

Mr. Zafar Ahmad is the CTO of Bitlogix (Pvt) Ltd. He has extensive experience of development using Microsoft technologies & platforms. Mr. Zafar has long association with Microsoft and has been part of some of the large scale Microsoft Technology implementations local and International as well. Mr. Zafar is also a Microsoft Community speaker and has delivered technology sessions, workshops and Bootcamps at different forums.

About the Participants

More than 27 DBAs / Consultants / Software Engineers from different Microsoft Partners and Independent Software Vendors (ISV) attended the session. A Four hours long discussions and demonstrations remained focused towards the Roadmap & Concepts of SQL Server 2012, T-SQL Enhancement, and Reporting Services etc. Training gave participants an opportunity to learn new features released in SQL Server 2012.

Session - February 02, 2012

 Top

A session on “Microsoft SQL SERVER” was held on 2nd of Feb 2015. The event comprised of 2 hour long learning & evangelism activities.

Agenda

  • Introduction (Waits and Queues in SQL Server)
  • Threading Model in SQL Server
  • How and Why Waits Occur
  • Latches and Spinlocks
  • Troubleshooting using Waits and Queues

About Speaker

Aasim Abdullah is first Microsoft MVP (SQL Server) award (2014-2015) winner, working as senior SQL Server DBA at a multinational company. He has written over 200 technical articles on his blog http://www.connectsql.com and http://connectsql.beyondrelational.com/. In addition to his Master’s Degree in Computer Science, he has over 7 years of experience in the industry. He has been working with SQL Server since 2007 (Version 2005 to 2012) and has used it in many projects as a developer, administrator, database designer. Aasim's primary interest is SQL Server performance tuning. If he finds the time, he like to sketch faces with graphite pencils.

About Participants

More than 15 developers / Architects/IT Pros/DBAs from Software Industry. A 2 hour long discussions and implementation remained focused towards the Roadmap & Concepts "SQL Server Performance Troubleshooting using Waits and Queues Method".  Training gave participants an opportunity to learn, build their Applications/Solutions with SQL Server.