Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
PowerShell dbatools offline installation error - Hi. Server OS - Windows 2019 Std. SQL Version 2017 Enterprise. Downloaded dbatools-master.zip file and extracted all files, copied into following $env:PSMoudulepath folder C:\Users\Administrator\Documents\WindowsPowerShell\dbatools\ Downloaded Microsoft.PackageManagement.NuGetProvider-2.8.5.208.dll. copied into C:\Users\Administrator\Documents\WindowsPowerShell\dbatools\. Downloaded dbatools.library.2023.5.5.nupkg, and renamed it dbatools.library (File type is LIBRARY File after renamed) then copied into C:\Users\Administrator\Documents\WindowsPowerShell\dbatools\. Finally dbatools module not get installed on server side […] |
SQL Server 2016 - Administration |
Backup progress minor question - Hello experts, I just noticed something sort of trivial, but curious nonetheless. I have a T-SQL backup statement using STATS = 10, but this was the output just now: 10 percent processed. 20 percent processed. 30 percent processed. 41 percent processed. 51 percent processed. 60 percent processed. 70 percent processed. 80 percent processed. 91 percent […] |
Administration - SQL Server 2014 |
Event ID 19036 & 10016 from Application and System log at the same time - The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider. Why do those 2 event IDs occur at the same time and what does it mean. What does this error mean?Where should I start to troubleshoot this and fix it. Is […] |
Troubleshooting relocated database - Hi... First time post to this forum. I've seen a strange characteristic after relocating a database from one server to another. Overview: My database SampleDB (data and log) reside on a SAN storage volume that is connected via fiber to the physical server that is running SQL Server 2014. I currently have 2 physical […] |
Changing Encryption on database from triple des to aes - We currently have a Windows 2016 server running Sql Server 2014 that uses triple des for field encryption. We are in the process of getting that changed to AES 128 or AES 256, but I am not exactly sure how this process works so I thought I would ask for some guidance or directions to […] |
SQL Server 2019 - Administration |
NVARCHAR(MAX) to VARCHAR(MAX) - Quick and simple. Converting a column from NVAR(MAX) to VAR(MAX) has drastically increased the data stored in the column. Table size in MB is drastically higher after the conversion. There are extra GBs of data after conversion. Any explanations? |
Increase the MaxTokenSize value of the server computer - The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. We get quite a few of these errors. Per microsoft... https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-17832-database-engine-error?view=sql-server-ver16 The Max token size is already set to 65535 on the server but still these errors show up.They are benign […] |
17832 error in sql server inspite of MaxTokenSize set to 65535 - 17832 error in sql server inspite of MaxTokenSize set to 65535 How can we get around this. These errors are clogging the error log. Thanks |
SQL Server 2019 - Development |
Trouble opening up SSIS package in VS 2019 - Package have connection to ORACLE database. And I have installed AttunitySSISOraAdaptersSetupX64 & MicrosoftSSISOracleConnector-SQL19-x86 on my machine to help connect to ORACLE. When I try to open the package, I get this error. Any help on this would be much appreciated. Severity Code Description Project File Line Suppression State Error Error loading 'Packagename.dtsx' : Object reference […] |
SQL Azure - Development |
Azure SQL DB (not managed Instance) - emulation of linked Servers? - Hello there Community, we are using a Azure SQL DB. Now we want to get Data from some AWS RDS SQL Servers. Normally we would implement them per linked Servers, because we need the ability to get ad hoc data in queries. But there are no linked Servers with an Azure SQL DB, only with […] |
General |
Just sharing an experience related to backups. - You've all by now seen my tag about 'Backup(Backup(Your backups)). Well, here's a real-life scenario: My friend, a PHD candidate at a local university, had materials related to his working dissertation on a 2.5" USB drive. Couple weeks ago he tried to access it and it has failed. The light blinks for a bit, then […] |
Design Ideas and Questions |
Help With Database Design - Hi, I am designing a database for keeping records of properties purchased and sold. And I am not sure how to implement the following relationship as shown in the screenshot below. I think this is somewhat related to the concept of inheritance but I am not sure how to best implement it at the database […] |
SQL Server 2022 - Administration |
Seeing below errors in SQL Server 2022 error log - XE session 'telemetry_xevents' is stopping and starting for every 1 hour . Please advise how to stop this. A valid TLS certificate is not configured to accept strict (TDS 8.0 and above) connections. The connection has been closed. An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint […] |
SQL Server 2022 - Development |
Determine if value occurred within all shifts - I have an employee table with job Start and End dates. I also have a shift table of all available shifts for the company. Employee activity is contained in the #value table. I'm trying to obtain all shifts each employee crossed based on #EmpTable.Enc_Start and #EmpTable.Enc_end....and which shift an employee had 'activity' (#value.ProcDate). I've tried […] |
Converting sequential time records into IN and OUT times - Hi, We have a Time & Attendance application that stores the time punched by each employee in a sequential format. We have the indication for that. if the employee punches in and out on the same day no problem on that. if the employee punch in at 8 PM and punch out the next day […] |