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
625

SQL Server Client Aliases Through GPO/ADM

JamesFerebee on 02-12-2020 08:39 PM
How to push SQL Server Client Aliases through GPO/ADM
606

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,294

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,543

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...
822

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...
1,125

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...
691

An example of Polybase for Oracle

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

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,754

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.
5,587

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,972

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,788

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,191

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 -...
3,119

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...
8,983

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,189

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 ...
5,266

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,284

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,739

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 ...
26.7K

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,340

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...
7,682

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.
Latest Comments
Liwei
in An example of Polybase for Oracle on 02-23-2020
Hi Hraunfjord , We have been working on the issue, however, the new driver has not been released yet.
0 Likes
Hraunfjord
in An example of Polybase for Oracle on 02-21-2020
Hi,After learning about this great new feature Polybase I started to implement it against a Oracle 12c external server.I have still not had success in getting this to work, even after upgrading my SQL2019 to cu2 (build 15.0.4013.40)I have both used TSQL and "Azure Data Studio" and the error I get is...
0 Likes
RobGinNC
in Tips & Tricks on ‘cloning’ Azure SQL virtual machines from captured images on 02-13-2020
It's 2020 and I just found the answer to the 2 problems I have been wrestling with all day. This article should be linked from the VM Creation page.
0 Likes
佳易 楊
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