|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
CosmosDB Organization | |
What is the organizational structure for Azure Cosmos DB? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Mirroring Endpoint Authentication I am creating an endpoint for my Availability Group and want to specify Windows authentication. What options do I have for the protocol? Answer: NTLM, Kerberos, and negotiate. Explanation: You can choose NTLM or Kerberos specifically, or you can use negotiate, which allows the Windows negotiation protocol to choose either one of those. Ref: CREATE ENDPOINT - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-endpoint-transact-sql?view=sql-server-ver15 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
Add import date during Bulk Insert - The kind users of this forum have helped me develop a stored procedure that imports CSV files in a folder using Bulk Insert. The files have some extra lines at the end so we had to create a process to count the lines and then set that as the LASTROW. Howver, in working with it […] |
column store index 0% page fullness after rebuild. - Doesn't seem right to me however i'm not as familiar w/ column store indexes |
Bulk Insert giving no error but 0 rows affected - Hey there, new to SQL Server and the forum. I am trying to bulk import a CSV file with this line BULK INSERT [dbo].[TestTracingImportSP] FROM 'D:\TestTracingImport\CleanTest.csv' WITH (FIRSTROW=2, LASTROW=1000, FIELDTERMINATOR=',', ROWTERMINATOR='\r'); It does not give any errors but it also does not import anything. Is there any way I can figure out why this is […] |
SQL Server 2016 - Administration |
Reliable tool to migrate from Sybase to SQL Server - Wanted to check if any one has used a good reliable tool to migrate data from Sybase to SQL Server 2016. I do know MSFT has SSMA which I will give it try, we are also thinking about using scripting if needed. Was wondering is there a better tool that others have used for this […] |
Development - SQL Server 2014 |
The union in ancher members in cte is done before the execution of recursive mem - hi, 1) in following query i have changed the second ancher member which was getting father to mother , thus i have created duplicate record, so i want to know that union of ancher memeber is done first and then recursive member is executed or after? 2) similarly if i have only one acher memeber […] |
SQL 2012 - General |
MS SQL Server 2012 question regarding SSIS - OK so I have a customer with a hosted website with eCommerce options. Essentially if you a good CC and the shipping address matches the address on the card, they will take your order. This order information is stored in a MySQL database that they log into via a website, where they proceed to physically […] |
How to write query get long process job or query or stored procedure running on - I work on sql server 2014 How to write query get long process job or query or stored procedure running on server ? as example suppose i run exec sp_joblong how to know this procedure running now and which place it stop and take long time and how to know it finish execution on server |
SQL Server 2019 - Administration |
Connect to Remote SQL Server using powershell or cmd - Hi I want to connect to Remote Sql server using powershell with username and prompt for password and when connected i need to to run a query to retrieve data from the sql server and display as output when we run the powershell script. i have the query ready but unable to connect to remote […] |
SQL Server 2019 - Development |
Need help with SQL Query - Percentages - Hi: Need help with a SQL Query: I have Summary data with ID, Name and then Details data. I would like to display % of total UID exists in @tblUIDDetails tables (In the above example only 3 UID exists) % of individual UID loaded in @tblUIDDetails table (Load Flag OK). % of individual UID loaded […] |
Bulk insert not working from different locations - I'm having an issue where the user wants to bulk insert an image as a blob in a column. The following SQL is used. INSERT INTO [Schema].[Table] (DateTimeCreated ,ReferenceId ,PrintModeId ,Image ) Values (getdate() ,11469 ,2 ,(SELECT compress(BulkColumn) BulkColumn FROM OPENROWSET(Bulk '\\AMA1\Labels_printed$\06772013_1Bit.BMP', SINGLE_BLOB) AS BLOB)) GO The statement is executed with a domain user, which […] |
Power Query SSIS - post deleted. i figured it out. |
General Cloud Computing Questions |
Cloud computing - Lately I've been interested in cloud computing but still don't know how to start. Currently I'm studying computer engineering. Well my question is how to start in this field? What should I know to be professional cloud engineer or at least to be able to have a job as cloud engineer? Any advice or recommendations […] |
SSRS 2016 |
Using views as data sources for reporting - I have several views that are used for SSRS reports locally and Tableau Reports remotely. The other day after a large update I went to check the reports on Tableau and the updates were not there. I was wondering just as a general question when do views refresh. Is it each time they are accessed […] |
Integration Services |
Copy or Export Packages from SSISDB to Files - Greetings. I'm trying to export or copy existing integration packages from an SSIS Catalog. One of them is being used by a SQL job. I'm eventually going to add them to a Visual Studio package. I ran a select statement against MSDB..sysssispackages and they don't appear there so I don't know how to find them […] |
PostgreSQL |
clone table with partial data and all structure - I'm trying to clone a table in sql with partial data but with all structure (index, etc). This is the code I'm trying to execute: CREATE TABLE "new table" (LIKE "old table") INSERT INTO "new table" SELECT * FROM "old table" WHERE "date column" > ('now'::text::date - '1 year'::interval) The error message says INSERT is wrong. When […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |