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…Read more 70-464 Developing Microsoft SQL Server Databases Certification Exam
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…Read more Migrate Between Azure SQL Database and SQL Server
The "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.…Read more Free eBook: Migrating SQL Server Databases to Azure
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!…Read more Azure Stack: Introducing PaaS Services and DevOps Tools
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…Read more Azure Web App: Connection Strings
Azure 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…Read more What is DocumentDB?
There 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…Read more Azure SQL or SQL Server Database?