In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup compression provides the compressed backup option for all streaming SQL Server backup types—full, differential, and transaction log. Read more
Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft’s version of SQL Server for the Internet of Things. Read more
Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes. Read more
Support for SQL Server 2008 and 2008 R2 ended on July 9, 2019. That means the end of regular security updates. However, if you move those SQL Server instances to Azure or Azure Stack, Microsoft will give you three years of extended security updates at no additional cost. If you’re currently running SQL Server 2008 Read more
This post was co-authored by Jeff Shepherd, Deepak Mukunthu, and Vijay Aski. Recently, we blogged about performing automated machine learning on SQL Server 2019 big data clusters. In today’s post, we will present a complementary automated machine learning approach leveraging Azure Machine Learning service (Azure ML) invoked from SQL Server. While the previous post dealt Read more
In this post, we will explore how to use automated machine learning (AutoML) to create new machine learning models over your data in SQL Server 2019 big data clusters. SQL Server 2019 big data clusters make it possible to use the software of your choice to fit machine learning models on big data and use Read more
To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Server 2019 SQL Server 2019 brings innovative security and compliance features, industry-leading performance, mission-critical availability, and advanced analytics to all your data workloads, now Read more
Whether you’re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization’s data to work. To turn the next-to-impossible into the practical, you need a comprehensive resource at your fingertips: SQL Server 2017 Administration Inside Out, by William Assaf, Randolph West, Sven Read more
To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Server With SQL Server virtual machines, you can use full versions of SQL Server in the cloud without having to manage any on-premises hardware. Read more
To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Server Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux, and Docker containers. Prepare for Read more
SQL Server 2008 and 2008 R2 have had a tremendous run. But all good things come to an end, right? On July 9, 2019, Microsoft will end Extended Support, which means no more updates or support of any kind, potentially leaving you vulnerable to security and compliance issues. The good news is, you still have Read more
To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Database Azure SQL Database is the intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility, so you can Read more
