| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| HOWTO Change the system collation using setup (rebuilddatabase) and retain data? - Dears, I'm aware of the process of rebuilding system databases using the setup.exe /ACTION=REBUILDDATABASE command, but has somebody a procedure/script to move also the data in master and msdb along to the rebuild databases? Thanks, Tim |
| SSISDB and availability groups problem - I just got called in on an SSISDB / AG issue. We had a fail over event and suddenly a job that calls a package in SSISDB is not working because the package isn't decrypting properly. So we start digging into it and I found something interesting. For kicks and giggles, I opened the AG […] |
| Administration - SQL Server 2014 |
| Azure DevOps - Hi Experts, We are in the phase of automating our releases which include database change as well. Our SQL server are inside the firewall with no internet access, In this case how can agent pool connect to databases? |
| SQL Server 2012 - T-SQL |
| Put output of a dynamic query using OpenQuery into a temporary table - Hello. I am tasked with converting some regular T-SQL queries to OpenQuery. I am very new to OpenQuery so learning on the fly. I have to do the query dynamically because of some of the variables involved. I have a very simplified version of what I am doing below. I want to know if I […] |
| SQL Server 2019 - Administration |
| AD permissions updates CVE-2021-42291 and AO Clusters/GL - I have an SQLSERVER Always on Environment. In AD it's logging: The directory service detected an LDAP modify request for the folling object that normally would have been blocked for the following security reasons. The client included an nTSecurityDescriptor attribute in the add request but did not have explicit permissions to write one or more […] |
| Database snapshot, TDE, and sys.databases - Something I was looking at on a dev server where I was taking some snapshots and where we have TDE enabled and operational on the underlying database. Querying sys.databases shows the is_encrypted field as zero? Reading through the TDE documentation there is no exception that snapshots are NOT encrypted that I could find, but now […] |
| Creating multiple identical indexes - Hi I have a large table of 87 million rows that needs to have 3 identical non clustered indexes on it. Please don't ask me why, I'm aware of how ridiculous it sounds......... The first index creates in 10 minutes, the seconds one took 13 hours. I'm doing this on a development server that nobody […] |
| SQL Server 2019 - Development |
| Triggers applied to primary and secondary tables causing rollback on primary - Apologies for the title, I'll explain more clearly. I have two tables and each has a trigger applied. The first table trigger is a simple audit style (AFTER INSERT/UPDATE) trigger that takes a copy of the modified record and inserts it into a Log Table. On the Log Table, I'm using another (AFTER INSERT/UPDATE) trigger […] |
| Calculate a sum based on time periods in CASE statement - Hello everyone, I have a situation where I am trying to calculate SUM(History Quantity) based on MIN Posted Date + specific number of weeks. For example, how many quantities were sold within the start date of '2022-05-22' + 8 weeks The code that I have now, but need to understand how to make CASE statement work because […] |
| Code first development - data from local and remote database - For my project I have to read data from a remote employee database : data like LastName, Firstname, Email, SerialNumber. In the new databse (other than the remote one) I have to add some other fields like Role, Profile, Salarylevel, Active. I read remote data by a DBContextA and using a class created with CodeFirst […] |
| SSRS 2016 |
| Unable to connect SSRS - Hi, We are using SSRS 2016 version, it's running good and suddenly it's throwing exception as below when we are trying to generate reports, after restarting the SSRS again it's working good. 2023-05-18 22:07:42.9021|INFO|1|library|Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException Microsoft.ReportingServices.Modeling.InternalModelingException Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException 2023-05-18 22:07:42.9021|INFO|1|library|Do not dump on: Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessExceptionSystem.Threading.ThreadAbortException System.Web.UI.ViewStateExceptionSystem.OutOfMemoryException System.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadException Microsoft.SharePoint.SPException Microsoft.ReportingServices.WmiProvider.WMIProviderException System.AppDomainUnloadedException 2023-05-18 22:07:42.9021|INFO|1|library|Minidump location: C:\windows\TEMP\ […] |
| Integration Services |
| ODBC connection throwing error while reading data from EAP - SSIS - Hi, I am using ODBC connection manager to fetch data from EAP source in SSIS It is throwing DTS_E_INDUCEDTRANSFORMFAILUREONERROR on 1 of the columns PipelineOwnerName which is varchar(121) in EAP table. I have tried these approaches: select PipelineOwnerName from Sales where Period = '2021' --- Failed select cast(PipelineOwnerName as varchar(121)) from Sales where Period = […] |
| Design Ideas and Questions |
| Help with architecture - Hi! I'm trying to make something similar to this: https://www.digikey.com/en/products/filter/integrated-circuits-ics/memory/memory/eeprom/774?s=N4IgjCBcoJwGwWiAxlAZgQwDYGcCmANCAG4B2UALgE4CuhIA9lANogDMALGwEwAM3IALpEADhSggAytQCWpAOYgAviqA So I spent a while identifying key components and wrapping my head around it until I came up with this: https://dpaste.org/wV0UT/slim Then I wrote another script to populate these tables and to add an eeprom, so that I can figure out the sequence of queries […] |
| SQL Server 2022 - Development |
| Determining Time Worked Between Time Pairs During Certain Hours of Higher Pay - We have nurses pulling night shifts. They get bonus pay (more $$$ per hour) during the hours of 10pm and 5am. They check in and we capture their check-in time and check out time. How can I calculate the amount of time the worked during the overtime pay hours? I know SQL pretty OK - […] |
| Update in an Insert Trigger - I have a need to set current fields to default values when a new record is inserted. Is it good practice to update the same table in an after insert trigger? |
