Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
Which version to upgrade sql server 2017 or 2019 - Hey Everyone, My project wants to upgrade their sql server 2014 SP3 to newest one. I am not sure if I should pick sql server 2017 or just go with the latest 2019 version. The databases we use is not very bulky and we have 12 databases in the production environment. Shall I just upgrade […] |
SQL Server 2016 - Administration |
Sql Server 2016 change provider of local host - I am updating all Linked servers in use provider MSOLEDBSQL. i don't know how to change the local host? Any suggestions appreiacte server_id name product provider data_source 0 LOCALHOST SQL Server SQLNCLI LOCALHOST server_id name product provider data_source 2 REMOTEDB EMOEDB MSOLEDBSQL REMOTEDB |
Development - SQL Server 2014 |
Get the Suggested employee to assign ticket - Dears, I have 2 tables called Employees and Tickets Employee Data Tickets Data When the user load the tickets I have to give a suggested employee who could be assigned this ticket based on some conditions Conditions: Nearest Location(The Employee who is near to the ticket location using Latitude and Longitude) TypeId AreaId TodaysTickets (Get […] |
SQL Server 2012 - T-SQL |
Problem with Latitude and Longitude Distance calc - I have an ad hoc block of code that is performing well, but when I place the logic into an insert into a temp table I get NULLS in my Distance field: This works well: Declare @source geography = geography::Point(35.93099821, -79.95852298, 4326); Declare @destination geography = geography::Point(36.08000000, -79.44000000, 4326); Select @source.STDistance(@destination) / 1609.344 as Miles; […] |
Can't run package via SQL Agent - Hi all, I didn't manage to run the SSIS Package via SQL Agent. I can do it manually but when I execute the job via SQL Server - package is down with an error "oXC0208449 the specified DSN contains an architecture mismatch" . I have 64 windows. ODBC Driver was set up for 32. Also, […] |
SQL Server 2019 - Administration |
1+(844)-460-3598Expedia Customer Service number - Expedia Customer Service number . Expedia , Inc., also known as Expedia, is the main in the United States and a legacy carrier. Its headquarters are located in Georgia, Atlanta. Together with its subsidiaries and local affiliates, the Air, which includes Expedia Connection, conducts around 5,400 s per day to 325 attractions across 52 states […] |
"SQL Server could not write to security log" alert for only a few events - Hello, Following the implementation of alerts in the SQL agent to detect errors with severities ranging from 16 to 25, I just realized that I have problems with the SQL audit that are written in the security logs of Windows because I receive alerts 17 with the description "SQL Server Audit could not write to […] |
Is there any free SQL Server on Cloud for student, that has no limit (days, only - Hello, I'm a lecturer that intend to bring back SQL Server into our curriculum on our Uni, just wanna ask, is there any free cloud SQL Server for student that has no limit for hobbyist/student to use their service, as we know ASP.NET Core in Azure is free til 10 website, just the problem is […] |
How to prevent -5 Blocking Session - Hello, There is an article below that discusses what causes it. https://techcommunity.microsoft.com/t5/sql-server-blog/negative-blocking-session-ids-5-latch-any-task-releasor/ba-p/3061302 Running SQL Managed Instance environment. Is the issue too much I/O pressure? Suggestions for monitoring/preventing. Thanks, Daniel |
SQL Server 2019 - Development |
Interrogate XML columns in table, however element names contain _x0020_ (space) - Good day In my current contract, I have been tasked with writing queries to extract data from an audit trail table in a SQL server DB, with two XML columns. Upon creating a script to view the data, reflecting exactly what has been changed between Old & New, i have encountered an issue - the […] |
JSON structure positioning - I have the following declare @X nvarchar(max) set @X='[ { "a": "", "b": "", "c": "", "e": "", "f": "", "g": "" } ]' declare @y nvarchar(max) set @y='{"bac": ""}' what I need is '"pro": [ { "a": "", "b": "", "c": "", "address": { "bac": "" }, "e": "", "f": "", […] |
PowerShell from SSIS - I am attempting to run a simple Powershell command through SSIS. The caveat is that I am using Posh-SSH as an add-on module. The Powershell script connects to a server via SSH, runs a command and captures the results. It works fine when I run it manually in Powershell or from the command prompt. When […] |
Reporting Services |
Printing group totals in a different page - Hi all, I have a requirement like printing the group totals in a new page with SSRS. for example: Page 1: Country State Sales_Amount USA NJ 100 USA NY 200 USA OH 300 Page 2: TOTAL: […] |
Integration Services |
Very wierd casting exception after deployment - Hey everyone, The issue I'm having is the strangest thing so I figured I post it here to get more eyes on it and to see if there is anything I'm missing. So, I have a SSIS package (SSIS 2019) where I have a script task that is getting some data from a web […] |
Design Ideas and Questions |
Design for multi-store online products. EAV? - so i have relentlessly researched the pros and cons of how to design product attributes using the EAV model vs separate entity model and I still can’t decide what is best for my simple project. The app is basically a map of a city where users click on a particular store which brings them to […] |