I agree with what Ken said about the dev license - dev/visual studio licensed SQL Server can have prod data copied to it, but you can't copy prod data from...

To add to SoCal_DBD's reply - which of the 3 queries is being super slow and how big is your tempdb and do you still have space on disk for...

If memory serves, SSDT for VS 2019 is an option during install, so it could be you need a patch update.

As a thought - can you use report builder instead...

My opinion - if you have a 200 GB database and have 10-15% that you are wanting to replicate short term and you don't have enough space for that, you...

If your ETL is done with SSIS, I am pretty sure you can set that up to execute things in a specific order. So you can have it wait for...

As far as I know SSIS cannot be scripted. SSIS is it's own thing. The export method you are using is designed to be an infrequent export option. If you...

A lot to unpack here and not entirely sure what you are trying to achieve, but will do my best to answer.

First, if you are deleting 30 million rows, you...

The third one is a fun one - open source dependencies. We have a tool that often has "free" plugins available for it but after a few years those free...

Just to confirm, you get that error when trying to PREVIEW the report on your local computer, correct? If so, are you using the correct VS version for the SSDT...

I've personally never used between and it is because of this exact QOTD - I can never remember for certain if it is inclusive, exclusive, or a mix and I'd...

I have also used heaps when the data has no real business value but someone requested the data to be captured because it may be needed one day by someone....

My big takeaway from your article was this bit:

But perhaps the most valuable insight was this: before touching MAXDOP, fix the query. In our case, adding a missing index and...

With the ad hoc queries as needed, a good monitoring tool should be able to capture some of those too. RedGate Monitor (formerly SQL Monitor) allows you to capture custom...

My advice - don't trust random people on a forum - trust the source. Check the Microsoft Docs:

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver17

Upgrading to 2022 requires a min version of 2012 SP4.

Now, that being said,...

Multiple tools means more systems to administer and more tools to patch which also means more man-hours to keep your environment up to date.

I much prefer to get all of...