Microsoft/mssql

Visual Studio Code extension to develop Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere

Kylee Webb

@kyleewebb7

Screen Shot 2019-12-11 at 4.14.30 PM.png

above where it says 'Server name or ADO.NET'?

Joshua Dapitan

@joshuadapitan

the name of your SQL Server instance

无限风灵

@WuLex

(︶︹︺)哼

use vs

ste

step and step

Tim Bush

@t_busht_twitter

Screenshot 2020-01-01 at 10.53.04 PM.png

Hi all, has anyone successfully got the mssql extension for VS code running on ARM hardware ? I've got this far with headmelted 's build, running as a Linux App in Chrome OS, on an Acer Chromebook Tablet :P

Tim Bush

@t_busht_twitter

Screenshot 2020-01-01 at 11.00.15 PM.png

VipinPokhriyal

@VipinPokhriyal

Hi All,
Can anyone suggest to me how to setup the MSSQL cluster using docker in ubuntu?

eAlie

@ebadali

Hi Folks,

I have this weird bug showing up out of nowhere. When I do Bulk Insert with formatted file, it skips the first column (not row). I have tried almost everything( using bcp to generate file, using the short header file, etc). It just does not seems to make any sense. Do you happened to encounter something like this ?

eAlie

@ebadali

Just found the fix : This is super weird, I had to move the identity column position to the last of my destination column

Bård Eik

@bardeik

Hi, hope someone can help me with an issue. When I have an open connection and use Ctrl + Shift + E, I run the query just fine, but If I select the text and then run the query, it pops up "Server not selected". Any idea on where I go wrong? The same message if I select a text, right-click and selects "Run selected text as query"

Bård Eik

@bardeik

@bardeik Found a workaround. Removed Crtl + Shift + E keybinding on "Run selected text as SQL query", and added this shortcut (Ctrl + Shift + E) to "MS SQL: Execute Query" -> Does not check for selected text, but it only executes selected text, so works for me :-)

VipinPokhriyal

@VipinPokhriyal

Hi All,
is there any way to push data into using a trigger approach in mssql.

Rakib Ahmed

@Rakibxl

I have a one table Called MeetingInfo. In that table there is a info regarding Meeting Start Date and End Date And Metting Room.

I want to make a query by which i want to see all the Meeting start Date and EndDate but From today to 365Days Ago. Below Way i am trying

DECLARE @TodayDATE = GETUTCDATE()

Select * from MeetingInfo

WHERE StartDate between DATEADD(DAY,-365,GETDATE()) and@Today

AND tbia.EndDate between DATEADD(DAY,-365,GETDATE()) and @Today

What do u think this is the correct way to see the results

Kay

@kaysauter

@Rakibxl first off, if you use GETUTCDate(), then this ma return some surprising results depending on where you live / where this server stands and the user is

That is because the timezone offset is not included for this. if you want to respect this (and have reason to use this), then you need to keep in mind that you will have timezones to display for each user depending on her or his location

However, interestingly, you use GetDate() in the Filtering section, so this will probably have efffects on this.

but apart from that, it seems good to me, but I haven't tested this.

alealpha2000

@alealpha2000

i have a sql question.i have a query like this. how can i change it so instead of counting one column in the group, it counts the combinations of two columns inside a group

select column1,count(distinct column2)
from table
group by column1

00sivan

@00sivan

@alealpha2000 You could use CONCAT(column1, column2) -
Example1:

select COUNT(CONCAT(column1, column2)) from table1 group by CONCAT(column1, column2)

Depending on what you're counting, as you seem to need distinct values, you may need to use window functions to deduplicate first. Google deduplication and "over(partition by" for help with that. If you go that route, you may need to wrap this in a CTE;
Example2:

;with A as (select concat(column1, column2) as 'NewName' from table1) select count(NewName) from A

amishraa

@amishraa

can anyone please help me with sql server connection strings using windows authentication?

sakenzhuma

@sakenzhuma

Good Day. Have a question, could you please give me your insight. For select on website, is it good idea to have two columns to save select I'd and its value? Thx.

Marcelo

@marcelosf

Hello everyone.
I need some help with mssql connection. When I try to connect to mssql server I get this error:

´´´

I'm trying to connect to a mssql server 2019]

Nick

@nj-db

Hi, can anyone please point me in the direction of some information to do with using a SQL FileTable in a document versioning system? Thanks

matrixbot

@matrixbot

gympuma > <@gitter_nj-db:matrix.org> Hi, can anyone please point in the direction of some information to do with using a SQL FileTable in a document versioning system? Thanks

Could you explain a little more? You want to log versioning in SQL? Generate documents from t-sql into a file system?

matrixbot

@matrixbot

gympuma > <@gitter_marcelosf:matrix.org> Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed[Message Iteration=3|SQLState=08001|Native Error=|Message=[Microsoft][SQL Server Native Client 10.0]Client unable to establish connection]'.

What connection string are you using? (blank out sensitive info before sendind)

Adedamola Adedapo

@adedamola-ad

Hi, can anyone please help with this error , I am trying to connect to an mssql server on vscode running on ubuntu, and i keep getting this error.mssql: Failed to connect: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (00000005, 6): No such device or address
at System.Net.Dns.InternalGetHostByName(String hostName)
at System.Net.Dns.GetHostAddresses(String hostNameOrAddress)
at Microsoft.Data.SqlClient.SNI.SNITCPHandle.Connect(String serverName, Int32 port, TimeSpan timeout)
at Microsoft.Data.SqlClient.SNI.SNITCPHandle..ctor(String serverName, Int32 port, Int64 timerExpire, Object callbackObject, Boolean parallel)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action

1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass40_0.<TryGetConnection>b__1(Task

1 _)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>cDisplayClass30_0.<<OpenAsync>b0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ManagedBatchParser\ReliableConnection\ReliableSqlConnection.cs:line

kmteam

@kmteam

kmteam

@kmteam

I have a database in which some tables have a lot (millions) of rows with binary data. The database is having a lot of I/O problems so we want brake it down to store the data into different disks.
Is there any option to do this without break it down into two separate databases?
Can I assign a table into different storage?
Thnks!

Mike Mahon

@jetstreamin

question? When a Entity Framework connects to sql server, what port is utilized?

Shreyas Patil

@pshreyasv100

I have a requirement of writing a pandas dataframe to SQL server via stored procedure so I'm using df

df.to_sql() but there seems to be some limitation with this approach since sql server supports only 2100 cells at a time while writing to db say for instance I have 10 rows then I will be able to write only 210 rows in one batch , and writing is happening very inefficiently, could anyone suggest a more efficient approach to writing a pandas dataframe to SQL server ?

Fr0z

@Fr0zBeats_twitter

oh hi

thank you for all the cool tech

im appreciating every moment of learning innovation

Christian Gann

@doublegsoft

hello! i wanna develop a ssms extension to prevent some accidental sql execution, could anyone provide some information about its development tutorials or introduction of ssms extension framework?