| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| Always on AG group - One of our DR server went down over the weekend with blue screen and cause the synchronization to fail. The DB monitoring system crashed cause no notification sent. I found the DR server issue after 2 days. I agree lot of things need to be straightened out, why windows team did not notify us and […] |
| SQL Server 2017 - Development |
| Alter authorization on view - Hi I have created a view in viewschema against table1 in tableschema I would like to change the owner of the view to to the tableschema. ALTER AUTHORIZATION ON viewschema.viewName TO tableschema When I run the above, I get Cannot find the principal tableschema, because it does not exist or you do not have permission. […] |
| SQL Server 2016 - Development and T-SQL |
| How to Find Duplciate Data stored in multiple tables - There is probably a name/term for this problem and I'm just unaware of what it is. I know how to find duplicate data in a singular table but not when the data your comparing is stored in multiple tables, 2 tables with a parent child relationship. I Restored a copy of the AdventureWorks DB but […] |
| Trouble dynamically rolling up some accounts - Hello, Hopefully someone can help we with the following issue that i have. I have provided some test data in the format of two basic tables that closely replicates the issue. Sample data: CREATE TABLE xdbExample ( [Period] INT ,[Site] VARCHAR(6) ,[Account] VARCHAR(4) ,[Value] INT ) INSERT INTO xdbExample ([Period], [Site], [Account], [Value]) VALUES ('1901','SITE01','ACC1','1') […] |
| Combine Date & Time parts for Two Dates, then subtract - Hi, I'm trying to combine a Date and a Time field into a DateTime, and then again for two more Date and Time fields, and then subtract the two combined DateTime fields within one select field of the SELECT statement... I can combine through CAST a Date field with a Time field, and I can […] |
| SSIS Config Files vs Config Tables - I have recently run into multiple solutions where they are using Configuration Tables to store Config parameters instead of Configuration Files. I'm a little leery to continue using the table approach. We don't have SSISDB, so that's not an option. What are your thoughts on using the table vs file approach? I've always used the […] |
| SQL Server 2019 - Administration |
| Connection to SSIS after upgrade - I've just upgraded from SQL server 2014 to 2019 and also installed the latest version of SSMS. My server has always been on a local machine (i.e. server name was (local) as far as I can remember, or if not it was just the name of the machine in Windows). I don't have external users, […] |
| Secure Sockets Layer (SSL) encryption. Error: \"SQL Server did not return a respo - Bonjour , J'ai un problème de connexion sur le serveur SQL Joindre le message d'erreur Le pilote n'a pas pu établir une connexion sécurisée à SQL Server à l'aide du chiffrement SSL (Secure Sockets Layer). Erreur: «SQL Server n'a pas renvoyé de réponse. La connexion a été fermée.». La connexion SSMS fonctionne correctement si ce […] |
| SQL Server 2019 - Development |
| SSIS Script Task for PowerShell - HI everyone! How do i update the script task to run on a specific server. This would change for each run. Or is there another way to run the powershell? SSIS runs the below: ssis exists on server 1 Copies powershell to server 2 Run powershell on server 2. (Assistance needed) |
| Access to SQL expression - Hi folks, I'm trying and failing miserably to convert an Access Expression to SQL query The MS Access Expression strips the following field data formats to extract the middle text between the 2 hyphens 2C00P02-CRIW-93201 (Extracted value: CRIW) Any help appreciated Left(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),InStr(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),"-")-1) |
| TSQL Script: Min, Max function - Hello All, I hope you are doing well. I have difficulties to write a sql script. May be you could help me. I have a table like this. And I want to have a result like this: I used the min and max function but it doesn't work. Do you have any idea […] |
| Reporting Services |
| SSRS and subscriptions with office365 - Hi.I have a detail with the subscriptions in Reporting Services (SQL Server 2014).I have configured DBmail using Office365. When I run the report to send it by mail it sends: Failure sending mail: Error in processing. The server response was: 5.7.3 STARTTLS is required to send mail [BN6PR03CA0006.namprd03.prod.outlook.com]Mail will not be resent. I opened the […] |
| Integration Services |
| PowerShell Process Task fails in locked down Windows 10 - Hi Guys A weird one here. I run a process task to run powershell.exe with the argument -File C:\Ace\ResetSpreadsheet.ps1 This script runs a macro in a spreadsheet in the same folder to clear existing data and then saves and exits. Because the IT people lock our boxes down to the nth degree I had issues […] |
| MySQL |
| TERADATA - Execute procedure permissions - im finding it hard to get a reply on other forums because of low activity in general, so apologies if this is in the wrong place Im a working in Teradata and i create a procedure and all is well then he following day, having logged off and back on, i dont have execute permissions […] |
| Job Postings |
| Looking for article writers - Hi there, I'm looking for a few freelance writers who would be willing to help with some quick turn around posts about PostgreSQL and MySQL. We're also looking for people who may have already written pieces they'd like re-syndicated. Both opportunities are paid. Right now, we're offering $50-150 a piece, with some bandwidth to increase […] |
