|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Synapse Analytics History II | |
Before Synapse Analytics was a service in Azure, what was the last name of the on-premises data warehousing appliance from Microsoft? | |
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) |
Versions Supporting Developing User CLR Functions In which versions of SQL Server can I develop a user CLR function? Answer: In SQL Server on-premises on Windows or Linux, or in Azure SQL Managed Instance only Explanation: You can add CLR functions developer by users in the on-premises versions of Windows or Linux, though only those marked as SAFE in Linux. You can add these to Managed Instance, but not Azure SQL Database. Ref: CLR Integration - https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-integration-overview?view=sql-server-ver16 |
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 - Administration |
ssbdiagnose syntax error ? - Im running the following (realnames replaced ) ;; ssbdiagnose -level info -E configuration from service "TCP://fromServer:4023/serviceName/DataSender" -S "fromServer" -d "brokerDatabaseName" TO Service "serviceName/DataWriter" -S "toServer" -d "brokerDatabaseName" on Contract "//ContractName/Contract" And it shows (amongst other "stuff" ) "An internal exception occurred: Input string was not in a correct format." Any idea which part of the […] |
Adding a NEW Node to AG replacing Broken Node - Hello, SQL DBA here. Info: ALWAYS ON config Windows 2012 R2 Standard SQL Server 2017 ——----- Node A & B Node B went down and not recoverable . Setting up Node C. A is a physical box(as was B), C is virtual. Configured WSFC, added feature & node C to AG Role. Removed B. Both […] |
SQL Server 2017 - Development |
Connect to MySql databse - Hi, I have installed MySql connector and configured the ADO.NET Source(.NET provider/MySql data provider). It is all working fine. I need to parameterize the server details like server name, database name, userid and pwd. How can I pass variable to database name? I can't see database as the parameter in the expressions. I need to […] |
Development - SQL Server 2014 |
View works for me ...but doesn't return results for a user in SSMS but no errors - Hi I have this view to check if a job is running: SELECT job.NAME ,job.job_id ,job.originating_server ,activity.run_requested_date ,DATEDIFF(SECOND, activity.run_requested_date, GETDATE()) AS Elapsed FROM msdb.dbo.sysjobs_view job JOIN msdb.dbo.sysjobactivity activity ON job.job_id = activity.job_id JOIN msdb.dbo.syssessions sess ON sess.session_id = activity.session_id JOIN ( SELECT MAX(agent_start_date) AS max_agent_start_date FROM msdb.dbo.syssessions ) sess_max ON sess.agent_start_date = sess_max.max_agent_start_date WHERE […] |
SQL Server 2019 - Administration |
Database Mail (Database Mail Log) getting failed when configure a db mail - HI ALL, Database Mail (Database Mail Log) getting failed when configure a db mail, how to fix this to send the db mail success using server name as email smtp.office365.com and port 587 Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-07-29T11:48:14). […] |
SQL Server 2019 - Development |
Return string between parentheses - Hi. I have a column that lists group names. Varying lengths. I want to extract the text between the parentheses within the string. Example group names Domain Administrators (abc.domain.com) Group Members - I would like to return abc.domain.com Engineering Supervisors (xyz.domain.com) Members - I would like to return xyz.domain.com The grey matter is not able […] |
how to find a table who have updated and when have updated in a week duration i - how to find a table who have updated and when have updated in a week duration in sqlserver need a user and login details who have done changes in a table and want to see data for last n days |
Compare query results between two databases - Hi. I would like to compare results of a query to highlight differences in the data between a production database and a database restored from backup. My queries are as follows. Any help much appreciated. Kind regards, Phil. Use ProductionDatabase Select usergroup.Name, AppUser.UserName from AppUser INNER JOIN AppUser_UserGroup ON AppUser.UserId = AppUser_UserGroup.UserId INNER JOIN UserGroup […] |
When exporting data from SQL Server to Excel file getting error message. - I am working with a SSIS package that loads .CSV files from a network drive to the database, processes the data, then it is supposed to export the data from 5 tables to 5 tabs in the same excel workbook on a network drive. I am constantly getting the following error message, DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. I am […] |
Azure Data Factory |
Handling Output Parameter for Identity Field in Stored Procedure with ADF - Hi everyone, I'm currently working on a data migration task using Azure Data Factory (ADF) and encountering an issue with handling an output parameter that is also an identity field in a SQL Server stored procedure. Objective: Migrate data from a JSON file stored in Azure Blob Storage to a SQL Server table using a […] |
Reporting Services 2008 Development |
Why doesn't the error show up in the SQL Log? - We've got a third party app that runs on SQL Server 2008 R2. There's a SQL Job which runs two SSIS packages. (I am not a DBA, and I don't know how to develop SSIS.) Anyway, this SQL Job has been failing for a few days, but there's no error in the job's history. From […] |
SSDT |
SSIS File system Task - Hi all We've got an SSIS package that downloads a zipped database, unzips the contents, and then copies the contents to new locations. When doing the copy (using a file system task), we occasionally get an error that simply says "An unexpected network error occurred". I've checked there's enough room on the receiving […] |
Integration Services |
Migrating SSIS 2016 to SSIS 2022 (Oracle Attunity to Oracle Connector v1.2) LDAP - We're upgrading from SQL Server 2016 to SQL Server 2022. Our current SSIS packages utilize Oracle Attunity drivers to extract data from an external Oracle database using the LDAP protocol. We have to use Microsoft Oracle Connector v1.2 connection manager with SSIS 2022, which works well with tnsnames.ora when using the TNS_Admin environment variable. However, […] |
SQL Server 2022 - Administration |
sqlserver services not stopping even after disconnecting from SSMS - SQL server is installed in Win Server and accessed via SSMS from local. I noticed that even after I closed SSMS, the sqlserver's services didn't stop. I recently ran IndexOptimize against 1 DB and saw the memory being used upto 95%. But the process is done and SSMS is too closed from local. Its been […] |
SQL Server 2022 - Development |
Dark mode, other color schemes - All, if you are like me and do not care for the built-in color schemes, try www.sqlshades.com. I just downloaded the EXE and instead of me taking an hour or two to find the right colors and without able to change the docked windows colors, I installed it, restarted SSMS and already love the dark […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |