Ok so I found out exactly the size of every table in my SQL Azure Database, but now I’d like to know a little bit more, since I’m paying and I want to know how the payment is related to each of my tables. So in order to do this and after reading this blog post from the SQL Azure Team, this is the statement I’ve come up with: DECLARE @SizeInBytes bigint SELECT @SizeInBytes = (SUM(reserved_page_count) * 8192) FROM sys.dm_db_partition_stats DECLARE @Edition sql_variant SELECT @Edition =DATABASEPROPERTYEX ( DB_Name() , ‘Edition’ ) Select @Edition, @SizeInBytes So now I … Continue reading Check SQL Azure Database Associated Cost
I was looking at my SQL Azure Database and suddenly I saw that I had to clean some space because it was already beyond the maximum quota that I had defined for the Database, but I needed to know exactly where the most space was being used in order to better understand not only what was the size, but why and where was the space being used. So my first action was, Ok so I’ll use the storeprocedure sp_spaceused. Exec sp_spaceused So with this I know exactly the space that my database is using, and if I … Continue reading Check SQL Azure Database Size
Just last Tuesday at Porto and Thursday at Lisbon I did a session in Microsoft WebDay Portugal event about WIF and Silverlight 4.0. Here are the resources I used: Slides Wif and sl4 (pt) View more presentations from Nuno Godinho. After this I’ll do a series of posts about this subject explaining all that was shown in the session and more.
Just last Tuesday at Porto and Thursday at Lisbon I did a session in Microsoft WebDay Portugal event about Extensibility with Silverlight 4.0 and MEF. Here are the resources I used: Slides Extensibility with sl4 and mef (en) View more presentations from Nuno Godinho. Demos Complete Demo Script for all Demos ViewModel Injection Starter Completed ViewModel Extension Starter Completed Dynamic XAP Loading Starter Completed Dynamic XAP Navigation Starter Completed After this I’ll do a series of posts about this subject explaining all that was shown in the session and more.