Category: database

ArchitectureBig DataBlockchaindatabase

Blockchain is not just for Cryptocurrency, but for Enterprises and the Future

The term “Blockchain” has been gaining a lot of buzz; especially in more recent time. It all started with Bitcoin and Cryptocurrencies, but has taken off as a pretty remarkable advancement in secure communication and database technology. Blockchain is not just for cryptocurrencies, and many Enterprises are seeing how it can be applied to the business world. With it’s link to cryptocurrency, it seems pretty obvious that it could be used for the Financial industry, but that’s really only the tip of the iceberg (so to say). There are MANY other potential uses for Blockchain within various IT solutions that transcend what you might think at first glance. This article describes what Blockchain is, where it came from, and how it can be utilized in some really innovative ways. Read More

Certificationdatabase

70-473 Cloud Data Platform Solutions Exam – June 2017 Update

The 70-473 Designing and Implementing Cloud Data Platform Solutions certification exam was first published Oct. 27, 2015. A lot of things with Microsoft Azure have changed in the time since it was first published. For this reason Microsoft does publish updates to the various certification exams, and this past June 2017, Microsoft published an update to the exam to bring it in line with the current state of the Azure data platform. This article outlines the current state of this certification exam. Read More

databaseportal

CosmosDB: The New DocumentDB NoSQL Database in Microsoft Azure

DocumentDB has been around for awhile now in Microsoft Azure. It’s a Document based, NoSQL database in the cloud. There’s been tons of advancements to the service over time, including MongoDB API support so you can use it in place of MongoDB for existing code bases. It’s always been called “DocumentDB” since initial release of the service, but for a time it was labeled as “NoSQL (DocumentDB)” in the Azure Portal. It seems there was some indication that Microsoft wasn’t happy with the name they first chose.

Today, we wake up in the morning to updates that have been made to the Azure Portal where DocumentDB is no longer there. Well, it actually is there, but has undergone renaming / rebranding. From this day forward, DocumentDB will no longer be called DocumentDB. Instead we will call this NoSQL, Document based database service….. Azure Cosmos DB.

From this day forward, DocumentDB will no longer be called DocumentDB. Instead we will call this NoSQL, Document based database service….. Azure Cosmos DB.

This naming change to CosmosDB isn’t the only thing released. There’s the all new “Data Explorer” UI in the Azure Portal that makes it a bit easier to use DocumentDB… ahem… CosmosDB too!

In the sessions and documentation that will come out of Microsoft and from the Microsoft Build 2017 conference which starts today, I’m sure we’ll hear all about these changes coming to our favorite NoSQL, Document store in the Microsoft Azure cloud.

For now, here are some link to additional artifacts I’ve found that show evidence that Microsoft is in fact renaming DocumentDB to CosmosDB:

Here’s the description in the Azure Portal when you search for “CosmosDB” in the Azure Marketplace:

Azure Cosmos DB is a fully managed, globally-distributed, horizontally scalable in storage and throughput, multi-model database service backed up by comprehensive SLAs. Azure Cosmos DB is the next generation of Azure DocumentDB. Cosmos DB was built from the ground up with global distribution and horizontal scale at its core – it offers turn-key global distribution across any number of Azure regions by transparently scaling and replicating your data wherever your users are. You can elastically scale throughput and storage worldwide and pay only for the throughput and storage you need. Cosmos DB guarantees single-digit millisecond latencies at the 99th percentile anywhere in the world, offers multiple well-defined consistency models to fine-tune for performance and guaranteed high availability with multi-homing capabilities – all backed by industry leading service level agreements (SLAs).

Cosmos DB is truly schema-agnostic – it automatically indexes all the data without requiring you to deal with schema and index management. Cosmos DB is multi-model – it natively supports document, key-value, graph and columnar data models. With Cosmos DB, you can access your data using NoSQL APIs of your choice — DocumentDB SQL (document), MongoDB (document), Azure Table Storage (key-value), and Gremlin (graph), are all natively supported. Cosmos DB is a fully managed, enterprise ready and trustworthy service. All your data is fully and transparently encrypted and secure by default. Cosmos DB is ISO, FedRAMP, EU, HIPAA, and PCI compliant as well.

Happy discovering new features!!

Certificationdatabase

New MCSA: Azure Database Development Certification from Microsoft

There have been many changes to the Microsoft certification program lately. Among these changes have been brand new MCSA and MCSE certifications, including MANY new exams. Among these changes is the recent addition of the MCSA: Cloud Database Development certification.

Update May 27, 2017: Microsoft announced that they’ve renamed the MCSA: Cloud Database Development certification to MCSA: Azure Database Development.

Read More

Certificationdatabase

New MCSA: Data Engineering with Azure Certification from Microsoft

There have been many changes to the Microsoft certification program lately. Among these changes have been brand new MCSA and MCSE certifications, including MANY new exams. Among these changes is the recent addition of the MCSA: Big Data Engineering certification.

Update May 27, 2017: Microsoft announced that they’ve renamed the MCSA: Big Data Engineering certification to MCSA: Data Engineering with Azure.

Read More

databasePaaSVideo

Create Azure SQL Database in the Azure Portal

Here’s a short video that shows you how to create an Azure SQL Database in the Azure Portal. It also explains how to connect to the database, and how the relationship between Azure SQL Databases and Azure SQL Servers works. Additionally, a few other features are overviewed such as Geo-Replication, Transparent Data Encryption and others.

Please, subscribe to get more videos like this all around Microsoft Azure.

This is one of the first videos I’ve published to the Build Azure YouTube Channel where I’m starting to build out video content to accompany this site. Enjoy!

Certificationdatabase

70-762 Developing SQL Databases Certification Exam

