One of the missing language features in T-SQL language is array support. In some cases you can use custom types to work with arrays that are passed as parameters to your stored procedures. Custom types in T-SQL enable you to create alias for some table, .Net or built-in type. Once you create a custom type,... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/07/06/using-custom-types-as-arrays-in-t-sql/

Congratulations to our June top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/07/05/june-2018-leaderboard-of-database-systems-contributors-on-msdn/

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. You would need to prepare Azure environment where SQL Managed Instance will be hosted before you create your Managed Instances. In this post you will see how to deploy configured Azure environment using ARM template. One of the most difficult tasks... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/07/02/deploy-azure-sql-managed-instance-network-environment-using-arm/

Azure SQL Database Managed Instance is PaaS version of SQL Server hosted in Azure cloud. Managed Instance enables you to create a database as a copy of the existing database at some point in time using PowerShell. In this post you will see sample script that performs point in time restore of database. The easiest... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/28/point-in-time-restore-of-a-database-on-azure-sql-managed-instance-using-azurerm-sql-powershell-library/

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure cloud. In this post you can find a simple PowerShell script that you can use to quickly create a new Managed Instance. As a prerequisite, you would need to create VNET/subnet using setup quick start script and use the... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/27/quick-start-script-create-azure-sql-managed-instance-using-powershell/

Congratulations to our May top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions.   This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/25/may-2018-leaderboard-of-database-systems-contributors-on-msdn/

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure cloud and placed in your Azure network. In this post will be explained how to create environment where Managed Instances can be placed using the sample PowerShell script. Azure SQL Managed Instance is your private resources placed in your... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/25/quick-start-script-setup-azure-network-environment-for-azure-sql-managed-instance/

Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Microsoft Azure cloud. Besides built-in management operations, Azure SQL Database Managed Instance enables you to perform some custom management actions such as restoring databases across instances from some point in time in the past using Azure Command line interface. In this post... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/07/cross-instance-point-in-time-restore-in-azure-sql-database-managed-instance/

A traditional scenario of loading data into CCI is a nightly load from one or more data files containing millions of rows. Recommended technique is to load the data with batchsize >= 102400 as explained https://blogs.msdn.microsoft.com/sqlserverstorageengine/2014/07/27/clustered-column-store-index-bulk-loading-the-data/. However, we are seeing many scenarios where data source is parallel data stream (i.e. trickle insert) to be loaded... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/04/clustered-columnstore-index-massively-parallel-trickle-insert/

Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Microsoft Azure cloud that enables you to work with your databases using standard TSQL or PowerShell. In this post you will see how to create your database using PowerShell. Prerequisites In Azure SQL Managed Instance, you can use PowerShell to create a... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/06/04/create-database-on-azure-sql-managed-instance-using-powershell/

Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of the instance. You can use PowerShell to easily manage size of the instance and automate this process. As a prerequisite, you need to... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/05/31/change-size-azure-sql-managed-instance-using-powershell/

Azure SQL Managed Instance is fully managed SQL Server Database Engine hosted in Azure cloud. Azure SQL Managed Instance allows you to easily change instance settings such as changing number of cores assigned to the instance, adding more storage, etc. In this post you will see how easily you can automate these operations using ARM... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/05/23/updating-azure-sql-managed-instance-properties-using-arm-templates/

Congratulations to our April top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/05/16/april-2018-leaderboard-of-database-systems-contributors-on-msdn/

Azure API enables you to create Azure SQL Managed Instance using ARM templates. These are JSON objects that contain definition of resources that should be created. You can send these objects to the Azure REST API to automate creation of Azure SQL Managed Instance. In order to create a new Azure SQL Managed Instance, you... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/05/15/creating-azure-sql-managed-instance-using-arm-templates/

Azure SQL Database Engineering team (@azuresqldb) represented by Lindsey Allen,  Joachim Hammer, Ajay Jagannathan, Joe Sack, Shreya Verma, Kevin Farlee, Borko Novakovic, Jakub Szymaszek, Mirek Sztajno, Veljko Vasic, Dhruv Malik, Alain Dormehl will be in full force speaking at several sessions at the Microsoft Build (#MSBuild) conference (Microsoft’s ultimate annual developer event). The conference will... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/05/03/meet-the-azure-sql-database-team-at-microsoft-build-conference/

Azure SQL database is a platform as a service SQL Server Database Engine hosted in Azure cloud and managed by Azure. Azure automates many management activities and enables you to focus on development and optimizations. In addition, it enables you to easily configure some advanced management configurations. There are some critical database management activities that... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/04/26/how-azure-sql-database-makes-database-management-easier/

Azure SQL Database is a flexible Platform as a service database that can be easily scaled to fit your needs. You can add more compute or storage to satisfy your performance requirements without waiting for new hardware or migrating data to more powerful machines. Azure enables you to change performance characteristics of your database on... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/04/26/azure-sql-database-scalability/

Azure SQL Database is highly available database Platform as a Service that guarantees that your database will be up and running 99.99% of time, without worrying about maintenance and downtimes. This is a fully managed SQL Server Database Engine process hosted in Azure cloud that ensures that your SQL Server database is always upgraded/patched without... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/04/25/azure-sql-database-the-database-engine-that-cannot-die/

SQL Server Database Engine dont have built-in functions that would enable you to send information to some API using http protocol. If you would need to call some REST endpoint or a web hook from the T-SQL code, you would need to use WebClient or WebRequest classes from .Net framework and expose them as T-SQL... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/04/17/calling-http-endpoints-in-t-sql-using-curl-extension/

Congratulations to our March top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/04/09/march-2018-leaderboard-of-database-systems-contributors-on-msdn/