Tag: database

Certification

70-464 Developing Microsoft SQL Server Databases Certification Exam

The Developing Microsoft SQL Server Databases (70-464) certification exam is one of the elective exams that counts towards the MCSE: Data Management and Analytics certifications. This exam centers around objectives that cover the areas of developing Microsoft SQL Server databases.

Certification Target Audience

The focus of the 70-464 Developing Microsoft SQL Server Database certification exam is centered around SQL Server technologies. This exam was first published in 2012, with more recent updates done in 2016, so it doesn’t seem to contain the Azure SQL Database topics that other exams cover.

This exam targets those database professionals who build and implement databases across organizations and who ensure high levels of data availability. The database professionals roles would 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’s a high level outline of the skill objectives measured on the Developing Microsoft SQL Server Databases (70-464) certification exam. The percentages next to each of the exam objectives represents the percentage of exam questions in that particular exam objective area.

  • Implement database objects (30-35%)
    • Create and alter tables
    • Design, implement, and troubleshoot security
    • Design the locking granularity level
    • Implement indexes
    • Implement data types
    • Create and modify constraints
  • Implement programming objects (15-20%)
    • Design and implement stored procedures
    • Design T-SQL table-valued and scalar functions
    • Create, use, and alter user-defined functions (UDFs)
    • Create and alter views
  • Design database objects (25-30%)
    • Design tables
    • Design for concurrency
    • Design indexes
    • Design data integrity
    • Design for implicit and explicit transactions
  • Optimize and troubleshoot queries (25-30%)
    • Optimize and tune queries
    • Troubleshoot and resolve performance problems
    • Optimize indexes
    • Capture and analyze execution plans
    • Collect performance and system information

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

Training Materials

At the time of writing this summary, the 70-464 Developing Microsoft SQL Databases exam has a limited amount of Exam preparation material available. As a result, you may need to focus primarily on Microsoft documentation surrounding the technologies and skills measured on this exam.

However, there is a bit of overlap between this exam and the 70-762 Developing SQL Databases exam. It’s unclear at this time if this new exam is meant to replace this one, but there seems to be overlap either way. As a result, you may be able to use the study materials for 70-762 when studying for the 70-464 exam. You’ll at least want to check it out.

database

Migrate Between Azure SQL Database and SQL Server

For years it’s been difficult to migrate a database that was built in SQL Server to Microsoft Azure SQL Database. Originally, the T-SQL support in Azure SQL wasn’t the same as SQL Server, which caused a lot of pain over the years. The T-SQL support in Azure SQL has been greatly updated / enhanced over the years, but at times a migration is still necessary. Fortunately, SQL Server Management Studio includes the “Deploy Database to Microsoft Azure Database Wizard” which has built-in support to migrate a database from SQL Server to Azure SQL Database. This tool actually works BOTH ways, from Azure to SQL Server and SQL Server to Azure! Read More

BookdatabaseInfrastructure

Free eBook: Migrating SQL Server Databases to Azure

eBookAzureMigratingSqlServerThe “Microsoft Azure Essentials: Migrating SQL Server Databases to Azure” book written by Carl Rabeler has been made a free eBook by Microsoft Press. This book is part of the “Microsoft Azure Essentials” books series. With this book you will learn how SQL Server in Azure is similar to SQL Server in an on-premises environment. You will also learn how they are different. The author, Carl Rabeler, is a content lead for Azure.com and will walk you through the steps of getting started with SQL Server in an Azure Virtual Machine as well as Azure SQL Databases. Read More

ArchitectureAzure StackDevelopmentInfrastructurePowerShell

Azure Stack: Introducing PaaS Services and DevOps Tools

When Microsoft announced the initial Technical Preview release of Azure Stack it was also announced there would be additional services released in the coming weeks. This week, Microsoft announced the addition of Web Apps, SQL database, and MySQL database Platform as a Service (PaaS) services to the Microsoft Azure Stack platform, and some additional new tools too!

The recently released tools and services for Azure Stack can be downloaded and installed on top of any installation of the Azure Stack Technical Preview. This is really the first installment of many more Azure Stack services to come, beyond what comes with the Technical Preview itself. Read More

Development

Azure Web App: Connection Strings

Just as all Azure Web Apps need configuration values, most applications also need to have database Connection String values configured. With Azure Web Apps the Connection Strings are stored/retrieved in a very similar fashion as Azure Web App Application Settings. Connection Strings are also Key / Value pairs of String values, but are separated out into their own section.

Connection Strings are typically used to store the connection information for one or more databases the Web App needs to connect to for storing and retrieving data. The Connection String types supported are SQL Database, SQL Server, MySQL and Custom. Most often the Connection Strings used will be for some kind of SQL RDMS, but the Custom type allows for an additional Connection String to be configured any other type of database connection necessary.

As with Application Settings, the Connection Strings are accessed as normal from .NET code and the values will come from what is set within the Azure Management Portal. In other development environments (Node.js, Java, PHP, Python) the Connection Strings are exposed to code as Environment Variables. Additionally, the Connection Strings are editable within the Azure Management Portal, but are read-only when access through code. Read More

Storage

What is DocumentDB?

AzureDocumentDBLogoBlackAzure DocumentDB is a NoSQL document database that uses the JSON data format for storing and querying documents. Being a feature of Microsoft Azure, DocumentDB offers a nice NoSQL database using JSON documents that includes all of the benefits of Microsoft Azure and the cloud.

Here’s a list of some of the key features DocumentDB offers:

  • PaaS and Scalability
  • Schema-free JSON documents
  • SQL language queries

Read More

Storage

Azure SQL or SQL Server Database?

AzureSQLLogoBlackThere are many things to look at when either migrating an existing application or just building a new application to host on Microsoft Azure. Data storage is definitely a top concern, and along with that is the ability to use SQL Server in many cases. Fortunately, Microsoft Azure provides a couple options for using a SQL Database. Read More