Tag: SQL Azure

AzureDatabase

February release of Azure Data Studio is now available

on February 14, 2019

image

The February release of Azure Data Studio is now available to download and includes the following key highlights:

  • Introducing Admin pack for SQL Server
  • Auto-sizing columns in results
  • Notebook UI improvements
  • Added Profiler filtering
  • Added Save as XML
  • Added Data-Tier Application Wizard improvements
  • Updates to the SQL Server 2019 Preview extension
  • Turned on results streaming by default
  • Deploy scripts
  • Bug fixes

For a list of the complete updates, refer to the release notes.

Download Azure Data Studio now!

References

https://cloudblogs.microsoft.com/sqlserver/2019/02/13/the-february-release-of-azure-data-studio-is-now-available/

Database

Installing Extensions in SQL Operations Studio

on June 5, 2018

Just like VS Code, extensions provide more functionality to SQL Operations Studio. These extensions can come from Microsoft or the community.

Adding Extensions to SQL Operations Studio

1. Open the Extensions manager by going to the View menu and selecting Extensions. After clicking on the Extensions menu item, the Extensions navigation icon shows up on the left side. I’m not sure why this isn’t always available like it is in VS Code.

image

2. Browse and select an available extension. At this time there are 9 extensions available to choose from. 

image

3. Click on the green button to install the desired extension. In my case I’m trying to install RedGate SQL Search which is a tool I use in SQL Server Management Studio. This will download the extension but if you try to double click and run it, the installation will fail. Instead you need to install it from SQL Operations Studio.

4. From SQL Operations Studio, press Ctrl/Cmd+Shift+p, and type Extensions: Install from VSIX and then press enter.

image

5. You should then see a notification in the bottom right corner of SQL Operations Studio indicating the extension has successfully been installed.

image

Enjoy!

References

What is Microsoft SQL Operations Studio

Installing SQL Operations Studio

Extending the functionality of SQL Operations Studio

AzureEducation

Introducing Azure for Students

on March 2, 2018

Today Microsoft has announced that they will be offering a free $100 annual credit + 25+ free products to eligible students to help encourage them to build cloud apps for Azure and you pay nothing.

Today’s students are the developers of tomorrow

For students seeking the skills leading to the most opportunity for cloud based careers, Azure offers students and educators across the world the resources they need.

This offer is different compared to the current free Azure Credits offers in that no credit card is required, students simply verify their student status to take advantage of this offer. In addition to this free credit, students can also get 750 Hours of Linux Virtual Machines, 250GB of SQL Database, 10 mobile or web apps, 1 million Azure Function requests and so much more.

sshot-390

Get started today and activate your credits at https://azure.microsoft.com/en-us/free/students/#free-products-section

Enjoy!

References

https://azure.microsoft.com/en-us/free/students/

https://azure.microsoft.com/en-ca/education/

CloudDatabaseDevelopment

WebsiteSpark Members Now Have Access To Windows Azure Benefits

on June 28, 2012

Microsoft’s WebsiteSpark program has been updated to now include Windows Azure benefits. If you’re a member of this program then you should have or will be receiving an email to update your account.

You will need to login to your WebsiteSpark account and then click to update your account to include the new Windows Azure benefits.

sshot-239

Here is what is included…

WebsiteSpark members can now get up to $1400 in annual Windows Azure resources to design, develop and deploy their site in the cloud. You will also get to keep at no charge, an Expression Web license upon completion of the 3 year program.

Here is additional information about the WebsiteSpark Azure Offer Details:

sshot-235

In order to take advantage of these additional program benefits, you will need to do this prior to 12/18/2012.

sshot-238

CloudDatabaseDevelopment

Exploring Windows Azure

on June 14, 2012

image

If you don’t already know what Windows Azure is, then it’s Microsoft’s public cloud.

Microsoft’s Windows Azure is flexible, open and rock solid. Windows Azure allows you to quickly build, deploy and manage applications across a global network of Microsoft-managed datacenters. You can build applications using any OS, Language, Database or Tool and it has a 99.95% monthly SLA.

One of the new features I noticed is FREE Web Sites. It allows you to start for free and scale as you go.

When they say open, they have greatly expanded the development languages, framework and tools available, all of which are open source and available on github. Cool!

There are also changes in what servers you can use. Apart from Windows, you can now also install Linux as well in virtual machines.

Azure is really transforming into a cloud that isn’t just limited to the Microsoft technology stack, not that there is nothing wrong with that. I love Microsoft technologies, but I think Microsoft make a smart decision to open up and allows Linux, mySql and other languages to be used.

Speaking of languages, there is now support for 5 major languages and then some.

Languages

image

Developer Features

Data Storage

  • Blob Service
  • Table Service
  • SQL Database
  • SQL Reporting
  • Hadoop

Messaging and Integration

  • Service Bus Queues
  • Service Bus Topics
  • Queue Service
  • Service Bus Relay

Additional Features

  • Caching (AppFabric)
  • Access Control
  • Diagnostics
  • Autoscaling
  • Media Services
  • SendGrid Email Service
  • Twilio

Free Trial

With the free trial you can…

  • Quickly deploy websites to a highly scalable cloud environment
  • Easily deploy and manage virtual machines running Windows Server and Linux
  • Create highly scalable applications in a rich PaaS environment
  • Create, manage and distribute media in the cloud

The free trial contains:

compute 750 small compute hours per month
web sites 10 shared web sites
relational database 1 GB SQL database instance
storage 20 GB with 1,000,000 storage transactions
bandwidth unlimited inbound and 20 GB outbound

There is a lot that can be done with Windows Azure and the only way to know if it’s right for you and your organization is to give it a try and see what you think.

Get started now:

image