cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
5,500

I/O optimizations for tempdb in SQL Server and Azure SQL

bobward on Aug 08 2023 08:24 AM
Tempdb optimizes log flushes and disk writes in Microsoft SQL.
6,907

Internals of TDE Encryption scan

goramesh on Dec 10 2019 03:23 PM
Transparent Data Encryption (TDE) is a mechanism in SQL Server to secure the data and log files at rest by encrypting th...
1,263

Public Preview of Graph Edge Constraints on SQL Server 2019

Shreya Verma on Mar 23 2019 05:58 PM
First published on MSDN on Sep 28, 2018 SQL Server 2017 and Azure SQL Database introduced native graph database capabili...
8,162

Create linked server to readable secondary replica in Managed Instance Business Critical service tier

JovanPop on Mar 23 2019 05:53 PM
First published on MSDN on Aug 27, 2018 Azure SQL Database Managed Instance is a fully managed SQL Server Database Engin...
5,577

Using custom types as arrays in T-SQL

JovanPop on Mar 23 2019 05:46 PM
First published on MSDN on Jul 06, 2018 One of the missing language features in T-SQL language is array support.
23.3K

Calling Http endpoints in T-SQL using CURL extension

JovanPop on Mar 23 2019 05:35 PM
First published on MSDN on Apr 17, 2018 SQL Server Database Engine don't have built-in functions that would enable you t...
468

Monitoring performance of natively compiled stored procedures - database-scoped configuration options

SQL-Server-Team on Mar 23 2019 05:34 PM
First published on MSDN on Apr 04, 2018 We just added new database-scoped configuration options that will help with moni...
1,906

New Windows container images of SQL Server 2017 on Windows Server 1709!

pskountrianos on Mar 23 2019 05:26 PM
First published on MSDN on Feb 11, 2018 The Windows Server Core container images of SQL Server 2017 Developer & Express ...
1,291

JSON in SQL Server - Use cases

JovanPop on Mar 23 2019 05:25 PM
First published on MSDN on Jan 31, 2018 JSON support in SQL Server 2016+ and Azure SQL Database enables you to combine r...
1,888

Simplify REST API development for modern Single-page apps with SQL Server

JovanPop on Mar 23 2019 05:24 PM
First published on MSDN on Jan 29, 2018 JSON functionalities that are added in SQL Server 2016 and Azure SQL Database en...
794

Simplify data access using de-normalized models

JovanPop on Mar 23 2019 05:24 PM
First published on MSDN on Jan 24, 2018 Classic relational databases enable you to create highly normalized data models ...
1,903

Database scoped optimizing for ad hoc workloads

Joe Sack on Mar 23 2019 05:23 PM
First published on MSDN on Jan 04, 2018 SQL Server provides the “optimize for ad hoc workloads” server-scoped option tha...
4,800

Injecting JSON objects into existing JSON text with JSON_MODIFY function

JovanPop on Mar 23 2019 05:22 PM
First published on MSDN on Dec 22, 2017 JSON_MODIFY function that is available in SQL Server 2016+ enables you to modify...
928

Transitive closure clustering with CLR and JSON

JovanPop on Mar 23 2019 05:22 PM
First published on MSDN on Dec 20, 2017 Transitive closure is a graph algorithm that tries to follow paths in graph edge...
1,260

Storing JSON documents in SQL Database

JovanPop on Mar 23 2019 05:22 PM
First published on MSDN on Dec 19, 2017 SQL Server and Azure SQL Database have native JSON functions that enable you to ...
12.4K

Building SQL REST API back-end for Angular apps

JovanPop on Mar 23 2019 05:21 PM
First published on MSDN on Dec 18, 2017 JSON support in SQL Server/Azure SQL is designed to make integration between the...
10.1K

ASP.NET Session State with SQL Server In-Memory OLTP

pskountrianos on Mar 23 2019 05:14 PM
First published on MSDN on Nov 28, 2017 ASP.
853

JSON vs CLR UDT - performance comparison

