OakLeaf Systems

Learn more about Datacastle · data

GO
function Call_sp_ClearOldLogs() {
    console.log("Executing sp_ClearOldLogs...");
    mssql.query('EXEC dbo.sp_ClearOldLogs', {
        success: function(results) {
        console.log("Finished executing sp_ClearOldLogs.");
        }
    });
}
var httpRequest = require('request');
var account_sid = "<< account SID >>";
var auth_token = "<< auth token >>";
 
// Create the request body
var body = "From=" + from + "&To=" + to + "&Body=" + message;
 
// Make the HTTP request to Twilio
httpRequest.post({
    url: "https://" + account_sid + ":" + auth_token +
         "@api.twilio.com/2010-04-01/Accounts/" + account_sid + "/SMS/Messages.json",
    headers: { 'content-type': 'application/x-www-form-urlencoded' },
    body: body
}, function (err, resp, body) { console.log(body); });
var sendgrid = new SendGrid('**username**', '**password**');       
sendgrid.send({
    to: '**email-address**',
    from: '**from-address**',
    subject: 'Error while exeucting stored procedure',
    text: 'Error message here'
}, function(success, message) {
    // If the email failed to send, log it as an error so we can investigate
    if (!success) {
        console.error(message);
    }
});
[DataTable(Name = "sas")]
public class SAS
{
    public int Id { get; set; }
    [DataMember(Name = "container")]
    public string Container { get; set; }
    [DataMember(Name = "filename")]
    public string FileName { get; set; }
    [DataMember(Name = "url")]
    public string Url { get; set; }
}
var sas = (await App.MobileService.GetTable<SAS>().Where(x => x.FileName == "myfile.txt" && x.Container == "mycontainer").ToEnumerableAsync()).Single();
var url = sas.Url;
function read(query, user, request) {

    var filename = query._parsed.filter.left.right.value;
    var containername = query._parsed.filter.right.right.value;
        
    var url = getSignedBlobUrl(60, "teched", containername, filename);
    console.log('Created new SAS: ' + url);
    
    request.respond(statusCodes.OK, [{ url: url }]);

}
function getSignedBlobUrl(expiryTimeout, accountName, containerName, blobName)
{
    var start = new Date();
    var end = new Date(start.getTime() + (1000 * 60 * expiryTimeout));

    var signature = generateSignature(start, end, accountName, containerName, blobName);
    var queryString = "?st=" + encodeURIComponent(start.toIsoString()) + "&se=" + 
                        encodeURIComponent(end.toIsoString()) + "&sr=b&sp=w&sig=" + 
                        encodeURIComponent(signature);
    return "http://" + accountName + ".blob.core.windows.net/" + containerName + "/" + blobName + queryString;
}
var crypto = require('crypto')
var key = new Buffer('XXXXX', 'base64')

function generateSignature(startTime, endTime, account, container, blobName) {
    var stringToSign = "w\n" + 
                        startTime.toIsoString() + "\n" + 
                        endTime.toIsoString() + "\n/" + 
                        account + "/" + container + "/" + blobName + "\n"
   var hash =  crypto.createHmac('sha256', key).update(stringToSign).digest('base64')
   return hash; 
}
Date.prototype.toIsoString = function() {  
   var d = this;  
   function p(i) { return ("0"  + i).slice(-2); }  
   return "yyyy-MM-ddTHH:mm:ssZ"  
      .replace("yyyy", d.getFullYear())  
      .replace("MM", p(d.getUTCMonth() + 1))  
      .replace("dd", p(d.getUTCDate()))  
      .replace("HH", p(d.getUTCHours()))  
      .replace("mm", p(d.getUTCMinutes()))  
      .replace("ss", p(d.getUTCSeconds()));  
};
mssql.query('select top 1 * from statusupdates', {
    success: function(results) {
        console.log(results);
    }
});
create procedure [darkskies].[NewLocationsForChannel] 
(
    @channelUri as nvarchar(512) = null
)
as

select c.ChannelUri, count(1) as NumNewLocations
from darkskies.Channel c
inner join darkskies.PointOfInterest p 
on c.UserId = p.UserId 
where p.LastUpdated > c.LastUpdated
and c.ChannelUri = @channelUri
group by c.ChannelUri
function updateBadge(channelUri) 
{                  
       var params = [channelUri];
       var sql = "exec darkskies.NewLocationsForChannel ?";
       mssql.query(sql, params,
       {
            success: function(results) {
                if (results.length > 0) {
                    for (var i=0; i< results.length; i++)
                    {
                           if (results[i].ChannelUri !== null && 
                                results[i].ChannelUri.length > 0)
                           {                                                      
                                push.wns.sendBadge(results[i].ChannelUri, 
                                    results[i].NumNewLocations);
                           }             
                    }               
              }
        }
    });
} 
<tile>
  <visual>
    <binding template="TileSquarePeekImageAndText04">
      <image id="1" src="image1" alt="alt text"/>
      <text id="1">Text Field 1</text>
    </binding>  
  </visual>
</tile>
<tile>
  <visual>
    <binding template="TileSquareText02">
      <text id="1">some text</text>
      <text id="2">more text</text>
    </binding>  
  </visual>
</tile>
var raw = new mpns.rawNotification('My Raw Payload', options);
var payload = "<tile><visual><binding template='TileWideImageAndText02'>" +
      "<image id='1' src='" + xmlEscape(bigImage) + "' alt='map'/>" +
      "<text id='1'>" + text1 + "</text>" +
      "<text id='2'>" + text2 + "</text>" +
      "</binding>" +
      "<binding template='TileSquareImage' branding='none'>" +
      "<image id='1' src='" + xmlEscape(smallImage) + 
      "' alt='map'/></binding></visual></tile>";

