Sites Microsoft


Building REST API with Python, Flask and Azure SQL

Publié le 9 décembre 2019 sur Azure SQL Database Blog
 

I mentioned in my previous article that having native JSON support in Azure SQL it’s a game changer as it profoundly change the way a developer can interact with a relational database, bringing the simplicity and the flexibility needed in today …

Use ‘Data Virtualization’ extension of ‘Azure data Studio’ to create external tables for Oracle

Publié le 5 décembre 2019 sur SQL Server Support Blog
 

Use T-SQL to create external tables for Oracle is cumbersome and error-prone. You may refer the article if you are interested. Today I’m going to show you how to use ‘data virtualization’ extension of ‘Azure data Studio’ t …

Easier management of PolyBase and relational data through SQL Server 2019

Publié le 5 décembre 2019 sur sql server team blog
 

The days when a database administrator (DBA) could specialize solely in a single database technology are rapidly ending. Today, we’re much more likely than ever before to be asked to bring together many types of data from diverse sources. Although spec …

What’s new with SQL Server 2019 Linux features

Publié le 4 décembre 2019 sur sql server team blog
 

With SQL Server 2017, Microsoft entered the world of multi-OS platform support for SQL Server. For many technical professionals, the ability to run SQL Server on the same open source operating system as the rest of the application stack is not just a g …

How to configure persistent memory for SQL Server on Linux

Publié le 3 décembre 2019 sur sql server team blog
 

With the release of SQL Server 2019 on Linux, Microsoft introduced persistent memory (PMEM) support on Linux. This is an exciting development, as previous versions of SQL Server on Linux didn’t support PMEM. Let’s look at how to configure the PMEM for …

An example of Polybase for Oracle

Publié le 3 décembre 2019 sur SQL Server Support Blog
 

Here is the topology of the environment SQL Server Oracle SQL Server 2019 RTM  Platform :Redhat 7.6 Oracle 11g  Platform:Windows 2016 IP:192.168.1.31 Port:1521 SQL 2019 RTM does not support versions greater than 12.1 Oracle === 1.Create a use …

How to configure the number of error logs for your SQL Server instance on Linux

Publié le 2 décembre 2019 sur SQL Server Support Blog
 

You might have noticed in the past that the default behavior in SQL Server on Linux is to keep 128 error logs in the LOG folder. This differs from the behavior on Windows where we keep only 6 old error log files when you cycle them.   Now you have …

How to fix SQL Patch Error 1648: No valid sequence could be found for the set of updates.

Publié le 1 décembre 2019 sur SQL Server Support Blog
 

DISCLAIMER : THIS CODE AND INFORMATION IS PROVIDED « AS IS » WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.   Note: It is recomm …

‘Password required’ when trying to add a database having a ‘master key’ to AG group

Publié le 24 novembre 2019 sur SQL Server Support Blog
 

When you are trying add a database having a ‘master key’ to a AG group, you will see the message in SSMS.   You can’t move to next step until you put the correct password of the ‘master key’. This is an requirement of …

Use KTPASS instead of adden to configure mssql.keytab

Publié le 22 novembre 2019 sur SQL Server Support Blog
 

There is a known issue with the krb5 library that is shipped on RHEL(7.3, 7.4, 7.5, or 7.6) and Ubuntu(16.04) where AES keys are incorrectly salted on Windows AD systems. There has been a patch in the krb5 library, but that patched version hasn’t …

Error 15404 ‘Could not obtain information about Windows NT group/user ‘%ls’, error code 0x80090304′

Publié le 22 novembre 2019 sur SQL Server Support Blog
 

Your SQL Linux has been joined to domain and you can connect to the SQL Server instance using Windows Authentication.   The connection itself is fine, but  when you run some high privilege T-SQL statements like ‘Create Login’ , ‘sp_addsrvrole …

New Data Exposed episode: Discovering, classifying, labeling & protecting SQL data

Publié le 21 novembre 2019 sur Azure SQL Database Blog
 

Learn all about the new data classification capabilities built into Azure SQL Database. Data Classification enables discovering, classifying, labeling & protecting the sensitive data in your databases. Examples of sensitive data include business, f …

How to deploy SQL Server 2019 Big Data Clusters

Publié le 19 novembre 2019 sur sql server team blog
 

SQL Server 2019 Big Data Clusters is a scale-out, data virtualization platform built on top of the Kubernetes container platform. This ensures a predictable, fast, and elastically scalable deployment, regardless of where it’s deployed. In this blog pos …

Reflections on PASS Summit 2019 from the SQL Tools Team

Publié le 18 novembre 2019 sur sql server team blog
 

Last September at Microsoft Ignite 2018, Rohan Kumar, Corporate Vice President of Azure Data, announced the general availability of Azure Data Studio. This month, a little over a year later, Azure Data Studio took PASS Summit 2019 by storm, from keynot …

Create Distributed Availability Group in Sql Server Linux(Redhat) — step by step

Publié le 14 novembre 2019 sur SQL Server Support Blog
 

This article describes how to create a SQL Server Distributed Availability Group (AG) for high availability on RHEL 7.6. Here is the topology of the DAG environment Data Center 1 Data Center 2 Cen1:192.168.1.61 (Primary replica) Cen2:192.168.1.62 Cen3: …


Pages :