microsoft / azuredatastudio Goto Github PK

Intellisense sometimes not working(not showing tables etc.)

Reason might be that data are not fully loaded yet. Please add possibility to check if Intellisense is fully initialized.

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)

• SQL Operations Studio Version: 0.23.6 (Windows)

Steps to Reproduce:

• Open new query tab, write a SQL statement and hit run or F5. I would expect to still be able to type in the query window, but I actively have to mouse-click or just tab to get focus in query window again

Add ability to browse the list of SQL Server Log files and their content (something like SQL Server Error Log Viewer).

• SQL Operations Studio Version:
  Version 0.23.6 (0.23.6)

Steps to Reproduce:
Open SQL Operations Studio
Enter Server name - tried both just the name and name.domain.com
Authentication type = Windows Authentication
Click Connect
Get an error listed below

My iMac is connected to windows domain. I login to the mac using domain credentials. When I try to connect using windows authentication, I get the following error:

System.Data.SqlClient.SqlException (0x80131904): Cannot access Kerberos ticket. Ensure Kerberos has been initialized with 'kinit'.
ErrorCode=InternalError, Exception=Interop+NetSecurityNative+GssApiException: GSSAPI operation failed with error - An unsupported mechanism was requested (unknown mech-code 0 for mech unknown).
at System.Net.Security.NegotiateStreamPal.GssInitSecurityContext(SafeGssContextHandle& context, SafeGssCredHandle credential, Boolean isNtlm, SafeGssNameHandle targetName, GssFlags inFlags, Byte[] buffer, Byte[]& outputBuffer, UInt32& outFlags, Int32& isNtlmUsed)
at System.Net.Security.NegotiateStreamPal.EstablishSecurityContext(SafeFreeNegoCredentials credential, SafeDeleteContext& context, String targetName, ContextFlagsPal inFlags, SecurityBuffer inputBuffer, SecurityBuffer outputBuffer, ContextFlagsPal& outFlags)
at System.Data.SqlClient.SNI.SNIProxy.GenSspiClientContext(SspiClientContextStatus sspiClientContextStatus, Byte[] receivedBuff, Byte[]& sendBuff, Byte[] serverName)
at System.Data.SqlClient.SNI.TdsParserStateObjectManaged.GenerateSspiClientContext(Byte[] receivedBuff, UInt32 receivedLength, Byte[]& sendBuff, UInt32& sendLength, Byte[] _sniSpnBuffer)
at System.Data.SqlClient.TdsParser.SNISSPIData(Byte[] receivedBuff, UInt32 receivedLength, Byte[]& sendBuff, UInt32& sendLength)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass22_0.b__0(Task1 _) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke()
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass28_0.<b__0>d.MoveNext() in C:\J\jobs\sqltoolsservice_master_win\workspace\src\Microsoft.SqlTools.ServiceLayer\Connection\ReliableConnection\ReliableSqlConnection.cs:line 298
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.d__46.MoveNext() in C:\J\jobs\sqltoolsservice_master_win\workspace\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 542
ClientConnectionId:719fbb11-e2be-46ca-b44c-fb57f4179fd6

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. View Chart Type in list.

What I'd expect to see:
"Horizontal Bar" and similar naming for types.

What I see:
"horizontalBar" and other lowerCamelCase naming.

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Create a new query in SQLOPS

SELECT @@SERVERNAME
GO 5

2. Execute and it will only run once

3. Run the same query within SSMS or SQLCMD and it will execute multiple times.

This probably isn't a production type feature but handy with demonstrations, automation, and development work to provide a multi execution of a single batch
I know that this is not strictly a TSQL language but has been in our other client tools and very useful in the field.

The text contained on the Code tab for the GitHub project contains the following text:

SQL Operations Studio is a data management tool that enables working with SQL Sever, Azure SQL DB and SQL DW from Windows, macOS and Linux.

Pretty clearly, that bold text should be Server

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Run a query.
2. In output result, select some cell.
3. Hit Ctrl-C to copy value
4. Go to query window and paste.

Does not work. In order to copy from cell you have to right-click on cell and select Copy

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.15063

Steps to Reproduce:

1. Navigate to database > Tables
2. The databases are listed without being grouped by schemas. For a large database with many schemas, the default view would be improved by a another level in the tree grouping tables/views/etc by the schema in which they reside.

Okay, firstly: For a first preview, this is already tremendously good.

One of the best features in SQL Management Studio is the ability to assign shortcut keys to query templates. So for example, if the cursor is on the table name 'Clients', pressing Ctrl+4 does a select from Clients, because that's how I have it configured.

