|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Adding Features During a SQL Server 2022 Upgrade | |
I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Am I on Synapse? How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics? Answer: Use Serverproperty() with the Edition property Explanation: @@version returns the same information as Azure SQL Database. While your hostname might help, this could be aliased in some way. ServerProperty with the EngineEdition. Ref: Serverproperty - https://learn.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver16 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Does a Query Lock to the Table_Name or Table_ID - SQL 2017 ENT SCENARIO: Table_1 has a Sch-M lock on during an intended updating process. A QUERY is executed against Table_1 and is queued up, waiting for the Sch-M lock to release. While the QUERY is queued up on Table_1, Table_1 is renamed to Table_1_OLD A newly designed Table_2 is then renamed to Table_1 QUESTION: […] |
SQL Server 2017 - Development |
update field on a select query - I have a sql query that runs on demand to generate a report. I want to update a field REPORTSENT to a Y on the selected results. So the next time the report is requested only the Records with a REPORTSENT = N will be returned. Normally would run the query for the records and […] |
SQL Server 2019 - Administration |
Cluster Timeout Settings to handle transient network outages - I have an Availability group with 2 replicas on the same subnet. We've been experiencing short network outages that last a few seconds and cause connections to timeout. This causes the AG to fail completely (not failover automatically) and we have to manually bring it back online since the DBs are marked "not synchronizing" on […] |
Question about SQL Certs and DNS aliases - About 15 years ago we started creating DNS aliases for each database. This allowed us to move databases without needing to change client connections. We now use these aliases in all applications, reporting, ETLs, etc... When we upgrade SQL we create new servers and migrate the databases, using the aliases made this simple. We also […] |
SQL Server 2019 - Development |
SSIS Package runs on one server but getting an assembly component error on anoth - I posted this over on Stack Overflow and got bupkis and was hoping someone over here would be able to help me. I have an SSIS package that has been tested, and ran in Visual Studio 2019. It was originally created, tested, and ran in VS 2017 but when I started having the issue I […] |
ssis dashboard suddenly missing from reports option under catalog/ssisdb - hi i rt clicked ssisdb today under integration services catalog , chose reports and didnt see the dashboard option under my regular id. my id has sa. so i connected with my admin which also has sa and did see it. losing permissions would have occurred in the last 24 hrs. i saw in one […] |
SQL Azure - Development |
Hybrid Cloud Server Integration with SQLServerCentral’s SQL Server 2022 - Hello everyone, I’m currently exploring the use of hybrid cloud servers and am focusing on integrating them with SQLServerCentral’s SQL Server 2022. While hybrid cloud environments offer flexibility, managing and optimizing them with SQL Server 2022 presents several challenges. Here are some specific areas where I’m seeking advice: Integration Best Practices: What are the best […] |
SQL Azure - Administration |
SQL Server 2022 on Azure VM - I was provisioned this DB on an Azure VM. I needed to uninstall and reinstall it in order to set the proper collation. I dont know how it was originally setup or if it goes by another namelike "Managed SQL Instance" as another department handles setting these up. When they learned of my uninstall/reinstall they […] |
General |
Performance of Derived table in large data(12 crores and more) - Using Derived Table in query on large data (12 crores and more) results in CPU utilization greater than 90% resulting in performance degradation. Why Using Derived Table in query utilizes high CPU when it is created in memory |
Powershell |
dump to csv -- image column - If there is an Image Column in mssql table and I wanted to use export-csv to dump this info to file how do you handle that column to be able to import that csv to another DB. Thanks. |
SQLServerCentral.com Website Issues |
Future Post - This post is from the future! How did that happen? https://www.sqlservercentral.com/forums/topic/git-configuration-and-automated-release-for-azure-data-factory#post-4451220 |
SQL Server 2022 - Administration |
How to connect to Developer Server Edition - Hi, I am attempting to connect to a local instance of sql developer installed today. When attempting to connect to the Server Name: EHL5CD4254Q4G with Windows Authentication ( its a domain joined laptop btw), I get an error: TITLE: Connect to Server ------------------------------ Cannot connect to EHL5CD4254Q4G. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'mydomain\myaccount'. […] |
SQL Server 2022 - Development |
Text column is taking More time while Querying, Need to Replace DATALENGTH - select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0 resolution_text Text column is taking More time while Querying, Need to Replace DATALENGTH, when i replace datalength condition as "r.resolution_text is not null" the above query is returning data |
SSIS package project connections don't work on upgrade - We're upgrading from SQL Server 2016 to 2022. The SSIS package project level connections don't work as expected. One queries the server as an anonymous logon instead of the domain account associated with the SQL Server Agent. One even affects both the original server and the new one to which it is pointed. I have […] |
2022 azure vm cant run same ssis pkg we run on prem - Hi, we set up an environment on our new azure 2022 vm with a cloned "prod target warehouse", ssis project clone from prod, cloned sql agent etc etc. amongst other things the ssis points at a new erp's sales data we are testing with in just one agent step/ssis project execution for that 2019 std […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |