I want to know all the performance metrics both for Sql server and Azure SQL . And also the custom metrics as well . Kindly help me with this
I have the following statement that works when I omit the ORDER BY Clause or if I run it as a select and omit the create table part but I need both to ensure my generated key is sequenced correctly
Msg 104381, Level 16, State 1, Line 18 The ORDER BY clause is invalid in views, CREATE TABLE AS SELECT, INSERT SELECT, SELECT INTO, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
CREATE TABLE #demo WITH (DISTRIBUTION = ROUND_ROBIN) AS SELECT ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS ID, schemas.name as [schema], tables.name as [table], columns.column_id as [ordinal], columns.name as [column], types.name as [type] FROM SYS.COLUMNS inner join sys.types on types.system_type_id = columns.system_type_id inner join sys.tables on tables.object_id = columns.object_id inner join sys.schemas on schemas.schema_id = tables.schema_id order by schemas.name, tables.name, columns.column_id
I change QueryStore parameters (such as MAX_STORAGE_SIZE_MB) on any of our Azure SQL Server managed instances. But then the parameter change back to default the next day. What could be the reason(s)?
If you check the setting in any of your Azure SQL databases, you will see that the
value_in_use column value is zero for
Remote admin connections. Meaning ‘Remote admin connections’ are not allowed from remote clients. There is no way to change that at the time of writing this question.
sp_configure is not available for Azure SQL Database.
SELECT * FROM sys.configurations WHERE NAME = 'remote admin connections' ORDER BY NAME;
Does that mean
Remote admin connections are not allowed for Azure SQL Databases?
In my Azure portal I see a lot of different SQL services.
If I just want an alternative to my on-prem SQL Express server what should I pick, pros and cons (e.g. price/performance)?
Light use-case, e.g. CRM and ERP for small-businesses.
I found different methods of coping data from one db to another. But how should I limit to get the last six months data What are the possible options to get the limited data from db and copy to another db in another server and automate that process?
Apart from Azure data factory are there any other solutions?
what kind of locks are applied by Azure Synapse when loading data using COPY INTO, if we are running extract from synapse dw (say from table A) and simultaneously loading new data into a some other (say table B). Will it cause any locks, will we face slowness or any locks while extracting data from table A
Is it feasible for an individual dev to use azure for hosting a web app? Would the cost be dependent on the load of the app service receives?
If you have any experience with this or any recommendations please share.
I tried to download malware pcap on ubuntu VM in microsoft azure from the putty but it is not allowing me to do so .It gives following output: 2016-12-17-traffic-analysis-exercise.pcap.zip: Permission denied Cannot write to ‘2016-12-17-traffic-analysis-exercise.pcap.zip’
can someone please tell me how can we download malware pcap in ubuntu VM in microsoft azure?
I’m new to the Microsoft Server Suite.
I’ve downloaded SSMS and connected to Azure Analysis Services from it. I’m able to query my data using mdx without any problems.
However, I actually intend to build an ETL pipeline with the AAS cube as one of the sources. So I installed SSIS and have been trying to connect it to the AAS cube.
I first add "Analysis Services Processing Task" to the package. The result looks ok (when I click on "Test connection" the result is positive). But when I click on "Add", it doesn’t detect any cubes (there are two on the AAS server specified):
I assumed it worked anyway, but I can’t query the cube no matter how I try to do that. I added "Execute SQL task", but when I run it, it gives me an error:
The error message is:
An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server . ". Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "asazure://northeurope.asazure.windows.net/xxxx". Connection may not be configured correctly or you may not have the right permissions on this connection. Task failed: Execute SQL Task Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "C:\Users176\source\repos\Integration Services Project1\Integration Services Project1\Package.dtsx" finished: Failure. The program ‘ DtsDebugHost.exe: DTS’ has exited with code 0 (0x0).