We are pleased to introduce you to ledger, a new technology that uses the power of blockchain to offer a tamper-proof record of data modifications. Currently in Azure SQL, this feature is also part of the SQL Server 2022 release. Read more
Part of the SQL Server 2022 blog series. Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems. Azure AD Authentication methods The new functionality extends existing authentication modes, such as SQL authentication and Windows authentication, allowing users to connect to SQL Server 2022 using Read more
It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional. The conference, hosted by Redgate, will include the latest SQL Server and Azure data innovations, practical training, and networking to empower you to transform your career and your organization. This year’s event is coming to Read more
Migrating your on-premises infrastructure and architecture to the cloud may seem like a daunting task, especially if you don’t have Software Assurance for your on-premises licenses. While this may seem difficult and challenging, there is a pain-free way to bring your existing on-premises licenses to the cloud through Azure Dedicated Host. Not only does Azure 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
As a database administrator (DBA), I’ve always known what the role involved. Developers swing by my desk requesting a new database, a data refresh, or help with challenges they’re facing. They sometimes get frustrated with me when their database or data isn’t ready, even if it’s really the server admin who hasn’t allocated the storage 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) trainings in one convenient post. SQL Server and Windows Server 2008 end of support End of support is coming for two commonly deployed server products, Windows Server 2008 and SQL 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
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
This post is authored by Marko Hotti, Senior Product Marketing Manager, SQL Server. Today, we’re excited to introduce a free e-book, SQL Server on Linux: A guide to re-platforming and modernizing your data workloads. This is the third in a series of technical e-books helping you get the most out of your database. With SQL Server 2017, Read more
The General Data Protection Regulation (GDPR) is now in effect as of May 25th, 2018. GDPR has significant implications on the use and management of your customers’ personal data. Considerations of privacy, security, data management, and marketing practices are all top of mind. With nearly 160 new GDPR requirements, it’s clear that cloud technology can Read more
