Category Archives: Learning

SQL Server 2016 Certifications MCSA Update

Microsoft just announced the release of the 3 new MCSA Certifications about the SQL Server 2016, which will cover professional work with on-premises and cloud based databases.

Database Development  – with exams:

70-761 > Querying Data with T-SQL
70-762 > Developing SQL Databases

Database Administration – with exams:

70-764 – Administering a SQL Database Infrastructure
70-765 – Provisioning SQL Databases

Business Intelligence Development – with exams:

70-767 – Implementing a SQL Data Warehouse
70-768 – Developing SQL Data Models

So, the exams 70 – 762 / 765 / 768 are scheduled to be released on September 2016.

For more details, click here

Stay Tuned…!

 

PASS Summit 2016 – call for Speakers…

PASSi

PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals, with lot of the tech sessions covering a lot for the Database Development, Database Administration, BI, Cloud, Professional Developement, Training, Tips’n’Tricks and much more.

It is going to be held on 25-28 Oct, 2016 in Seattle – US and here it is the offical website:

http://www.sqlpass.org/summit/2016/Welcome.aspx

Call for speakers is now open and you can find more details how to apply and submit your abstracts in the link-location below:

http://www.sqlpass.org/summit/2016/Speakers/CallForSpeakers.aspx

Stay Tuned…

 

 

SCU EU 2016

Hello folks, this post is to inform you about the SCU EU 2016 Conference which is going to be held on 24-26 August, 2016 in Berlin (Germany).

SCUEU2016

Conference Venue will be in Berlin Congress Center – Alexanderstrasse 11 10178 Berlin-Germany.

This conference will cover lot of the System Center, Virtualization on Hyper-V and other Microsoft products and technologies that could be very attractive and interesting for your incoming Projects and Data Centers. It’s 3 days Conference wiht more than 60 breakout sessions, with lot of the top-notch professional speakers and much more where you check the official website:

http://www.systemcenteruniverse.ch/

If you plan to attend, you can catch the EARLY Bird for the Full Conference PASS till April 30, 2016.

Stay Tuned….

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!

 

SQL Saturday Kosovo #225

sqlsat225_web

I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and it’s our firs time SQL Saturday where I will speak also. However I’ve started the challenge journey to organize things properly. The most important thing here for our local community is that the list of the speakers will be all the MVPs for SQL Server.

More information will be in our official website at SQL Saturday #225 Kosovo.

SQL Server features that are not supported by Azure SQL Database

SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that are not supported and here are some of them (short info):

SQL Server 2008 R2 features that are not supported by Azure SQL Database:

  • SQL Server Utility
  • Master Data Services

SQL Server 2008 features that are not supported by Azure SQL Database:

  • Change Data Capture
  • Data Auditing
  • Data Compression
  • Extended Events
  • Filestream Data
  • Integrated Full-Text Search
  • Policy-Base Management
  • Resource Governor
  • SQL Server Replication
  • Transparent Data Encryption

SQL Server 2005 features that are not supported by Azure SQL Database

  • Common Language Runtime (CLR and CLR User-Defined Types)
  • Database Mirroring
  • Service Broker
  • Table Partitioning
  • XML Indexing

Other features that are not supported as well:

  • Backup and Restore
  • Replication
  • Extended Store Procedure
  • SQL Server Agent

For more information you can check here.