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!
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.
2. Browse and select an available extension. At this time there are 9 extensions available to choose from.
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.
5. You should then see a notification in the bottom right corner of SQL Operations Studio indicating the extension has successfully been installed.
What is Microsoft SQL Operations Studio
Installing SQL Operations Studio
Extending the functionality of SQL Operations Studio
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.
Get started today and activate your credits at https://azure.microsoft.com/en-us/free/students/#free-products-section
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.
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:
In order to take advantage of these additional program benefits, you will need to do this prior to 12/18/2012.
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.
- Blob Service
- Table Service
- SQL Database
- SQL Reporting
Messaging and Integration
- Service Bus Queues
- Service Bus Topics
- Queue Service
- Service Bus Relay
- Caching (AppFabric)
- Access Control
- Media Services
- SendGrid Email Service
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:
||750 small compute hours per month
||10 shared web sites
||1 GB SQL database instance
||20 GB with 1,000,000 storage transactions
||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: