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: 
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 Support
Copied!
Home
Options
557

Creating a database in Azure Blob Storage from SQL Server running on Linux OS may fail with Msg 1802

JAYNAR on 01-10-2020 03:54 PM
Creating a database in Azure Blob Storage from SQL Server running on Linux OS may fail with Msg 1802
1,199

Availability Groups in Big Data Clusters. Two or more replicas in the same node?

FernandoSibaja on 01-06-2020 03:17 PM
Recently we have observed a couple of occurrences where 2 or more AG replicas in a Big Data Cluster deployment are being...
1,439

Polybase for beginners.

FernandoSibaja on 12-19-2019 05:07 PM
In regards to Polybase, I have seen some confusion from customers about what it is, the problems that it solves and when...
790

Applying SQL Server 2017 CU18 on secondary replica running on Linux OS may fail with script failure

JAYNAR on 12-19-2019 04:31 PM
If SQL Server 2017 is running on Linux operating system and if you have databases configured using Always ON feature, po...
881

SQL 2019 PolyBase Error: TCP Provider: An existing connection was forcibly closed by the remote host

Balmukund Lakhani on 12-10-2019 07:34 PM
In this blog we are sharing details about an issue which can be seen while querying external table created in SQL 2019 w...
598

An example of Polybase for Oracle

Liwei on 12-03-2019 09:40 AM
543

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

Suresh Kandoth on 12-02-2019 02:23 PM
Are you used to too many error logs for SQL Server on Linux? Now we have a mechanism to control this with ease!
1,533

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

Balmukund Lakhani on 12-01-2019 10:33 PM
In this blog, we would share the steps to resolve error 1648: No valid sequence could be found for the set of updates.
3,846

SQL Server 2019 Installation Error - An error occurred for a dependency of the feature

Balmukund Lakhani on 11-11-2019 01:52 AM
In this blog we would discuss one of the known issue with SQL Server 2019 Setup along with SQL Server Management Studio ...
1,873

When is Spinlock a Significant Driver of CPU utilization in SQL Server?

Joseph Pilov on 05-03-2019 03:02 PM
SQL Server Spinlocks - "How many spins is too many?" The answer: approximately 18,000 - 20,000 or more
1,677

The case of the filter predicate with window functions such as ROW_NUMBER and RANK

Troy Moen on 04-25-2019 02:28 PM
I recently helped troubleshoot a query performance issue that involved the window function "ROW_NUMBER". The running the...
1,160

SSIS - Package Installation Wizard - Next button grayed out

Krishnakumar Rukmangathan on 04-09-2019 12:48 AM
In SSIS - Package Installation wizard, the Next button doesn't come up or it is grayed out.Package Installation Wizard -...
2,835

SSIS – Always on AG (Availability Group) and Error – Please Create a Master Key

Krishnakumar Rukmangathan on 04-09-2019 12:12 AM
Error: Please create a master key in the database or open the master key in the session before performing this operation...
7,839

JDBC Connections fails with "The driver could not establish a secure connection to SQL Server...."

Krishnakumar Rukmangathan on 04-08-2019 11:52 PM
SQL Server JDBC Connectivity Error on JDK 1.7.0: The driver could not establish a secure connection to SQL Server by usi...
6,065

SQL-SQL linked server connections fails after applying latest windows security patches .

Srini Gajjela on 04-03-2019 10:23 AM
SQL-SQL linked server connections and distributed query execution fails due to an error message NT AUTHORITY\ANONOYMOUS ...
4,970

Connectivity Problems Caused by Issues in SQL Server

Joseph Pilov on 02-10-2019 05:25 PM
First published on MSDN on Jan 27, 2019 Very frequently connectivity problems to SQL Server are issues originating from ...
1,255

Generating a SQL Server, SSAS, SSIS, SSRS, SQL Agent Memory Dump via PowerShell script (and SQLDumper.exe)

Joseph Pilov on 02-10-2019 05:25 PM
First published on MSDN on Jun 30, 2018 Recently, we published a PowerShell script to create memory dumps of SQL Server,...
1,644

An internal error happened while generating a new DBTS for database 'Db1'

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Jun 21, 2018 Recently I worked on an issue that encountered this error and I had to research ...
22.8K

How to install Sql Server Data Tools (SSDT) 2017 Offline (Internal Network installation)

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Jun 21, 2018 Here is a request that came up recently:"When installing SSDT manually it downlo...
1,281

Deadlock Simulator app for Developers: How to Handle a SQL Deadlock issue in Your App

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Apr 27, 2018 Recent, I was involved in assisting a deadlock issue and specifically the except...
6,967

Functions like STRING_AGG(), CONCAT_WS(), TRIM() Appear to Break in Visual Studio 2017 Database Projects

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Mar 05, 2018 The following functions were introduced in SQL Server 2017.
773

Automatically Generating SQL Server Memory Dumps at a Defined Interval

Joseph Pilov on 02-10-2019 05:23 PM
First published on MSDN on Mar 05, 2018 Over the years of troubleshooting SQL Server we have come to see the need for ma...
1,333

OS Hang or Out of Memory due to SQL Ser... No Wait, it's SQL Analysis Services (SSAS)

Joseph Pilov on 02-10-2019 05:23 PM
First published on MSDN on Jan 12, 2018 Recently, we have observed a number of cases where DBAs or application developer...
Latest Comments
佳易 楊
in Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step on 01-24-2020
hi,This is my memo..Share to here!--Azure構築前の注意点 /**************************************** AGのリスナーを構築するため、BackendのVMは必ず最初から可能性セットとして構成しないといけない。 仮想マシンのパブリックIPのSKUはStandardをおすすめ LBのSKUもStandardをおすすめ 二つ仮想ネットワークをペアリングを行う *****************************************/ --DAG構成 /*******************************...
0 Likes
Halil Mollaoğlu
in SQL Server 2019 Installation Error - An error occurred for a dependency of the feature on 01-14-2020
Thanks. This indeed should converted to a KB article.
0 Likes
佳易 楊
in Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step on 01-07-2020
Hi Liwei,I configured it with 8 SQL Server 2019 CU1s. Pacemaker recommends a minimum of three SQL Server configurations.The high availability group is divided into two groups of four units.
0 Likes
James van den Berg
in Availability Groups in Big Data Clusters. Two or more replicas in the same node? on 01-06-2020
Thank you Fernando for Sharing this Blogpost with the Community 
0 Likes
Liwei
in Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step on 01-04-2020
You are welcome:)
0 Likes