I realize some of those shortcuts already do something different, but any ability to assign shortcuts to often-used queries will be terrific to have.

• SQL Operations Studio Version:
  Preview 1

Steps to Reproduce:

1. Select some text
2. Ponder about the shortcut key that should execute a favourite query.
3. Realize that won't work.

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.17025

Steps to Reproduce:

1.run a query
2.In the grid, you can see rows and columns are not aligned correclty

• SQL Operations Studio Version:

Version 0.23.6
Commit 8a3011756318a2ded1e6e84332230a2b2bf9c544
Date 2017-11-05T22:46:14.815Z
Shell 1.7.9
Renderer 58.0.3029.110
Node 7.9.0
Architecture x64

Below the 'Server Objects' section have a section that shows the SQL Server Agent section that includes jobs, alerts, operations, etc.

Steps to Reproduce:

When executing a query, the results are shown in grid form. Sometimes it is more useful to have it as text, using spaces or commas. This is a configurable option in SSMS, which is great.

• SQL Operations Studio Version:
  Preview 1

Steps to Reproduce:
Execute something like:

execute sp_helptext MyStoredProcHere

The results are given in the grid, but it would clearly make more sense as text.

• SQL Operations Studio Version: 0.23.6

When running queries, the "Explain" button gets the estimated execution plan, but there doesn't appear to be a way to get the actual execution plan for a query.

Before we get to the issue, I've been waiting for a tool like this for quite some time, I'm very excited! Looks very nice so far!

SQL Operations Studio version

Version 0.23.6
Commit 8a3011756318a2ded1e6e84332230a2b2bf9c544
Date 2017-11-05T22:46:14.815Z
Shell 1.7.9
Renderer 58.0.3029.110
Node 7.9.0
Architecture x64

Steps to Reproduce

• Connect to a database server
• Open a new query
• Select a database
• Open a new query (Ctrl + N)

I would very much like if the connection and selected database would still be there in the new query tab (similar to what Management Studio does)!

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.17025

The Connect dialog shows "Recent History" connections for a simple "click to connect" experience.
It would be nice just have the configured connections available whether I have recently used them or not, so please replace "Recent History" with "Configured Connections".

Steps to Reproduce:

1. Write a query e.g. SELECT 'Hello World';
2. Disconnect by clicking Disconnect
3. Click connect - it only shows recent history

• SQL Operations Studio Version:

Steps to Reproduce:
Ubuntu 17.10
bash/oh-my-zsh/terminology

follow install steps as described
type "sqlops" at prompt
receive the following, but the app comes up and seems to work fine

 ~ sqlops
Gtk-Message: Failed to load module "overlay-scrollbar"
/usr/share/themes/Ambiance/gtk-2.0/apps/mate-panel.rc:30: error: invalid string constant "murrine-scrollbar", expected valid string constant

relevant possibility: https://forum.qt.io/topic/68608/gtk-message-failed-to-load-module-overlay-scrollbar/6

https://twitter.com/kevcunnane/status/930924938298400768

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

When you are adding a new connection, is there any plan to make the 'Server Name' and 'Database Name' as drop downs instead on text boxes? It will be nice to have the 'Database Name' drop down auto populated once I mention my 'Server Name'

I do see that we are capturing 'Recent History' of the connection strings, which is beneficial.

• SQL Operations Studio Version: 0.23.6

We have lot of servers group and a lot more servers in CMS, recreating them in new OPS will be big headache.

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Run "
   SELECT 'A' AS Label
   , 10 AS Cnt
   UNION ALL
   SELECT 'B'
   , 20
   UNION ALL
   SELECT 'C'
   , 21
   "
2. Select "View as Chart"
3. Select horizontalBar or Bar from the Chart Type list.

What I'd expect to see:
The bar charts to start at 0.

What I see:
The bar charts start at the lowest value, 10 in this case. This makes it hard to read bar charts correctly since some of the meaning of the value is lost.

Perhaps an option to specify a starting value?

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.15063

When working with Always Encrypted, I found great you guys created the selection box for the encryption setting but it does not seem to be working at the moment. Has it been implemented yet?

Steps to Reproduce:

1. Create new connection (to a database with Always Encrypted)
2. Before clicking Connect, Click the Advanced button
3. Under Security, click on the "Column Encryption Setting" dropbox and select "Enabled"
4. Click "OK" and then "Connect"
5. Run a SELECT statement from a table that has encrypted fields. The encrypted fields will not be decrypted.

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Create new connection
2. Select Authentication Type

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.15063

