Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.
Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.
A developer and DBA both sometime have their own priority and preferences when it is about database designs. If you are a DBA or a developer you must learn cross domain expertise features. One of the similar features is DACPAC. What is the use of DACPAC?
Data-tier applications are a great start for simple data centric application designs. This Hint talks about the root of the documentation. Well, will you be able to use DACPAC with SQL Azure? If yes, how?
Import and Export is one of the most important tasks any DBA performs. DBAs often have their own style of doing tasks while developers have their own preference. DACPAC is a great tool which is building bridges between DBA and Developers. In SQL Azure, the process of data import and export has been one of the very interesting features. I suggest that you head to Azure Portal and do little experiments with its features.
SQL Server Interview Questions and Answers ISBN: 1466405643 Page#64
Azure Interview Questions and Answers – Guest Post by Paras Doshi – Day 25 of 31
Introduction to SQL Azure – Creating Database and Connecting Database
Note: The SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.
Reference: Pinal Dave (http://blog.sqlauthority.com)