JovanPop on Mar 23 2019 05:09 PM
First published on MSDN on Nov 15, 2017 Ability to create custom user defined types in CLR and use them in SQL Server is...
1,046

In-Memory OLTP Indexes - Part 2: Performance Troubleshooting Guide.

SQL-Server-Team on Mar 23 2019 05:09 PM
First published on MSDN on Nov 14, 2017 IntroductionIn the previous blog post In-Memory OLTP Indexes – Part 1: Recommend...
497

JSON parsing is faster than Spatial equivalent

JovanPop on Mar 23 2019 05:05 PM
First published on MSDN on Nov 14, 2017 One of the most common assumption when people talk about JSON in SQL Server is t...
3,566

JSON parsing 10x faster than XML parsing

JovanPop on Mar 23 2019 05:05 PM
First published on MSDN on Nov 13, 2017 Usually, when people talk about the performance of JSON in SQL Server, they are ...
1,398

In-Memory OLTP Indexes - Part 1: Recommendations.

SQL-Server-Team on Mar 23 2019 05:01 PM
First published on MSDN on Nov 02, 2017 In-Memory OLTP IndexesIn-Memory OLTP technology, available in Azure SQL Database...
476

In-Memory OLTP Updated Overview and Case Studies

SQL-Server-Team on Mar 23 2019 05:00 PM
First published on MSDN on Nov 02, 2017 We just published updated slide decks about In-Memory OLTP.
3,560

Sentiment analysis with Python in SQL Server Machine Learning Services

Nellie Gustafsson on Mar 23 2019 05:00 PM
First published on MSDN on Nov 01, 2017 One very popular machine learning scenario is text analysis.
1,982

Demo: Identify and fix plan change regression in SQL Server 2017 RC1

JovanPop on Mar 23 2019 04:40 PM
First published on MSDN on Jul 20, 2017 Plan change regression happens when SQL Database changes a plan for some T-SQL q...
568

Monitoring automatic tuning actions using XEvents

JovanPop on Mar 23 2019 04:39 PM
First published on MSDN on Jul 18, 2017 SQL Server 2017 can automatically tune your queries by identifying and fixing SQ...
4,140

What is plan regression in SQL Server?

JovanPop on Mar 23 2019 04:35 PM
First published on MSDN on Jun 09, 2017 Plan regression happens when SQL Server starts using the sub-optimal SQL plan to...
5,398

Use WITH clause in OPENJSON to improve parsing performance

JovanPop on Mar 23 2019 04:35 PM
First published on MSDN on May 29, 2017 OPENJSON function has a WITH clause where you can specify what fields should be ...
1,902

Automatic plan correction in SQL Server 2017

JovanPop on Mar 23 2019 04:33 PM
First published on MSDN on May 17, 2017 Automatic plan correction is a new automatic tuning feature in SQL Server 2017 t...
486

"You Shall Not Regress!!!" - How SQL Server 2017 prevents plan regressions?

JovanPop on Mar 23 2019 04:22 PM
First published on MSDN on Apr 25, 2017 SQL plan regression is a case when a T-SQL query that executed fine becomes much...

Latest Comments

mbourgon_optum
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 23 2024 07:24 AM
Yeah, double+ agree on the whole "without AG awareness, both are pretty useless". Sounds amazing, but practically I can't use it. Dammit.
0 Likes
skusen
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 22 2024 08:27 AM
@SivertSolem I built out a bunch of automation around this using functions from dbatools. As far as automatic like this, I don't know of anything that exists.
1 Likes
AnabilSaha
in SQL Server Licensing: High Availability and Disaster Recovery benefits on Apr 20 2024 11:36 AM
Hello Mr Banerjee. It's a really very helpful video. I have a real time scenario can you please suggest me what is your view on that ?In my current production server an architecture was decided that is going to have 2 vms for db server where 1 will be primary and 2nd will be secondary. But suddenly ...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 11:54 AM
@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 07:13 AM
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes