Microsoft Azure is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through Microsoft-managed data centers. It provides a range of cloud services, including those for compute, analytics, storage, and networking, allowing users to pick and choose from these services to develop and scale new applications, or run existing applications, in the public cloud.
Capabilities |
|
---|---|
Segment |
|
Ease of use |
|
Deployment | Cloud / SaaS / Web-Based |
Support | Chat, Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support |
Training | Documentation, In Person, Live Online, Videos, Webinars |
Languages | English |
Exclusive savings on Microsoft Azure through Findstack Deals
helpfull to access dbass best way to use azure and aws can be remotly acceable
need more friendly to access dbass as long as
keep quite as long as
The Azure Container Service has great abilities of the Cloud, which allows automatic scaling of traffic and resource usage. Azure has great integration compatibility which also allows users to use services like Azure Functions, Azure Spring Apps etc.. Likewise, we get several other features related to traffic management, logging monitoring and managing your container registry.
The Azure Container service is a great tool to work on and has made an easy job when it comes to working with containers, but the only limitation which I feel is of auto-healing of containers that fails. I've been handling restarts using the deployment process.
A lot of pain points have been covered by the Azure Containers which eases the job of any engineer working on Azure services. It's very easy to manage the infrastructure with fast deployments. The scalability feature enables the high reliability of resource where the user only have to pay under pay-per-use criteria.
Its very good database, it can be auto scalable and it can handle redudency very easily. its support high failover rate which is very great. I would really recommand this Azure SQL Cloud database for any user who want to have scalibility.
I like most of the things with Azure SQL Database, only things i do not like is pricing, its bit more expensive that other competiator prvoider like AWS. I would recommand Azure team to look into the pricing model.
Its solving my application hosting issue, i do not need to maintain my database servery anymore, with this SQL database it can be easily auto scalable with high redudency. My application get connect to Database seamlessly without any issue. I would really recommand it to the users.
Azure SQL is based on the SQL Server framework, so all my SQL works well in the Azure SQL environment (even though I develop on a local SQL Server). Frankly SQL Server Management Studio (and the ecosystem around it) is what makes Azure SQL so special for me.
As of spring of 2023, you can't bulk-buy (via reservations) Azure SQL capacity on Azure. If we had this option, it'd close the gap via cheaper options. I still chose Azure SQL over Postgres though.
Azure SQL performs the job of a relational database, but with decades of features that make it stand out from the competition (for example recompiling nested views automatically).
Azure SQL Database offers an exceptional blend of performance, scalability, and ease of management. Its seamless integration with the Azure ecosystem allows effortless resource scaling, ensuring optimal performance even during peak loads. The intelligent query optimization and built-in AI-driven features enhance efficiency, while automated backups and high availability features provide robust data protection. The platform's managed services alleviate the complexities of database administration, letting users focus on innovation rather than maintenance. Whether for small-scale projects or enterprise-level applications, Azure SQL Database's versatility and cloud-native advantages make it a top choice, enabling hassle-free database management and growth.
While Azure SQL Database offers numerous benefits, there are a few areas that some users might find challenging. One potential drawback is the cost, as the pricing structure can become complex, especially when considering additional features and resources. Additionally, advanced customization options might be limited compared to an on-premises database solution, potentially causing restrictions for businesses with highly specific needs. Users who are accustomed to certain traditional database management tools may need some time to adapt to Azure's unique interface. Despite these limitations, Microsoft continually improves Azure SQL Database, and the trade-offs are often outweighed by the convenience, scalability, and managed services it provides.
Azure SQL Database addresses several critical challenges in modern database management. Firstly, it offers seamless scalability, effortlessly accommodating varying workloads without compromising performance. This dynamic scalability eliminates the need for manual hardware provisioning and fine-tuning, saving time and resources. Additionally, Azure SQL Database's managed services reduce the burden of administrative tasks, such as backups, patches, and maintenance, freeing up valuable IT resources for strategic initiatives.
1.Helps in building the app faster and optimized. 2.infrastructue cost is very low 3.Not to worry about mainting the server as it is hosted by Microsoft. 4.Works more like SQL, so easy to learn and understand.
1.Windows authentication is not supported so there can be a security issues. 2.It doesn't support more no. of table creation and addition of new columns. 3.Database size and storage could be increased.
Faster building of logics and solving the business requirements. It helps in keeping the data more secure and in the country wherever we want. Since it is serverless the maintenance is very low It is very much cost effective, hence can be implemented in a small budget also.
If we use DBaaS then there's very minimum downtime or may be no downtime and also we are free from handling any complex data management tasks. And the security is also more if we use DBaaS.
A bigger disadvantage of DBaaS is that our data is with another organization which may use it for there own purpose. If one is using DBaaS then one must trust the other organization whose service is being used.
It's very easy to manage the data using DBaaS. As the amount of data being produced is increased tremendously managing data has become much difficult and if we use DBaaS then all work is done the data is managed so easily and I'm easily able to analyze my data.
It eliminates the following: DB administrator role, hardware maintenance such as cooling & cleaning the equipment & it also saves the cost of buying storage disks.
Some organisations prefer to keep the whole thing within their permisis/systems and have more control over it, and also cloud storages usually effects performance as they depend on internet speed.
Its benefitting in many ways such as reducing the cost of maintenance, reducing the burden on administrative roles.
Database as a service (DBaaS) is a cloud database offering that provides customers with access to a database without having to deploy and manage the underlying infrastructure. DBaaS is delivered as a managed database service, which means that the provider takes care of patching, upgrading, and backing up the database.
I dislike the way this was presented to us as a totally hands free solution, the product its self is fine, pre/post sales support has been rough. 1 Limited Flexibility- While it is highly scalable it may not offer same level of flexibility as some other database platforms .This may limit the ability to customize the platform 2 Support- The platform support may be limited for users who are not using Oracle Cloud infrastructure. 3 Cost- My Sql Database may have higher cost compared to some other open source database platforms.This may be concern for small budget conscious teams
These problems is solving with DBaaS. Data Organization and Storage. Data Accessibility and Availability. Data Security and Integrity. Data Analysis and Reporting. Scalability and Performance. Integration and Data Consistency. Compliance and Regulatory Requirements. A database is information that is set up for easy access, management and updating. Computer databases typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information.
The ease of creation on the platform. And the option to not administer any underlying infrastructure.
Sometimes due to the lack of administration by an Admin one is not able to utilise any administrative functions.
Great service for administering very basic databases with not having to do all the administrative work as required by a DBA
Azure SQL Database is a PaaS offering from MS Azure which means Microsoft handles the underlying infrastructure, updates etc., which allows us to focus on customizing the database similar to our on-prem database. Data stored at rest and in motion is highly secure.
Learning Azure and its offerings, like Azure SQL Database, is a steep curve, mainly if we are unfamiliar with cloud concepts. Azure SQL Database is not fully compatible with on-premises SQL Server installations. It is more suitable for new projects that can accommodate design changes per the Database.
Azure SQL Database is the best option when developing a new application deployed on the cloud and requires the latest stable SQL Server Features. A high SLA is available for Azure SQL Database and can scale horizontally and vertically depending on the load.
I adore all Microsoft products. When we are all working with on-premise solutions that require a lot of maintenance, Azure SQL database comes in as a cost-effective and easy-to-deploy anywhere solution that allows everyone to scale their product quickly and makes the path to market easier.
There are no downsides to using Azure because technology is rapidly evolving and we will all migrate to the cloud in the near future. But, MS should put in place a solid security system to ensure invulnerable service.
As a consultant, we receive inquiries from many clients about moving data to the cloud in order to extend their product team, and we see migration as the most difficult challenge, but Azure has made it simple. It's a little pricey, but it will probably decrease as more people use it.
The best thing about azure AQL Database that I like is its very flexible and scalable platform that offers a wide range of tools and services for developers to build and deploy applications and manage cloud services. It provides data security with backup and restore features that help with data loss. It also offers a Data Encryption feature to protect sensitive data by encrypting it so that unauthorized users can not access the data stored in the database. Pricing is very flexible; you pay for what you are using. I must recommend it to anyone looking for cloud-based database solutions.
Azure SQL Database is way good for offering cloud base solutions, but it also has some limitations: It does not support multiple database transactions in one instance, which makes it challenging to run complex queries or do anything that requires joins. I don't say it is expensive, but it's a bit pricey compared to other service providers. I don't have any bad experiences.
Azure provides many features to create, process, analyze and deploy an application or web service that uses cloud-based databases. It provides Databricks, Bot Services, Computer Vision, Recognizer and more. All of this helps in managing different features in applications and web services. The integration with different services is very smooth and secure.
It is just few clicks to run your docker image on WebApp and the most awesome feature is the blue-green deployment so it is giving flexibility to user to simply switch the stack via domain name after performing smoke test on prod.
The cost of the webApp is bit high and some time face the issue while updating the scaling policy.
It's completely managed infra so you just need pass docker image url & no infra management so it's peaceful
We can seemlessly connect cloud and on-prem databases from 1 account.
running some complex queries takes longer time.
It helps accessing database from cloud directly on SSMS via azure account and can be used to directly query from the same.
Availability of connectors Works well with MS SQL Server management studio Also is relevant with updates
Slow in terms of performance at scale Too time taking to use Postgres SQL has a better faster sla than the same query in MS SQL
Analytics and Insights A lot of views, subqueries, joins, aggregates, temp tables, Stored procs and other backend data engineering tasks go on. have live graphane dashboards
As compared to other cloud providers, the cost here is comparatively low. I like the idea of "pay as you go" model. The flexibility and on demand scalability of using services is also important factor for me to like Azure.
User support is still behind the league. I still have to wait for atleast a day, to get my query resolved. You can have multiple POC for helping your clients around.
Earlier I was using mysql database, which was a bit slow in CRUD operations and sometimes, server availability was really annoying for me. Then I shifted to Azure cosmos DB. It made my tasks much easier and reliable.
Azure Data Warehousing, Azure SQL databases, Azure DevOps for CI/CD
For beginners cost is little bit high for learning purpose.
Azure provide SQL databases that is used for storing, querying and managing the data.
On-demand self-service, serverless deployment, Scalability and easy maintenance.
Nothing as of now, some services of azure comparatively more costly than others.
Azure helps me deploy projects to Azure App Service and database services.
We can get more knowledge about the clcloud and particularly about the azure. Which can help you in future
I think there are no particular downside in learning any technology and especially azure journey has been soo good to me.
It's enhancing and taking us to the next level where everything is entirely stored in cloud platform. Rather than doing the traditional methods it's very useful