| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| Backup to AWS S3 - We backup over the weekend our full backups to a backup server with a large EBS volume. Once this is complete we have a second step to invoke a powershell script remotely on the backup server that uses Rclone to sync the backups to S3. Perhaps this is a daft idea - and I'd be […] |
| Multi subnet failover cluster - My goal is to have an FCI across 2 nodes with shared storage (node 1 & node 2) in primary data center on subnet1 and then 2 nodes with shared storage(node 3 & node4) in secondary data center as subnet2. Node1 & Node2 are connected to subnet1 and Node 3 & Node 4 are connected […] |
| SQL Server 2017 - Development |
| Compare columns between 2 tables - Create TABLE #TableA ( TaskNameA nvarchar(100), GovernA bit, ToolTypeA nvarchar(10), ResourceNameA nvarchar(100) ) Create TABLE #TableB ( TaskNameB nvarchar(100), GovernB bit, ToolTypeB nvarchar(10), ResourceNameB nvarchar(100) ) INSERT INTO #TableA (TaskNameA,GovernA,ToolTypeA,ResourceNameA ) SELECT 'Gap Follow Up', 1 , 'Tool' ,'Regional/Local' UNION ALL SELECT 'Gap Extension', 1 , 'Excel' ,'Advanced Scoping' UNION ALL -- good SELECT 'Gap […] |
| SQL Server 2016 - Administration |
| Port 1433 does not have SSL certificate even after the necessary settings - Hi I have a clustered MS SQL server setup (2016, Enterprise, on AWS instance) with two nodes. I had configured SSL encryption on the two nodes using the guides provided by Microsoft as well as SQL tips. https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15 https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/ Everything works absolutely fine. I've checked the SQL Server logs which shows the SSL certificate was […] |
| SQL Server 2016 - Development and T-SQL |
| Error in bcp query out - I've been playing around wiht bcp out the data into csv file but been getting this error. I've a setup a table where I read the table name, servername, database name, filepath and build a dynamic query through stored procedure. But I've been getting below error and can't seem to figure out. If anybody has […] |
| Administration - SQL Server 2014 |
| Database Architecture - Hi Experts, Our architecture team come up with a new plan to have multiple databases for different microservices , that means for each project we will have a minimum of 3 databases only for the application, one for user management and another one for documents. As per them this is to make sure exclusive access […] |
| SQL Server 2019 - Administration |
| Opaque Encryption - with No Views, or Special SQL - Hi, I want to encrypt certain columns in various tables in a SQL Server 2019 database. I would like to do this, for five groups of users - or five roles. Some of these users actually use SSMS and run queries themselves, while others access data through interactive reports, and some link to the database […] |
| Assigning user to Azure Active Directory enterprise application via python SDK - I have added slack to Azure Active Directory Enterprise application and running SSO. I want to assign users and groups to the app in azure. So, basically, it is really easy to use portal. Also , I provided the PowerShell script as well. #AzureAD Module #Azure login : Connect-AzureAD $app_name ="slack" $app_role_name = "user" $user […] |
| Powershell script giving the error "The specified value 'Patch' is invalid." - I am trying to patch my SQL server with CU8 and GDR for SQL Server 2019 on a windows 2019 server There is only the default instance and when I run the following command in powershell as administrator I get the error below and the summary files are attached: setup.exe /updatesource="E:\SQL_2019\patches" /Action=Patch /allinstances /IAcceptSQLServerLicenseTerms The funny […] |
| SQL Server 2019 - Development |
| Sequentially Adding Variable Number of Rows - I need to add a number rows together and I'm not sure how to do it. I have the following dataset. I want to add the previous rows together to get the following. Can this be done? |
| Sql Joins ! - Hi There Im pretty new to SQL ..and best describe my queries at this stage as basic. I wonder if I could get some thoughts on an sql query that for some reason, the results are missing out some records from one of my join tables. I've added some left joins pulling in fields from […] |
| SQL Server 2008 - General |
| SQL Server Database availability - I'm looking for help in establishing an ODBC connection in Excel to an SQL Server database. I don't know too much about these connections and don't have any administrator privileges to make any changes with Server Management. Here is the background: We are using a software application that connects to the server database using SQL […] |
| Reporting Services |
| Unable to manage subscription. - I am working on troubleshooting an issue with the report server. I am able to view the report from the browser, however; when I am trying to manage the subscription, I get an error. This is error from the log file 'library!ReportServer_0-2!e2c!01/25/2021-12:46:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. […] |
| access registrykey from within SSRS report - I am trying to the code function to determine if a particular application is installed on the client machine with the intent that it would either result in one of two actions to occur. in reading materials online, it appears that Microsoft.Win32.Registry or Microsoft.Win32 should have the access to the RegistryKey object so that I […] |
| Integration Services |
| ispac file association broken - I updated my visual studio 2019 professional recently, and when I try to double click an ispac file now to deploy, then it lost the file association. I tried to manually add the file association back as the isdeploymentwizard.exe again, but now when I open it, I get a window which suggests that it needs […] |
