sql server 2012 to sql server 2017 migration [closed]

How to migrate from sql server 2012 to sql server 2017 with all dependency, jobs, agents etc. together or any other best method to support it

I got some tool like data mirror migration but it has some limitation
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-ver15
old os version windows server 2008 to new win server 2016

Any suggestion or best approach

Shree

During 2016 the price of a good increased by 8%. In the sales on 1 January 2017 all items are reduced by 25%

(a) If the sale price of the good is $688.50, find the original price at the beginning of
2014.
(b) Find the overall percentage change.
(c) What percentage increase would be needed to restore the cost to the original price
prevailing on 1 January 2016? Give your answer to one decimal place

7.0 nougat – Unlocking the bootloader Huawei P8 Lite 2017 (PRA-LX1(C02)

I’d like to have my bootloader unlocked for my Huawei P8 Lite 2017 (PRA-LX1(C02)), but I don’t wanna spend money on DC-Unlocker. My phone runs Android 8.0 EMUI 8.0 but I can downgrade it to Android 7.0 if needed. If you need IMEI, Serial Numbers things like that ask me and I’ll provide those.

Thanks in Advance!

mac – Occasional Black Screen Issue using Dual External Monitors with MacBook Pro 13″ (2017)

I recently purchased a Kensington SD5500T Dock as well as two external monitors (ASUS TUF 24″ FHD 144HZ 1MS GTG IPS LED FreeSync Gaming Monitor VG249Q), and have connected both monitors through the dock to my MacBook Pro (13″ 2017). Everything connects fine through DisplayPorts and the screens show my windows how I want them to. The issue is that once in a while, one of the external monitors blinks black for about a second then comes back. This only happens with one of the monitors. I am unsure of what to do as I’ve tried a couple things to fix it. I was wondering if anyone has any advice on how to fix this?

Thanks!

sql server 2017 – Optimizing concurrent read performance

I wrote a program to test concurrent reads to a single database table. I’m expecting high amounts of read (no deletes, inserts, or updates) traffic in the future, using ad hoc queries, which is why I am testing up front to simulate this. Based on the logs below you can see that as the number of concurrent reads increases, the time it takes for requests to complete also increases. And drastically so, going from 3 seconds for a single request to a maximum of 15 seconds for 20 concurrent requests. I’m not unreasonable I think, when I spam a database for requests I expect it to take longer to process, however not by such a huge factor. Especially since the server is not CPU-bound, as is evident by the SQL Server Performance Dashboard with CPU usage at 40% during 20 concurrent requests.

Started 1.
Ended 1. Elapsed milliseconds: 2938

Started 2.
Started 4.
Started 5.
Started 3.
Started 1.
Ended 1. Elapsed milliseconds: 3204
Ended 3. Elapsed milliseconds: 4486
Ended 5. Elapsed milliseconds: 5185
Ended 2. Elapsed milliseconds: 5261
Ended 4. Elapsed milliseconds: 6075

Started 1.
Started 5.
Started 7.
Started 3.
Started 6.
Started 4.
Started 8.
Started 9.
Started 2.
Started 10.
Ended 6. Elapsed milliseconds: 4789
Ended 4. Elapsed milliseconds: 5327
Ended 3. Elapsed milliseconds: 5684
Ended 7. Elapsed milliseconds: 5732
Ended 1. Elapsed milliseconds: 6846
Ended 5. Elapsed milliseconds: 7238
Ended 8. Elapsed milliseconds: 7355
Ended 2. Elapsed milliseconds: 7551
Ended 10. Elapsed milliseconds: 7581
Ended 9. Elapsed milliseconds: 7675

Started 1.
Started 11.
Started 6.
Started 7.
Started 17.
Started 2.
Started 3.
Started 16.
Started 9.
Started 18.
Started 10.
Started 19.
Started 8.
Started 20.
Started 4.
Started 12.
Started 14.
Started 13.
Started 15.
Started 5.
Ended 8. Elapsed milliseconds: 4167
Ended 4. Elapsed milliseconds: 7327
Ended 18. Elapsed milliseconds: 9435
Ended 11. Elapsed milliseconds: 9450
Ended 10. Elapsed milliseconds: 9506
Ended 1. Elapsed milliseconds: 9884
Ended 17. Elapsed milliseconds: 9904
Ended 3. Elapsed milliseconds: 10181
Ended 19. Elapsed milliseconds: 10273
Ended 7. Elapsed milliseconds: 10640
Ended 14. Elapsed milliseconds: 11451
Ended 12. Elapsed milliseconds: 11713
Ended 15. Elapsed milliseconds: 12148
Ended 2. Elapsed milliseconds: 12304
Ended 9. Elapsed milliseconds: 12496
Ended 6. Elapsed milliseconds: 12656
Ended 16. Elapsed milliseconds: 12973
Ended 20. Elapsed milliseconds: 14306
Ended 13. Elapsed milliseconds: 14603
Ended 5. Elapsed milliseconds: 15106

Interestingly, I found little to no difference between using SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED, and ommitting it. The average response times are comparable. Is this normal? In case it helps, viewing a single request in the SQL Server Profiler looks like below. You will notice that the CPU, and Reads is pretty high (I intentionally wrote a rather heavy query). I also found that 20 concurrent requests targeting different tables does not suffer from as much a delay. So I would be open to splitting tables if there’s no other way to increase performance.

Audit Login -- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read uncommitted
                                ApplicationName     LoginName                   15544 (ClientProcessID) 93 (SPID)   2020-10-29 10:38:35.313         

SQL:BatchStarting   QueryText   ApplicationName     LoginName                   15544 (ClientProcessID) 93 (SPID)   2020-10-29 10:38:35.320         

SQL:BatchCompleted  QueryText   ApplicationName     LoginName   2187 (CPU)  436673 (Reads)  0 (Writes)  6811 (Duration) 15544 (ClientProcessID) 93 (SPID)   2020-10-29 10:38:35.320 2020-10-29 10:38:42.130     

Can an SQL Server, or the queries sent to it, be optimized for concurrent reads? If so, how? If not, what product should I move to?

ssis – Configuring 2017 SQL Server SSISDB Server-wide Default Logging Level does not seem to work

Using SSMS, I have changed the SSIS Catalog Logging Level from Basic to Performance to a Custom Logging Level in a 2017 SQL Server Instance and then I run the report: “All Executions”. It doesn’t seem to matter what Logging Level I am at, the amount of data/detail that is included in the SSIS Catalog Report remains the same. I would think the amount of detail would change with each Logging Level.

If the SSIS Catalog Reports do not change when the Logging Level changes, then how do I see the changes to the Logging Levels? Otherwise, if the SSIS Catalog Reports are suppose change, can someone please point me in the correct path to get the SSIS Catalog Reports to change?

macos – Will Macbook Air 2017 benefit from Catalina upgrade?

I’m running Mojave on my Macbook Air (2017) and was wondering if anyone can recommend (or not) upgrading to Catalina now that 10.15.7 seems to be stable release.

I’m not using any 32bit apps, so no problems there.

However, is it worth actually upgrading? I know I can’t use certain features (such as the battery health or sidecar), but should I do it for security, etc?

What are the experiences of other MBA 2017 owners after upgrade? Has anyone experienced slowdowns? Is anything actually better? Or should I just stick with Good Ol’ Mojave?

Thanks.

display – Macbook pro 2017 – Second monitor is not full screen

I’m using the second monitor for my Macbook pro (not mirror, just as the secondary screen), but unfortunately, it’s not filling the entire screen for some reason.

I’ve tried almost everything but it looks like a weird bug.

Is there any solution for this problem?

I’m attaching a photo of the monitor (the black area should be filled).
Thank you for the help
enter image description here