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

  • 1,407 Blog Articles
Options
1,824

SQL Server 2019 on Ubuntu 20.04,python2 dependency removed for SQL Server 2019 across distributions.

amvin87 on 04-07-2021 10:58 AM
SQL Server 2019 now available on Ubuntu 20.04 and no more python 2 dependency for SQL Server 2019 across distributions!
2,017

Watch and learn about SQL Assessment API and SQL Assessment Extension

EbruErsan on 02-23-2021 03:16 AM
If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the D...
4,282

Deploy SQL Server on Azure Kubernetes Service cluster via Helm Charts - on a windows client machine!

amvin87 on 01-04-2021 07:45 AM
A brief snapshot of the conversation that my colleague and I had a couple of weeks ago: Colleague: "I am new to Kubernet...
3,631

Exploring Azure SQL Managed Instance Management Pack

EbruErsan on 07-21-2020 05:52 AM
We released System Center Operations Manager Management Pack for Azure SQL Managed Instance recently. It provides compre...
12.1K

What is MaxDOP controlling?

Pedro Lopes on 07-07-2020 07:00 AM
The Max Degree of Parallelism, or MAXDOP, is one of the most known settings in the SQL Database Engine. There are guidel...
2,378

It just works - Backup compression on TDE databases

Pam Lahoud on 07-01-2020 10:00 AM
Starting with SQL Server 2019 CU5, you no longer need to specify MAXTRANSFERSIZE >64KB to enable backup compression on a...
2,966

SQL Server 2017 adds support for Red Hat Enterprise Linux 8 and Ubuntu 18.04

Tejas Shah on 04-13-2020 12:24 PM
SQL Server 2017 adds support for Red Hat Enterprise Linux 8 and Ubuntu 18.04
3,820

SQL Server 2019 images with current Linux distribution support available in Azure marketplace

Tejas Shah on 03-25-2020 08:37 AM
The SQL Server team is glad to announce that the Azure marketplace PAYG (Pay As You Go) images for SQL Server 2019 on RH...
4,907

SQL Server 2019 now available on Ubuntu 18.04, supported on SLES 12 SP5

Tejas Shah on 03-17-2020 03:11 AM
Starting with Cumulative Update 3, SQL Server 2019 is now generally available on Ubuntu 18.04, which includes a native U...
5,999

SQL Server 2019 on Red Hat Enterprise Linux 8 now Generally Available

Tejas Shah on 01-08-2020 10:07 PM
SQL Server 2019 CU1 is available on Red Hat Enterprise Linux 8 and as a UBI8 container. Read more about it here...
3,034

Updated process of configuring AD integrated authentication for SQL Server on Linux

Tejas Shah on 01-06-2020 10:30 AM
Configuring AD integrated authentication for SQL Server on Linux has been simplified and made into a single consistent p...
2,854

Released: Public Preview for Management Pack for SQL Server Reporting Services and Analysis Services

EbruErsan on 12-27-2019 01:32 AM
We are getting ready to update SQL Server Reporting Services and Analysis Services Management Packs (7.0.19.0). This rel...
7,223

Released: SQL Server Management Pack (7.0.20.0)

EbruErsan on 12-27-2019 12:54 AM
An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedb...
5,449

Introducing Replication and Change Data Capture (CDC) for SQL Server 2017 on Linux with CU18

Tejas Shah on 12-12-2019 12:10 PM
While SQL Server 2019 is all over the news, SQL Server 2017 continues to introduce new capabilities to reduce functional...
3,802

Internals of TDE Encryption scan

goramesh on 12-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...
4,529

Released: SQL Assessment API (GA)

EbruErsan on 11-06-2019 11:27 AM
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods a...
14.7K

SQL Server 2019 Standard Edition

Amit Banerjee on 11-05-2019 05:55 PM
On November 4th, we announced the General Availability of SQL Server 2019. As part of our General Availability announcem...
4,177

Released: SQL Assessment API (Public Preview 2)

EbruErsan on 09-30-2019 05:23 AM
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods a...
3,583

Released: Public Preview Azure SQL Database Managed Instance Management Pack

EbruErsan on 09-23-2019 03:51 AM
This public preview release is for System Center Management Pack for Azure SQL Database Managed Instance. Download: Micr...
11K

