Database Lifecycle Management Guidance Updated by Microsoft
Microsoft has updated the database lifecycle management curated guidance page in the MSDN library, which provides relevant resources for SQL Server Data Tools, SQL Server Management Studio and Windows Azure SQL Database. The page features SQL Server database lifecycle management diagram to identify the applications and actions that apply to your database scenarios.
For instance, if you need to know more about Windows Azure SQL database backup and restore then you just need to navigate to backup and restore task located under Windows Azure SQL Database section and you will be able to view a detailed tutorial of the task with source codes, screenshots and external references.
"The subject matter is curated for students and others new to the industry. I hope it helps them," says Louis Berner who works as a Technical Writer/Software Engineer with SQL Server User Education.
As of the time of this writing, following topics are covered in the database lifecycle management guidance page.
SQL Server Data Tools
- Microsoft SQL Server Data Tools (SSDT)
- Get Started with SQL Server Data Tools - Video
- Microsoft SQL Server Data Tools: Database Development from Zero to Sixty - Video
- Data Development Technical Documentation
- Data Portability
- Tools and Utilities Support (Windows Azure SQL Database)
- Guidelines and Limitations (Windows Azure SQL Database)
- SQL Server Data Tools Team Blog
SQL Server Management Studio
- Managing Windows Azure SQL Database Using SQL Server Management Studio
- Backup and Restore of SQL Server Databases
- Migrating Databases to Windows Azure SQL Database
- The New World of Data: SQL Server and Hybrid IT - Video
- Get Started with SQL Data Sync
- SQL Server Team Blog
Windows Azure SQL Database
- Get Started with Windows Azure SQL Database
- Monitor Windows Azure SQL Database Using Dynamic Management Views
- Windows Azure SQL Database Backup and Restore
- How to: Import and Export a Database (Windows Azure SQL Database)
- Windows Azure Training Kit - November 2012
- Windows Azure Training Kit - GitHub
- Windows Azure 90-day Free Trial
- Windows Azure SQL Database Connection Management
- Windows Azure SQL Database Connectivity Troubleshooting Guide
- Windows Azure SQL Database Community Forum
- Windows Azure Team Blog
- Windows Azure Service Dashboard
- Stackoverflow for Windows Azure SQL Database
In an interview to InfoQ, Louis explained the purpose behind the creation of a curated page for database lifecycle management.
InfoQ: Do you think the flowchat diagram will really assist developers to code quickly and without any frustration?
The diagram provides a holistic view of SSDT, SSMS, Azure, and a hybrid architecture in terms of the actions that connect them. For example, you can publish from SSDT to Azure; you can import to SSDT from a local instance of SQL Server; and you can export a .bacpac file from SQL Database on Azure to a local disk.
It is the "publish," "import," and "export" actions - along with the other operations in the visual - that tie together the Microsoft applications in the diagram. The visual presentation is not intended to assist developers to code quickly or without frustration, but rather to connect the dots for customers and provide a visual sense of cohesion between the applications that contribute to the database lifecycle.
InfoQ: From your point of view, who will benefit from the resources provided on the DLM page?
The DLM topic is the result of work I am doing with Microsoft Customer Support Services (CSS). CSS Support Engineers have data that indicate barriers to adoption of the Azure platform because customers are confused about:
- How to get started with SQL Server Data Tools
- How to get existing data migrated to the Azure platform - i.e., data portability options
- How to compare and sync data
- How to backup to the Cloud or how to use Import/Export features
- How to do backup and restore operations from the Cloud in order to satisfy their SLA requirements
You can see from the list of topics that they are mostly 100-level and 200-level concepts. So the initial release of the DLM topic - published end-Jan-2013 - addresses adoption of the Azure platform, data portability, getting up-and-running, and basic developer tasks. Future DLM topic updates will include more advanced subjects like:
- Performance - latency, throttling, wait statistics
- Error reference
- PowerShell scripting
- Permissions and roles
I continue to consume CSS data to ensure that I address customer top tasks. The new topics listed above are from the latest cut of CSS customer data.
InfoQ: Do you have any plan to update DLM topic page frequently?
The plan is to update the topic each quarter. The next update should be ready to publish in May/June 2013.
I am developing a workflow to analyze customer data, build a backlog of topics, review the backlog with project stakeholders, publish updates to the topic, and validate that the topic is meeting customer needs.
It is a method of content curation, as nearly all of the content listed in the DLM topic already exists somewhere on the Web. I am collecting the best-of-breed content, tutorials, video, and community assets in a single repository, and customers seem to like my approach.
InfoQ: Do you have any estimate regarding how many developers really benefited from the DLM resource page?
Since Jan-2013, the topic has > 3,000 page views on MSDN, excellent customer ratings, and verbatim comments like "Awesome" and "Very helpful" It may not meet everyone's needs, but for the target audience: new to Azure, new to SQL Server, frustrated with getting started, looking for the best documentation and video available - I have begun to build a following.
Todd Montgomery Dec 19, 2014