Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers
Microsoft SQL Server Blog
by Bob Ward and Jeff Woolsey
3w ago
Hey everyone!   We’ve been on the road the last couple of weeks at MVP Summit, SQLBits and Fabric Con, connecting with customers talking about the value of migration and modernization. We want to dig into specifically, how Azure can deliver real business value through cost optimization and streamlined productivity for their Windows Server and SQL Server deployments when they migrate to Azure.  We’ve helped countless organizations migrate their SQL Server and Windows workloads to Azure a critical 1st step in any transformation initiative. The move can help improve cybersecur ..read more
Visit website
Provision Premium SSD v2 Storage for Microsoft SQL Server on Azure Virtual Machines in the Microsoft Azure portal
Microsoft SQL Server Blog
by David Pless
1M ago
Guidance on choosing SQL Server storage options in Azure We’re excited to announce the public preview of the Premium SSD v2 provisioning experience for SQL Server on Azure Virtual Machines (VMs) deployed in the Azure portal. Premium SSD v2 storage improves performance, reliability, and scalability of your SQL Server workloads while offering robust resource capacity, as you can create a single disk with up to 64 TiBs, 80,000 input/output per second (IOPS), and 1,200 MB/s throughput. When building Azure SQL VMs in the cloud, DBAs have several storage choices they can consider to give their appli ..read more
Visit website
Discontinuation of DBCC CLONEDATABASE for production use 
Microsoft SQL Server Blog
by Madhumita Tripathy
1M ago
DBCC CLONEDATABASE command generates a schema-only clone or copy of a database. Effective March 1, 2025, Microsoft will no longer support creating copy of a database using the DBCC CLONEDATABASE command and using it as a new database in a production environment. However, the command will persist for generating schema-only copies solely for diagnostic and troubleshooting purposes. This change impacts all editions of SQL Server 2016 and later versions.   To generate a production-ready schema-only copy of a database, it’s highly recommended to utilize tools such as Microsoft SQL Server Data ..read more
Visit website
Expand the limits of innovation with Azure data
Microsoft SQL Server Blog
by Asad Khan
1M ago
Over the past year, we have had a first-row seat to just how fast the introduction of new technologies can change businesses across nearly every industry. The adoption of generative AI goes beyond a platform shift, it is transforming how we do everything and reshaping what’s possible for our business and in our day-to-day lives. And while we cannot yet see the ways AI will continue to impact the way we work, we at Microsoft know you need a platform that can grow with you and expand the horizons of what’s possible, powered by intelligent, limitless, and trusted solutions that can touch every co ..read more
Visit website
SQL Server Integration Services (SSIS) Change Data Capture Attunity feature deprecations
Microsoft SQL Server Blog
by Debbi Lyons
3M ago
In December 2025, Microsoft will discontinue support for the Change Data Capture (CDC) components by Attunity and Change Data Capture (CDC) service for Oracle by Attunity of SQL Server Integration Services (SSIS). This blog provides details to help support customers in modernizing to new solutions well in advance of this change. The following components for which support will be discontinued: Change Data Capture (CDC) components by Attunity. This is an integrated extract, transform and load (ETL) feature in Enterprise editions of SQL Server 2016, 2017, 2019 and 2022. As an integrated feature ..read more
Visit website
How SQL developers can maximize savings
Microsoft SQL Server Blog
by Bob Ward
3M ago
Whether you build applications for SQL Server on-premises or in Azure, there are several options for you to develop or test for free, or with substantial cost savings. Some of these options you may be familiar with, but this post will help explain details and answer some questions Microsoft often gets to provide you a clear story. SQL Server Developer Edition SQL Server comes in several editions and Developer Edition has for many years been the choice of many developers to build applications and test SQL Server with no license costs and the full functionality of SQL Server. As the documentatio ..read more
Visit website
Power what’s next with limitless relational databases from Azure
Microsoft SQL Server Blog
by Shireesh Thota
3M ago
At Microsoft, we’re seeing firsthand how data is powering incredible innovation and accelerating more than just a platform shift, it is changing the way we do everything. AI and generative AI are not futuristic abstract concepts, they are being deployed by millions every day, transforming every industry. Tapping into the full potential of that opportunity requires the right platform, powered by the right combination of powerful applications and limitless databases.   We are excited to get back in front of customers at Microsoft Ignite 2023 and PASS Data Community Summit to annou ..read more
Visit website
Protect SQL Server 2014 workloads with Azure flexibility
Microsoft SQL Server Blog
by Debbi Lyons
3M ago
SQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022, released November 2022, delivers performance enhancements as well as Azure connectivity for disaster recovery, analytics, and governance. Now customers like Mediterranean Shipping Company (MSC) are using SQL Server 2022 to expand their capabilities to better support a truly worldwide operation. “Features like Query Store hints and the next generation of Intelligent Query Processing are awesome. The possibility of improving and maintaining great performance over time without code change ..read more
Visit website
Secure your AI using SQL Server Machine Learning with Microsoft Azure OpenAI Services
Microsoft SQL Server Blog
by Buck Woody
3M ago
Microsoft SQL Server Machine Learning Services is a feature that allows you to run Python, R, Java, and other Machine Learning languages in-database, using open-source packages and frameworks for predictive analytics and machine learning. Microsoft Azure OpenAI Service is an AI cognitive service that uses advanced systems for natural language, code, and image generation and understanding. In this blog post, you will see how you can use SQL Server Machine Learning Services with Microsoft Azure OpenAI Service in a practical example. Using SQL Server Machine Learning Services with Azure Open ..read more
Visit website
Capitalize on your investments with the new centrally managed Azure Hybrid Benefit for SQL Server
Microsoft SQL Server Blog
by Frederico Pravatta Rezende
3M ago
Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the release of centrally managed Azure Hybrid Benefit for SQL Server, a new Azure portal feature that helps you improve SQL Server license management at multiple levels, including at account(s) and subscription levels, so you can ensure you are making the most out of your investments with the Microsoft SQL Server platform. Having full visibility into your SQL Server estate can help optimize your costs, as it enables the ability to track your SQL Server with Software Assurance lice ..read more
Visit website

Follow Microsoft SQL Server Blog on FeedSpot

Continue with Google
Continue with Apple
OR