Category Archives: Azure SQL

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…!

 

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.