Working with time series data in SQL Server 2022 and Azure SQL
Part of the SQL Server 2022 blog series.Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not time-based and may be updated often, time serie …
Released: SCOM Management Packs for Azure SQL Database, SQL Server, RS, AS (7.0.42.0)
Updates to Azure SQL Database, SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.42.0). You can download the MPs from the links below. Majority of the changes are based on your direct feedback. Thank you. …
Microsoft R Application Network retirement
In June 2021, we announced that Microsoft Machine Learning Server & Microsoft R Open will be retired on July 1, 2022. In continuation with the retirement process, the Microsoft R Application Network (MRAN) website and CRAN Time Machine will be reti …
Microsoft R Application Network usage & retirement
If you are using the Microsoft R Application Network website or CRAN Time Machine snapshots, then please read through the Microsoft R Application Network retirement post. The retirement post covers the timeline and steps to be taken.
Build Your Own Podcast App with .NET 7, Blazor, and .NET MAUI
The .NET Podcast app was first introduced at .NET Conf 2021 and recently updated to highlight new features in .NET 7 at the .NET Conf 2022 keynote. The podcast app is ready to use sample application that showcases .NET, ASP.NET Core, Blazor, .NET MAUI, …
What’s New in Visual Studio Extensions for SSAS and SSRS
We have just released the new Visual Studio extensions for SSAS 2022 and SSRS 2022. Microsoft Analysis Services Projects 2022(SSAS) and Microsoft Reporting Services Projects 2022(SSRS) provide project templates and design surfaces for building professi …
Hotfix: JDBC Driver 11.2.2 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.2. The update addresses a few issues on top of the 11.2.1 release. Fixed issues Fixed potential connect to the wrong SQLServer host when multi-threading …
Released: Update to Microsoft OLE DB Driver 18 for SQL Server
Microsoft OLE DB Driver 18.6.5 for SQL Server was released this week to fix a potential driver crash. Fixed: Fixed potential crash when invalid metadata is received from the server. For more details, see the release notes. The upda …
Hotfix: JDBC Driver 10.2.2 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.2. The update addresses a few issues on top of the 10.2.1 release. Fixed issues Clear prepared statement cache on idle connection resiliency reconnections …
How to use FILESTREAM, query the metadata , access filestream data (using TIFF files) in SQL Server
1. Create database with a FILESTREAM filegroup USE [master] GO –create database with Filestream CREATE DATABASE [FileStreamTest] CONTAINMENT = NONE ON PRIMARY ( NAME = N’FileStreamTest’, FILENAME = N’C:Program FilesMicrosoft …
How to use FILESTREAM, query the metadata, and access filestream data using TIFF files
The main goal of this blog post is to showcase how you can discover the FILESTREAM assets in your SQL Server by querying the metadata. Some of those metadata queries may not be obvious so sharing this to make it easier 1. Create database wi …
Polyglot Notebooks – December 2022 Release
We are pleased to announce the December 2022 improvements to Polyglot Notebooks for Visual Studio Code. Make sure to install the Polyglot Notebooks extension from the VS Code Marketplace, or install it directly from the extension gallery in Visual Stud …
Trace Flag 8904 – Disable Inline Database Log Flushes
A log cache block holds log records for the database. Many workers are allowed to add log records to the same log cache buffer (LC) in parallel. When the log cache block becomes full, or a commit request requires the block to be saved to stable m …
Intermittent ANONYMOUS LOGON of SQL Server linked server double hop
If you already know how to configure the double-hop for SQL Server linked server, you may go « known issue » section directly. Kerberos Delegation (double-hop scenario ) Here we will use Linked server scenario as an example. The 3 servers i …
Released: SQL Server 3rd Party Backend for Django v1.2
We have released version 1.2 of the SQL Server 3rd Party Backend for Django. This release contains support for the release of Django 4.1, as well as a number of issue fixes. Our plan is to support major releases of Django and SQL Server, to ensu …