Skip to main content

Drop/Delete Tables/Stored procedures/Blob in Windows SQL Azure

Good article by Tuvian regarding droping the sql azure tables and store procedures in staging environment.
http://tuvianblog.com/2011/09/26/sql-query-for-truncate-all-tables-in-a-database-in-sqlsql-azure/

*******************

Details on how to access the blob storage on windows azure using visual studio 2010
http://msdn.microsoft.com/en-us/library/windowsazure/ff683677.aspx

Delete Blob:
http://msdn.microsoft.com/en-us/library/windowsazure/dd179413.aspx

Maintainance and Delete Options through browser for storage:
https://www.myazurestorage.com/

Popular posts from this blog

Working hours in six months to a year

I usually try to look for how many hours I have worked on a given project and what hours that I  spend on learning or network management tasks.

Below I have added some hours calculation, after finding the breakdown by months from Berkeley website.


Credit: http://controller.berkeley.edu/payroll/payroll-system-pps/pps-training-materials/number-working-hours-month

2017Working hours six months (Jan 1st - Jun 30th): 
130 days x 8 hours =  1040 hours


Working hours six months (Jul 1st - Dec 31th): 
130 days x 8 hours =  1040 hours

Working hours for the year:
1040 hours + 1040 hours = 2080 hours
MonthWorking Days in the monthMonthly Working Hrs1/2 of working hrsMidpoint of working days in the monthDates of HolidaysJanuary22176888 a.m. 1/172,16February20160808 a.m. 2/1520March2318492Noon 3/1631April20160808 a.m. 4/17May2318492Noon 5/1629June22176888 a.m. 6/16July2116884Noon 7/174August2318492Noon 8/16September2116884Noon 9/154October22176888 a.m. 10/17November22176888 a.m. 11/1610,23,24December21168…