Steps to Reproduce:

I cant see all list of databases, however there are a lot of ones.

SQL Operations Studio Version:
Version 0.23.6
Windows 10 Fall Creator

Steps to Reproduce:

Drag a selection on results grid from left-top to right-bottom and there is a minor graphic glitch that remove the bottom border of first cell.

If you drag from bottom-right to top-left the selection is different but I feel that also in this case there is some problem with the bottom border of first cell.

• SQL Operations Studio Version: 0.23.6.0

Steps to Reproduce:
Within the main build contains CodeSignSummary.md. Don't believe this should be in the program directory

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:
Right click on a Stored procedure. There is no option for executing the stored procedure.
It is present via SSMS and I used it all the time, so would be great to have that.

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Run "SELECT 1"
2. Select "View as Chart"
3. Run query again in same window.
4. Select "View as Chart"

What I'd expect to see:
I'd expect to be able to see the Chart Viewer tab again.

What I see:
The button doesn't do anything and the Chart Viewer tab doesn't appear.

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 6.1.7601

Steps to Reproduce:

1. Run this query:
   select '2017-06-22T00:00:00' [dt], 791 [count] union all select '2017-06-22T01:00:00' [dt], 451 union all select '2017-06-22T02:00:00' [dt], 528

2. Click the "View as Chart" button in the bottom Results pane, on the right side.

3. In the Chart Type drop down menu, choose "timeSeries"

4. No chart is displayed (I expected a chart to be displayed)

5. Click the Results name to the right of the Chart Viewer name to switch back to Results view (this fails, nothing is displayed).

Would be handy to have a shortcut for toggling the results of the query. In SSMS it was Ctrl-R

• SQL Operations Studio Version:
  023.6

Steps to Reproduce:
Add option to modify/alter store procedures etc.

Hello,

At my workplace we use Sql Server Visual Studio Database projects for handling our database developing.

Since SQL Ops seems to be tailored also for devs with its features it will be really nice to have the possbility to open .sqlproj files to provide db dev.

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

When I create a 'New Server Group' and add multiple connections under it, I am not seeing an option to run a query against all the connections at a single go.

Executing a SQL Query against multiple servers at the same time was one of the biggest advantage of using Registered Servers feature in SSMS. This needs to be built into the Ops Studio to leverage the real power of the 'New Server Group' feature.

Great start guys. And it's quick too.

Please add support for managed backup/restore to Azure Blob storage.

• SQL Operations Studio Version: 0.23.6 (0.23.6)

Steps to Reproduce:

1. Attempt to connect to a database.

Details (taken from my post on the other issue):
It seems that it's returned when attempting to connected to a different SQL server. The one that worked is SQL 2016 (13.0.4446.0). The one I tried to connect to today is SQL 2012 (11.0.6607.3).

Link to the issue

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce: add the widget for table-space-db-insight to the database dashboard.

The query underlying the table space widget is doubling the number of rows for some, not all, tables in my db.

SELECT Top 5
    TABL.name AS table_name,
    SUM(PART.rows) AS rows_count,
    SUM(ALOC.total_pages) AS total_pages,
    SUM(ALOC.used_pages) AS used_pages,
    SUM(ALOC.data_pages) AS data_pages,
    (SUM(ALOC.total_pages)*8/1024) AS total_space_MB,
    (SUM(ALOC.used_pages)*8/1024) AS used_space_MB,
    (SUM(ALOC.data_pages)*8/1024) AS data_space_MB
FROM sys.Tables AS TABL
    INNER JOIN sys.Indexes AS INDX
    ON TABL.object_id = INDX.object_id
    INNER JOIN sys.Partitions AS PART
    ON INDX.object_id = PART.object_id
        AND INDX.index_id = PART.index_id
    INNER JOIN sys.Allocation_Units AS ALOC
    ON PART.partition_id = ALOC.container_id
WHERE
INDX.object_id > 255
    AND INDX.index_id <= 1
GROUP BY TABL.name, 
INDX.object_id,
INDX.index_id,
INDX.name
ORDER BY 
(SUM(ALOC.total_pages)*8/1024) DESC

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Add an insight based on a custom query.
2. Open the dashboard.
3. Change the query and save.
4. Refresh the dashboard/insight.

The refresh button doesn't seem to be doing anything at the moment. I have to close and reopen the dashboard before it picks up any changes.

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Run some query that produces results.
2. Select some cell and press Ctrl-C
3. Open notepad and paste

Result: nothing is copied. Right-click on Cell and select Copy does work.

