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 2019 - Administration |
→ $850-800-9826 → Emirates Airlines Ticket Reservations Number - Been thinking about booking that flight to your next dream destination? As they say, carpe diem! Check out the impressive range of routes operated by Emirates and score a reasonably priced ticket through Travelocity today. Emirates has an impressive fleet of aircraft that zips across the country connecting family, friends and loved ones every day […] |
→ $850-800-9826 → JetBlue Airlines Ticket Reservations Number - Been thinking about booking that flight to your next dream destination? As they say, carpe diem! Check out the impressive range of routes operated by JetBlue and score a reasonably priced ticket through Travelocity today. JetBlue has an impressive fleet of aircraft that zips across the country connecting family, friends and loved ones every day […] |
→ $850-800-9826 → Swiss Airlines Ticket Reservations Number - Been thinking about booking that flight to your next dream destination? As they say, carpe diem! Check out the impressive range of routes operated by Swiss and score a reasonably priced ticket through Travelocity today. Swiss has an impressive fleet of aircraft that zips across the country connecting family, friends and loved ones every day […] |
"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: […] |
SSDT |
SSDT development shop that sets ALL db objects to BuildAction=No - I work in a db development shop where it is common practice to disable the building of SQL code in SSDT projects. In other words, I have a stored procedure called sp1.sql, and I set the BuildAction to None. Object is never seen by the IDE, never gets compiled, and its only put into a […] |
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 […] |