SQL Server

SQL Server

With SQL Server 2012/2008/2008R2 Reaching End of Support, What are Customers Options Now 

In this episode of Data Exposed with Anna Hoffman, Logan Carrington, and Perry Skountrianos, we discuss the end of support for SQL Server 2012 as of July 12, 2022 and what your options are as you migrate and modernize your existing workloads for your business environment.

Read More
Data SQL Server

How to Architect your Azure Data Estate with Well-Architected Framework

In this episode of Data Exposed: SQL Insider Series with Anna Hoffman and Sergey Khimchenko, learn about the value of Microsoft Well-Architected Framework for your Data Estate. Replacing traditional “architecture reviews” with a different approach – making sure that we architect Data Estate with modern capabilities for performance efficiency, reliability, security, cost efficiency and operational […]

Read More
Data SQL Server

SQL Crash Course for Beginners

When learning data science, students typically focus on Python or R for data analysis and machine learning. In the real world, data is usually stored in databases, and that data is best used by directly using SQL against the database.. This crash course is intended for beginners with no prior experience in SQL. By the […]

Read More
Azure SQL Blockchain SQL Server

Protect your data from tampering with Azure SQL Database ledger

Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is a new feature in Azure SQL and SQL Server that incorporates blockchain crypto technologies into the RDBMS to ensure the data stored in a database is […]

Read More
Azure SQL SQL Server

Azure SQL News Update | Data Exposed Live @SQLBits 2022

In this session, join the live audience of a session that is being live-streamed from SQLBits 2022. Receive the latest updates containing all things SQL Server and Azure SQL.

Read More
SQL Server

System Page Latch Concurrency Enhancements (Ep. 6) | Data Exposed

The Concurrent GAM Updates feature in SQL Server 2022 adds the concurrent GAM and SGAM updates With GAM and SGAM contention being addressed, customer workloads will be much more scalable and will provide even better throughput.

Read More
Data SQL Server

SQL Server 2022 Storage Engine Capabilities

In this episode of Data Exposed with David Pless and Anna Hoffman, take a walk through a quick overview of the storage engine improvements that improves performance and scalability such as tempdb improvements, advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power.

Read More
Azure SQL Server

How to Leverage Centrally-managed Azure Hybrid Benefit to Save Money, Manage Cost and Stay Compliant

Centrally-managed Azure Hybrid Benefit provides the billing administrators with a tool to manage the software costs of SQL Server applications on Azure for a subscription or the entire billing account. They can track their license utilization, increase or reduce the license assignments for the selected scope as needed without any risk of compliance violation. Watch […]

Read More
Azure Synapse SQL Server

How to Export your SQL Server data and Upload to Azure Storage

Learn how to use the bulk copy program utility (BCP) to export your SQL Server data and upload to Azure Storage.

Read More
SQL Server

Azure SQL VM: Optimally Configure SQL Server on Azure Virtual Machines with SQL Assessment

Wouldn’t it be great if there was a way to learn if your SQL Server on Azure Virtual Machines was configured optimally? Do you have the right options set? Do you have your tempdb on the right disk? Can your queries perform better? All these and more can be answered using the new Azure portal […]

Read More