push.wns.send(channelUri, payload, 'wns/tile', 
{
        client_id: 'ms-app://<snip>',
        client_secret: 'i will never tell',
        headers: { 'X-WNS-Tag' : 'MainTile' }   
}...
var xmlEscape = function (text) {
    return text.replace(/&/g, '&amp;')
       .replace(/</g, '&lt;')
       .replace(/>/g, '&gt;')
       .replace(/"/g, '&quot;');    
}
azure vm create DNS_PREFIX -o vmdepot-66-2-2 -l "East US" USER_NAME [PASSWORD] [--ssh] [other_options] 
azure vm create larryriak -o vmdepot-66-2-2 -l "East US" larry secretpassword --ssh

	Geolocation sample end to end using Windows Azure Mobile Services (New) This sample provides an end to end location scenario with a Windows Store app using Bing Maps and a Windows Azure Mobile Services backend. It shows how to add places to the Map, store place coordinates in a Mobile Services table, and how to query for places near your location.
	Enqueue and Dequeue messages with Windows Azure Mobile Services and Services Bus (New) My Store - This sample demonstrates how you can enqueue and dequeue messages from your Windows Store apps into a Windows Azure Service Bus Queue via Windows Azure Mobile Services. This code sample builds out an ordering scenario with both a Sales and Storeroom and app.
	Capture, Store and Email app Feedback using Windows Azure Mobile Services(New) This sample shows how you can implement a Feedback charm option in your Windows Store application and submit the feedback to be both stored Windows Azure Mobile Services and emailed directly to you.
	Upload File to Windows Azure Blob Storage using Windows Azure Mobile Services (New) This demonstrates how to store your files such as images, videos, docs or any binary data off device in the cloud using Windows Azure Blob Storage. In this example we focus on capturing and uploading images, with the same approach you can upload any binary data to Blob Storage.
	Create a Game Leaderboard using Windows Azure Mobile Services (New) The My Trivia sample demonstrates how you can easily add, update and view a leaderboard from your Windows Store applications using Windows Azure Mobile Services.

	PROS	CONS
VIP Swap	Fast and simple.	Usual VIP swap restrictions apply.
Delete/Re-deploy	Can make any change to the updated application. VIP swap restrictions do not apply.	Loss of availability while the application is deleted and then redeployed. Potential change in the public IP address after the redeployment.

Friday, January 11, 2013

The database

Scheduling the stored procedure

Alerts and Notifications

New Videos

Requirements

Using a community image

Publishing a VM

Create a custom VM and publish a VHD to the VM Deopot

Publishing the VHD to the VM Depot

Final Thoughts

Images

Predefined / Platform Images

Creating or Bringing Our Own Images

Disk

OS Disk

Data Disk

*Temporary Disk

A hands-on tutorial

Attaching Disks to Virtual Machines

Striping Volume to Data Disks in VM

Conclusion and coming up next

Review

References

Deploying an Image from VM Depot

Publishing an Image on VM Depot

New Relic & The Rise of the New Kingmakers

Things To Consider

Best Practices – Protection Against Hardware Issues

Best Practices – Cloud Services Development

Best Practices – Windows Azure Storage/SQL Database

Some General Recommendations

Best Practices – Windows Azure SQL Database (WASD)

Best Practices – Windows Azure Storage (Blobs, Tables & Queues)

Best Practices – Managing Latency

Some Recommended Reading

Summary

Introduction

LightSwitch Cosmopolitan Shell Source Code Released!

LightSwitch Speaking Tour = Success!

Update available for WCF Data Services

More Notable Content this Month

Top Forum Answerers

LightSwitch Team Community Sites

Step 1: Open the solution in Visual Studio.

Step 2: Upgrade the Project

Step 4: Modify the Web Role to use .NET 4.5

Deploying using VIP Swap

Step 1: Generate the .cspkg and .cscfg files for upload.

Step 2: Uploading the Files to the Staging Slot using the Windows Azure Portal

Step 3: Test the new deployment

Step 4: Perform the VIP Swap to Production

General scripting

Scripting Mobile Services

Virtual Machines (Powershell only)

Using the CLI within your favorite development environments

0 comments:

Forbes: Who Are The Top 20 Influencers in Big Data?

TRAACKR: Who Are The Top 50 Data Science Influencers?

Blog Archive

OakLeaf Blog Curations on Curah!

Links to SQL Azure Labs and Other Big Data Articles

Windows Azure Mobile Services Preview Walkthrough for Windows Store Apps

OakLeaf's New Windows Azure WebSites

Check Out OakLeaf's New Azure DataMarket Offerings

SearchCloudComputing Articles

Articles for Red Gate Software's ACloudyPlace

Windows Azure Articles for Developer.com

DZone Syndication

Feeds

OakLeaf Systems' Listings in Microsoft Pinpoint

Links to Cover Stories for Visual Studio Magazine

The Windows Azure Team Interview, 11/30/2010

OakLeaf Blog Ranked #134 of Influential Data Blogs by eCairn

OakLeaf Systems' Windows Azure Table Services Sample Project

Check Out the OakLeaf SharePoint Online Site

Google Blog Search

Windows Azure Questions & Answers

About Me

My Latest Books