Select Page
Introducing Scalar UDF Inlining

Introducing Scalar UDF Inlining

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement ... continue reading

What is built-in intelligence in Azure SQL Database?

Azure SQL Database is a fully managed latest stable version of SQL Server Database Engine hosted in Azure cloud that has several built-in features that protect and manage your data. These features may autonomously perform various maintenance tasks instead of ... continue reading
Is Group Policy Slowing Me Down?

Is Group Policy Slowing Me Down?

Hello all, Nathan Penn back again to cover one of the more frequently brought up topics: System bootup and user logon performance – Specifically “Is group policy slowing me down in my environment?” Luckily, if we know where to look ... continue reading

Infrastructure + Security: Noteworthy News (April, 2018)

Hi there! Stanislav Belov is here with the next issue of the Infrastructure + Security: Noteworthy News series! As a reminder, the Noteworthy News series covers various areas, to include interesting news, announcements, links, tips and tricks from Windows, Azure, ... continue reading

JSON vs CLR UDT – performance comparison

Ability to create custom user defined types in CLR and use them in SQL Server is introduced in SQL Server 2005. In SQL Server 2016 is added JSON support that might be alternative for storing complex objects. Since JSON is ... continue reading

JSON parsing is faster than Spatial equivalent

One of the most common assumption when people talk about JSON in SQL Server is that it is slow because it is placed in “plain text” and there is no native type. Instead of the assumption it is better to ... continue reading

JSON parsing 10x faster than XML parsing

Usually, when people talk about the performance of JSON in SQL Server, they are starting with “JSON is not actually a native type, it is just a plain text” and imply that it is probably too slow. It is true ... continue reading
New Processors from Intel Help Boost Server Performance on Windows Server 2016

New Processors from Intel Help Boost Server Performance on Windows Server 2016

Microsoft and Intel discuss the latest Purley product launch from Intel. This major Xeon processor update is bringing large performance gains, greater than 50% memory bandwidth and increased core counts. Watch this video to get the details on why you ... continue reading

Infrastructure + Security: Noteworthy News (August, 2017)

Hi there! Stanislav Belov here to introduce you to the new Infrastructure + Security: Noteworthy News series! Starting with this issue we are going to publish some interesting news, announcements, links, tips and tricks from Windows, Azure, and Security worlds ... continue reading
Loading...