Couldn't see that this has already been raised - it'd be great to be able to install Extensions as in VSCode. For instance being able to install VIM emulation.

It times out when trying to load the list of databases.
Apparently, the query to list the databases gets really slow when it needs to bring values from sys.database_mirroring.
Ex:

SELECT
ISNULL((case dmi.mirroring_redo_queue_type when N'UNLIMITED' then 0 else dmi.mirroring_redo_queue end),0) AS [MirroringRedoQueueMaxSize],
ISNULL(dmi.mirroring_connection_timeout,0) AS [MirroringTimeout],
ISNULL(dmi.mirroring_partner_name,'') AS [MirroringPartner],
ISNULL(dmi.mirroring_partner_instance,'') AS [MirroringPartnerInstance],

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Run "SELECT 1 AS A"
2. Select "View as Chart"

What I'd expect to see:
Chart viewer tab selected and count Chart Type selected.

What I see:
Stays at Results tab but Chart Viewer tab is available. I have to manually click on the tab and choose "count".

• SQL Operations Studio Version: 0.23.6

Logging into SqlAzure databases that require multi-factor authentication doesn't appear to be implemented yet.

Can't wait to see this tool mature - it's looking great already.

• SQL Operations Studio Version: sqlops 0.23.5 (8ceb667ae168eab08f666044f8c4611d9d68cfc4, 2017-11-05T21:22:13.756Z)
• OS Version: Windows_NT x64 10.0.16299

Steps to Reproduce:

1. Run query against AWDW (2016): SELECT st.SalesTerritoryCountry, sum(frs.salesamount) as Totals from FactResellerSalesXL_CCI as frs
   join DimSalesTerritory as st
   on st.SalesTerritoryKey = frs.SalesTerritoryKey
   group by st.SalesTerritoryCountry
2. Click view as chart option
3. Switch from default view (horizontal bar) to time series
4. Visual is lost
5. Try to switch back to another/valid visual, visual does not come back. Have to re-run query to reset

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.16299

Steps to Reproduce:

1.Select any table with an identity column
2.Right click and select "Edit Data"
3. Try to enter values manually
4. The result is the error message "Commit row failed: A required cell value is missing"

SQL Operations Studio Version:

• 0.23.6 (0.23.6)

Background:
I often find myself writing scripts to perform a series of tasks against a list of entities, for example, calling a sproc n times where n = a list of ids I need to work with.

I've always preferred to perform these tasks using a simple loop instead of a cursor.

In SQL Operations Studio, I see inconsistent results of executing this looping logic - it seems the first one or two iterations function as I'd expect, but after that I don't see the results I would traditionally see if I executed the script using SSMS.

Steps to Reproduce:
I've attached a small sample script that should reproduce the behavior.

What I Would Expect to See from the attached Script

• I would expect my loop to execute 10 times, and I would expect to see 10 result sets, each outputting the text "Working With {N}" where {N} is replaced by the record ID of the processed record.

What I see Instead:

• I see the loop execute 10 times, but the result sets are inconsistent. I see 1 to 3 actual results sets where the expected text is returned. The other expected result-sets have no returned data.

In SSMS:

• The same script executes and behaves as expected.

sqlOps_LoopBug_ReproScript.txt

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.14393

Steps to Reproduce:

1. Shift Right click... run as diff. user

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Run any query that returns multiple columns.
2. select the entire column by clicking in the Header of the column
3. Holding control or shift, select any additional column
4. Copy either by using control+c or by right clicking and selecting copy/copy with headers functionality
5. Paste into excel

Expected Behavior:
All selected columns would be copied

Actual Behavior:
Only 1 single column is copied.

This is valid for VSCode too, when you specify proxy and that proxy requires NTLM/Kerberos authentication its not working at all, every time we need to create local proxy with Fiddler or CNTLM applications.

• SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
• OS Version: Windows_NT x64 10.0.15063

Steps to Reproduce:

1. Follow steps at https://docs.microsoft.com/en-gb/sql/sql-operations-studio/tutorial-build-custom-insight-sql-server
2. When adding widget insight data to user-settings throws error Incorrect type : expected "null"

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

1. Add an insight to user settings file.
2. Open Dashboard.
3. Change title for insight in user settings file.
4. Refresh Dashboard.

What I'd expect to see:
I'd expect to see the new title on the insight.

What I see instead:
I see the old title on the insight. Nothing changes.

Created from twitter feedback: https://twitter.com/borgdylan/status/930894693487071233. Request is for graphical create database and user / login management. We can track using this issue.