Tuesday, September 21, 2010
Sunday, September 19, 2010
Do you make transaction backups?
Yes -> Do not shrink the log unless you have done some exceptional operation (such as a massive delete) as the "cost" of SQL Server re-growing the Log file is significant, and will lead to fragmentation and thus worse performance.
No and I don't want to -> Change the Recovery Model to "Simple" - Enterprise Manager : Right click database : Properties @ [Options]
Don't know -> Transaction log backups allow you to recover to a "point in time" - you restore the last Full Backup (and possibly a subsequently Differential backup) and then every log backup, in sequence, until the "point in time" that you want to roll-forward to.
Saturday, September 18, 2010
Friday, September 17, 2010
Windows Azure Storage
Azure Blob Compressor
Enables compressing blobs for upload and download
Clumsy Leaf Azure Explorer
Visual studio plug-in
A portal to access blobs, tables and queues
Credit to Neil Mackenzie for this list - fromhttp://nmackenzie.spaces.live.com/blog/cns!B863FF075995D18A!706.entry
http://blogs.msdn.com/b/azuredevsupport/ – Azure Support Team
http://blogs.msdn.com/b/dallas/ – Microsoft Codename Dallas
http://blogs.msdn.com/b/sqlazure/ – SQL Azure Team
http://blogs.msdn.com/b/cloud/ - Windows Azure Developer Tools Team
http://blogs.msdn.com/b/windowsazurestorage/ – Windows Azure Storage Team
http://blogs.msdn.com/b/windowsazure/ – Windows Azure Team
http://blogs.msdn.com/b/partlycloudy/ – Adam Sampson
http://bstineman.spaces.live.com/blog/ – Brent Stineman (@BrentCodeMonkey)
http://blog.structuretoobig.com/ – Brian Hitney
http://channel9.msdn.com/shows/Cloud+Cover/ – Cloud Cover (@cloudcovershow)
http://www.davidaiken.com/ – David Aiken (@TheDavidAiken)
http://davidchappellopinari.blogspot.com/ – David Chappell
http://geekswithblogs.net/iupdateable/Default.aspx – Eric Nelson (@ericnel)
http://gshahine.com/blog/ – Guy Shahine
http://blogs.msdn.com/b/jmeier/ – J.D. Meier
http://blogs.msdn.com/b/jnak/ – Jim Nakashima (@jnakashima)
http://blog.maartenballiauw.be/ - Maarten Balliauw
http://nmackenzie.spaces.live.com/blog/ Neil Mackenzie (@mknz)
http://azuresecurity.codeplex.com/ - Patterns & Practices: Windows Azure Security Guidance
http://oakleafblog.blogspot.com/ – Roger Jennings (@rogerjenn)
http://dunnry.com/blog/ – Ryan Dunn (@dunnry)
http://scottdensmore.typepad.com/blog/ – Scott Densmore (@scottdensmore)
http://blog.smarx.com/ - Steve Marx (@smarx)
http://blogs.msdn.com/b/sumitm/ - Sumit Mehrotra
http://azure.snagy.name/blog/ – Steven Nagy (@snagy)
http://blog.toddysm.com/ - Toddy Mladenov (@toddysm)
http://highscalability.com/ – High Scalability
http://perspectives.mvdirona.com/ – James Hamilton
http://www.allthingsdistributed.com/ – Werner Vogels
SQL Azure does not support the normal SQL Server BACKUP commands.
It does provide inherent data redundancy and reliability. However, this will not help if:
- There is an app bug which corrupts your data.
- There's a hacker who destroys your data
- The Microsoft's datacenter loses all of your data (unlikely but possible)
- You can use the SQL Azure copy commands to copy your database contents to a second, still stored within SQL Azure - this will protect again only the first problem above (assuming the hacker has a way into your Azure store)
- You can use the open source SQL Azure Migration Wizard to download data to a local copy - this will provide a recovery mechanism for all 3 items above
SQL Azure Data Migration
Warning - using this for a backup process will involve a large amount of data transfer (which will cost money), but it's better than not having a backup at all.
To use this tool:
- download it from http://sqlazuremw.codeplex.com/
- choose "Analyze and migrate T-SQL database"
- choose the Azure database - yourserver.database.windows.net - username - username@yourserver - and password.
- Note that you can only connect to the SQL azure database from IP addresses whitelisted on the firewall settings on the SQL Azure web control panel
- choose "[databaseName]"
- choose "script all database objects"
- hit "next" and it will slowly happen
- choose your local SQL server to connect to
- create a new SQL server database
- hit "next" to insert the data into your local database
To do this:
- typically suspend the Azure web application
- use the Azure web user interface to drop the existing SQL Azure database
- run the steps above in reverse - from local to SQL Azure
- restart the Azure web application.
- - dependent on the technical level of the user - or if there's an automation server available, this backup process can be scripted using command line arguments - see the documentation for batch mode - http://sqlazuremw.codeplex.com/releases/view/32334#DownloadId=125697
- - this backup process should perhaps be combined with copy to ensure that the data downloaded is transactionally consistent (http://www.azuresupport.com/2010/08/sql-azure-backup-database-copy/). To do this:
- connect to SQL Azure using SQL Server Management Studio
- open a "New Query"
- type "CREATE DATABASE backupName AS COPY OF mainName"
- Hit Execute
The state of the copy can then be monitored using "select name, state, state_desc from sys.databases where name = 'backupName"
SQL Azure Monitoring
There really isn't much that can currently be done in the way of monitoring the health of an Azure SQL Server.
This http://msdn.microsoft.com/en-us/library/ff394114.aspx document describes the ability to query:
- Database size
- Number of connections - and their activity
- Some simple query performance
There is some access to overall status at http://www.microsoft.com/windowsazure/support/status/servicedashboard.aspx - but this is at a very coarse level.
The only current suggestions for checking a SQL server instance is alive are:
- just rely on Microsoft uptime (under their SLA) - not ideal
- use tools like Nagios to add "HTTP" monitoring to Azure applications connected to the SQL Server database - use this web monitoring to check the health of the server (at least to check it is alive).
- try to build something (e.g. a web app) based around sys.dm_exec_connections (http://msdn.microsoft.com/en-us/library/ff394114.aspx) which would provide some analysis of loading.
- try to extend the enzo SQL library - http://enzosqlbaseline.codeplex.com/ - it's benchmarking tools might give you some clue on current loading (but this monitoring might also impact your current performance).
Thursday, September 16, 2010
creating the sub project 'sharp.Core'. A project with that name is
already opened in the solution."
Then it could be due to problems with AnkhSVN - see
So I had to uninstall source control to get it working....
Tuesday, September 14, 2010
If you hit a problem with ConfigMonitoringPoll - Polling for configuration changes - when using Azure Diagnostics
Polling for configuration changes:Microsoft.WindowsAzure.StorageClient.StorageClientException: The specified blob does not exist. ---> System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult) at Microsoft.WindowsAzure.StorageClient.EventHelper.ProcessWebResponse(WebRequest req, IAsyncResult asyncResult, EventHandler`1 handler, Object sender) --- End of inner exception stack trace --- at Microsoft.WindowsAzure.StorageClient.Tasks.Task`1.get_Result() at Microsoft.WindowsAzure.StorageClient.Tasks.Task`1.ExecuteAndWait() at Microsoft.WindowsAzure.StorageClient.CloudBlob.DownloadToStream(Stream target, BlobRequestOptions options) at Microsoft.WindowsAzure.Diagnostics.ControlChannel.<>c__DisplayClass10.<ConfigMonitoringPoll>b__f() at Microsoft.WindowsAzure.Diagnostics.ControlChannel.TryExpectError(HttpStatusCode status, Action act) at Microsoft.WindowsAzure.Diagnostics.ControlChannel.ConfigMonitoringPoll(Object sender, ElapsedEventArgs args); TraceSource 'WaWebHost.exe' event
public class WebRole : RoleEntryPoint
public override bool OnStart()
public static class AzureDiagnostics
public static void InitializeAzureDiagnostics()
// do not run this code if we're not running in the cloud.
// Enabled the capture of partial crash dumps
// configure and start the diagnostics
DiagnosticMonitorConfiguration dmc = DiagnosticMonitor.GetDefaultInitialConfiguration();
private static void AddInfrastructureLogs(DiagnosticMonitorConfiguration dmc)
dmc.DiagnosticInfrastructureLogs.ScheduledTransferLogLevelFilter = LogLevel.Verbose;
dmc.DiagnosticInfrastructureLogs.ScheduledTransferPeriod = TimeSpan.FromMinutes(10.0);
private static void AddSystemEventLog(DiagnosticMonitorConfiguration dmc)
// Add event collection from the Windows Event Log
dmc.WindowsEventLog.ScheduledTransferLogLevelFilter = LogLevel.Verbose;
dmc.WindowsEventLog.ScheduledTransferPeriod = TimeSpan.FromMinutes(10);
private static void AddLogs(DiagnosticMonitorConfiguration dmc)
dmc.Logs.ScheduledTransferPeriod = TimeSpan.FromMinutes(10);
dmc.Logs.ScheduledTransferLogLevelFilter = LogLevel.Verbose;
private static void AddPerformanceCounters(DiagnosticMonitorConfiguration dmc)
List<string> counters = new List<string>();
counters.Add(@"\Processor(_Total)\% Processor Time");
// These network interfaces removed - not that interesting for now
//counters.Add(@"\Network Interface(*)\Bytes Received/sec");
//counters.Add(@"\Network Interface(*)\Bytes Sent/sec");
foreach (string counter in counters)
PerformanceCounterConfiguration counterConfig = new PerformanceCounterConfiguration();
counterConfig.CounterSpecifier = counter;
counterConfig.SampleRate = TimeSpan.FromSeconds(10);
dmc.PerformanceCounters.ScheduledTransferPeriod = TimeSpan.FromMinutes(5.0);
Monday, September 13, 2010
If you're trying to debug a Bada device and you see "The "COM0" port
did not open." under the entry for the Broker.exe in the Bada IDE
1. If it's the first time you've ever tried to connect then check that
you've installed the necessary USB drivers and have the device
2. If you've previously been using this fine, but this has suddenly
stopped working then try:
--- rebooting your phone
--- killing broker.exe in the PC task manager
--- setting your phone's USB connect to Samsung Kies or to Mass
Storage, and then using Run As rather than Debug As in the IDE
--- hit the task manager on the phone and choose "End All Applications"
I'm not entirely sure what worked for me... but I think it was a
combination of the last few in the end!