Microsoft has been expanding out the certification offerings around Microsoft Azure. The Provisioning SQL Databases (70-765) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers Azure SQL Databases and hosting SQL Server within Virtual Machines (VMs).

Certification Target Audience

The focus on the Developing SQL Databases (70-762) certification exam is centered around SQL Server and Azure SQL Database. The exam is designed to target candidates who build and implement databases across organizations and who ensure high levels of data availability. The ideal candidates responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

Skills Measured

Here is a high level list of the skills and objectives measured on the Developing SQL Databases (70-762) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Design and implement database objects (25-30%)
    • Design and implement a relational database schema
    • Design and implement indexes
    • Design and implement views
    • Implement columnstore indexes
  • Implement programmability objects (20-25%)
    • Ensure data integrity with constraints
    • Create stored procedures
    • Create triggers and user-defined functions
  • Manage database concurrency (25-30%)
    • Implement transactions
    • Manage isolation levels
    • Optimize concurrency and locking behavior
    • Implement memory-optimized tables and native stored procedures
  • Optimize database objects and SQL infrastructure (20-25%)
    • Optimize statistics and indexes
    • Analyze and troubleshoot query plans
    • Manage performance for database instances
    • Monitor and trace SQL Server baseline performance metrics

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

At the time of writing this summary of the 70-762 Developing SQL Databases exam, there is a limited amount of Exam preparation material available. You’ll need to focus mostly on the Microsoft documentation surrounding the technologies and skills measured on this exam for now. However, there an Exam Reference book from Microsoft Press being published soon!

Below is a summary of the exam reference book:

Exam Ref 70-762 Developing SQL Databases

Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

Focus on the expertise measured by these objectives:

  • Design and implement database objects
  • Implement programmability objects
  • Manage database concurrency
  • Optimize database objects and SQL infrastructure

This Microsoft Exam Ref:

  • Organizes its coverage by exam objectives
  • Features strategic, what-if scenarios to challenge you
  • Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases

Happy Studying!

Certificationdatabase

70-768 Developing SQL Data Models Certification Exam

Microsoft has been expanding out the certification offerings around Microsoft Azure. The Developing SQL Data Models (70-768) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers topics that apply to both SQL Server and Azure SQL Database.

Certification Target Audience

The focus on the Developing SQL Data Models (70-768) certification exam is centered around SQL Server and Azure SQL Database topics like SSAS, BI, MDX and DAX. The exam is designed to target candidates who are Business Intelligence (BI) developers who are focused on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Skills Measured

Here is a high level list of the skills and objectives measured on the Provisioning SQL Databases (70-765) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Design a multidimensional business intelligence (BI) semantic model (25-30%)
    • Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
    • Design and implement dimensions in a cube
    • Implement measures and measure groups in a cube
  • Design a tabular BI semantic model (20-25%)
    • Design and publish a tabular data model
    • Configure, manage, and secure a tabular model
    • Develop a tabular model to access data in near real time
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
    • Create basic MDX queries
    • Implement custom MDX solutions
    • Create formulas by using the DAX language
  • Configure and maintain SQL Server Analysis Services (SSAS) (30-35%)
    • Plan and deploy SSAS
    • Monitor and optimize performance
    • Configure and manage processing
    • Create Key Performance Indicators (KPIs) and translations

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

At the time of writing this summary of the Developing SQL Data Models (70-768) exam, there is a limited amount of Exam preparation material available. You’ll need to focus mostly on the Microsoft documentation surrounding the technologies and skills measured on this exam for now. However, there an Exam Reference book from Microsoft Press being published soon!

Below is a summary of the exam reference book:

Exam Ref 70-768 Developing SQL Data Models

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-768 Developing SQL Data Models certification exam, the second of two exams required for MCSA: SQL 2016 Business Intelligence Development certification.

Authored by Microsoft Data Platform MVP Stacia Varga, Exam Ref 70-768 Developing SQL Data Models offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database and business intelligence professionals need to succeed with SQL Server 2016 Analysis Services. Coverage includes:

  • Designing multidimensional BI semantic models
  • Designing tabular BI semantic models
  • Developing queries using MDX and DAX
  • Configuring and maintaining SQL Server Analysis Services

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not “one-size-fits-all” content
  • Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through a set of “what if?” scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro’s job role

Happy Studying!

Certificationdatabase

70-765 Provisioning SQL Databases Certification Exam

Microsoft has been expanding out the certification offerings around Microsoft Azure. The Provisioning SQL Databases (70-765) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers Azure SQL Databases and hosting SQL Server within Virtual Machines (VMs).

Certification Target Audience

The focus on the Provisioning SQL Databases (70-765) certification exam is centered round SQL Server and Azure SQL Database. The exam is designed to target candidates who are Architects, Senior Developers, Infrastructure Specialists, and Development Leads. These candidates should have experience and knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. It will also be good to have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

Skills Measured

Here is a high level list of the skills and objectives measured on the Provisioning SQL Databases (70-765) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Implement SQL in Azure (30-35%)
    • Deploy a Microsoft Azure SQL Database
    • Plan for SQL Server installation
    • Deploy SQL Server instances
  • Manage databases and instances (35-40%)
    • Configure secure access to Microsoft Azure SQL Databases
    • Configure SQL Server performance settings
    • Manage SQL Server instances
  • Deploy and migrate applications (30-35%)
    • Deploy applications to Microsoft Azure SQL Database
    • Deploy applications to SQL Server on Azure Virtual Machines
    • Migrate client applications

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

At the time of writing this summary of the 70-765 Provisioning SQL Databases exam, there is a limited amount of Exam specific training material available. You’ll need to rely fairly heavily on the Microsoft documentation when studying for this exam. No exam guide or prep books are available, however there is a Practice Test available.

Happy studying!