Non-Root SQL Server 2019 Containers

Vin Yu on 09-18-2019 10:00 AM
SQL Server 2019 containers makes it easier and simpler to work with data. In addition to the latest innovation and impro...
5,358

SQL Server CPU usage available in sys.dm_os_ring_buffers DMV starting SQL Server 2019 RC on Linux

Tejas Shah on 08-27-2019 11:43 AM
Starting SQL Server 2019 RC, sys.dm_os_ring_buffers returns correct CPU utilization for SQL Server on Linux, enabling mo...
30.4K

Behind the Scenes on OPTIMIZE_FOR_SEQUENTIAL_KEY

Pam Lahoud on 08-16-2019 10:44 AM
In SQL Server 2019 CTP 3.1 a new index option was added called OPTIMIZE_FOR_SEQUENTIAL_KEY that is intended to address a...
4,104

Introducing Distributed transaction functionality on SQL Server 2017 on Linux starting with CU16

Tejas Shah on 08-02-2019 11:23 PM
Distributed transaction functionality is available with SQL Server 2017 on Linux starting CU16. Find out more about how ...
9,897

Introducing SQL Assessment API (Public Preview)

EbruErsan on 07-30-2019 12:55 AM
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods a...
77.8K

Introducing UTF-8 support for SQL Server

Pedro Lopes on 07-02-2019 01:52 PM
SQL Server 2019 introduces support for the widely used UTF-8 character encoding. This has been a longtime requested feat...
9,860

What if the Actual Execution Plan was always available for any query?

Pedro Lopes on 04-03-2019 07:00 AM
In SQL Server 2019 CTP 2.4, there’s a new DMF sys.dm_exec_query_plan_stats that allows you to always access the last act...
8,789

Using xEvents to capture an Actual Execution Plan

Pedro Lopes on 04-01-2019 01:39 PM
If you still are working with SQL Profiler/SQL trace, welcome to the world of Extended Events (also known as xEvents or ...
1,693

Let’s talk about trace flags

Pam Lahoud on 03-23-2019 06:08 PM
First published on MSDN on Jan 14, 2019 One of the most confusing aspects of SQL Server configuration is often trace fla...

Latest Comments

chjhaijiang
in Released: Update to Microsoft OLE DB Driver 18 for SQL Server on 06-23-2021
Does MSOLEDBSQL support multiple SQL Statement run at one time? i.e. if bstrSQL = "'USE myDB; CREATE TABLE dbo.Connections([ConnectionID] nvarchar (64) NOT NULL ,[Serial] int NULL ,[RestartStr] nvarchar (255) NULL ,[ProjectName] nvarchar (16) NOT NULL ,[Created] [datetime] NOT NULL DEFAULT (getdate(...
0 Likes
sajidur07
in SQL Server 2016/2017: Availability group secondary replica redo model and performance on 06-21-2021
@strobe888 hi, We are facing same issue with 1TB ram and 56 core processors. I didn't even find Microsoft support systems email. Can you pls give me their support systems address?
0 Likes
Aaron2210
in Introducing adutil - A tool to ease configuration of AD authentication for SQL on Linux/Containers on 06-07-2021
@LouisPTC Thank you for the reply, it is very helpful! As you probably know, adcli does allow setting up SPN with --service-name and generates a keytab, for example: $sudo adcli join --domain CONTOSO.COM --service-name=cifs --computer-name smbserver --host-fqdn smbserver.CONTOSO.COM --host-keytab /e...
0 Likes
LouisPTC
in Introducing adutil - A tool to ease configuration of AD authentication for SQL on Linux/Containers on 06-07-2021
As with realmd on RHEL-derived systems, adcli doesn't solve the problem of setting up a service principal name (SPN). Without adutil, you'll need to go to a Windows system to run setspn and generate your krb.conf file which you can't do on the Linux side unless you're using RC4 encryption (which is ...
1 Likes
Scott Mickelson
in SSL Cipher Suites used with SQL Server on 06-07-2021
Please answer this question! We're still facing issues with SQL 2019 documentation showing only support for Legacy CSP providers? The documentation requires AT_KEYEXCHANGE and we want a TLS1.2 Cert. Assistance would be great!
0 Likes