|
|
|
|
|
|
|
|
|
SQL Azure - Adding and Dropping Databases
Its funny how even the smallest video can yield some unexpected learning. CREATE and DROP work pretty much as expected, but did you know that there is a db_manager role you can assign users to if you need to delegate those tasks? Or that if you create a database and drop it, you still get charged for one day?
|
|
|
|
Duration:
|
3
mins
7
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
3.95
out of 5
|
|
Publish Date:
|
June 13, 2010
|
|
|
|
About the Author
|
|
Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site ht...
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
good video for checking knowledge
|
|
Charlie Bruno on
6/26/2010
Nice info on Azure.
|
|
Peter Voutov on
6/29/2010
I noticed that databases are created in FULL recovery mode. Is log space ignored when they measure they size? I imagine the answer is yes, but wanted to check with you in case you knew for certain.
|
|
|
Yes, log space isn't counted when they measure database size.
|
Must Be Logged In
|
|
|
|
|