visual studio 2017 – When connecting to SQL Server, a network-related or instance-specific error has occurred

Hello, I have installed Visual stdio 2017 Express on Windows 10 and SQL Server 2016. When I try to run the application, it says:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details.


Visual Studio 2017 – VisualStudio2017-Qt5.12.3 can not add msvc2017_64

I want to extend Qt GUI apps with VS2017, so I have VS2017 and Qt5.12.3 installed, including the VS Qt add-in. An error window appears.
Here is the picture of the error

The error message is Chinese, in English: "The object reference is not set to an instance of the object." I tried to reinstall Qt, but it does not work. What can I do to successfully add it?

PC Games – Endless Space 2: Digital Deluxe Edition v 1.5.8.S5 + DLCs (2017) Xatab | NulledTeam UnderGround

Endless Space 2: Digital Deluxe Edition (Version 1.5.8.S5 + DLCs) (2017) PC | Repack Xatab | Size: 8.32 GB

Year: 2017
Genre: Strategy
Developer: AMPLITUDE Studios
Publisher: SEGA
Publication type: License
Platform: PC
Language: English, Multi10
Crack: enclose (CODEX)

In the game Endless Space 2 you will find an exciting role of the leader of civilization making his first steps in the cold depths of interstellar space. They will explore the mysterious star systems, discover the secrets of ancient peoples, develop advanced technologies of unimaginable power and, of course, learn about new ways of life, seek mutual understanding, conquer and conquer the possibility. Their story takes place in a galaxy that was first colonized by a people called Infinite, whose dawn and sunset are ages past. All that remains of them are mysterious ruins, powerful artifacts and an unusual, almost magical substance known as dust.

Game features:
The galaxy generator has been completely redesigned to create unique star systems and wonders for exploration, various planets for colonization, various resources for accumulation, the secrets of dust, and new life forms for conquest and various anomalies for study.
Conquer new systems by building outposts and transform your planets into fantastic Star Fortress or magnificent utopias full of wonders. Train your heroes and become admirals of the naval fleets, governors of star systems, or influential senators whom your people will follow and thanks to which your civilization will thrive.
Collect dust, strategic resources, and luxury goods to trade them in the markets, discover new incredible technologies, and stay ahead of the competition thanks to companies and diplomacy.
Design your ships, create fleets and plan the course of the battles carefully to defeat up to seven opponents in online battles. Watch epic battles and improve your strategy for future battles.
Get to know the history of every civilization, discover the secrets of the ancients and their heritage. Find legendary heroes and secret societies. The galaxy is controlled by those who reveal their secrets.
Press the space bar to enable Augmented Reality mode at any time, and to get detailed information about your systems, trade routes, diplomacy, and every ship.

Repacking features:
– Based on the release of CODEX
– Nothing is cut out / nothing was again
– Encrypted – Game archives are not opened
– Game version v 1.5.8.S5
– Additions:
527500 = Endless Space® 2 – Uthassum Rhamoezz Sophon Hero
539420 = Endless Space® 2 – Early access to "Founder" busses
539430 = Endless Space® 2 – Digital Deluxe Upgrade
733140 = Endless Space® 2 – Vaulters
751830 = Endless Space® 2 – Update Target Locked
751831 = Endless Space® 2 – Update for Little Grin Man
751832 = Endless Space® 2 – Galactic Statecraft Update
751840 = Endless Space® 2 – Stellar Prisoner Update
763330 = Endless Space® 2 – Community Challenge add-on
785060 = Endless Space® 2 – Endless Day Update
806780 = Endless Space® 2 – Supremacy
806920 = Endless Space® 2 – Guardian and the Galaxy Update
813410 = Endless Space® 2 – Untold Tales
813420 = Endless Space® 2 – Lost Symphony
841000 = Endless Space® 2 – Stories
921010 = Endless Space ® 2 – Renegged fleets
949080 = Endless Space® 2 – Harmonic memories
949081 = Endless Space® 2 – Sky Worlds
988440 = Endless Space® 2 – Penumbra
1054280 = Endless Space® 2 – Muck & Makers Update
1128540 = Endless Space® 2 – Awakening
– Installation time 3 minutes on hard disk (depending on the computer)
Repacking from Xatab

System requirements:
☑Operating system: Windows 7/8 / 8.1 / 10 (64 bit only)
☑Processor: i3 4th generation / i5 2nd generation / A6 series
☑Memory: 4 GB RAM
☑Video: AMD Radeon 5800 series / NVidia 550Ti
☑ Storage: 8 GB



PC Games – Gold Rush The Game v (2017) xatab | NulledTeam UnderGround

Gold Rush: The Game (v (2017) PC | Size: 11,83 GB | RePack from xatab

Year of publication: 2017
Genre: Adventure, Simulator, 1st-Person, 3D
Developer: Code Horizon
Publisher: PlayWay SA
Publication type: RePack
Platform: PC
Language: English, MULTi8
Medicine: encrypted (CODEX)

Gold Rush: The game is a gold mining simulator that uses various methods of gold mining, including the use of heavy equipment and various devices. Of course, you have to understand, the bigger your production is, the greater the chance of finding gold, but the higher the cost of renting equipment. Look for gold, make money, buy new equipment and profitable land. Rely on your intuition and you might become indescribably rich. If you manage the equipment personally, you have to spend a lot of time driving the excavator, but it is the perseverance that contributes to its success.

Repacking features:
– Based on the release of CODEX
– Nothing cut / not re-coded
– Game archive not open
– Game version
– Addition: Gold Rush: The Game – Frankenstein Machinery, Rush: The Game – Collector's Edition Upgrade
– Change the language in the settings games
– Installation time 5 minutes on hard disk (depending on the computer)
Repacking from Xatab

System requirements:
☑Operating System: Windows 7 / 8.1 / 10 (64-bit versions)
☑Processor: Intel Core i5
☑Memory: 16 GB RAM
☑Graphics card: NVidia GeForce GTX 760
☑ Hard disk space: 12 GB

Solution for deleting old database backups for Linux SQL Server 2017 after backups made with Ola Hallengren scripts?

I have a problem with deleting older backups I created with Ola Halengreen scripts.

USE Maintenance
EXECUTE dbo.DatabaseBackup
 @Databases = 'USER_DATABASES',
 @Directory ='/mssql/backup/',
 @DirectoryStructure ='${InstanceName}{DirectorySeparator}{DatabaseName}',
 @BackupType = 'FULL',
 @Compress = 'Y',
 @CleanupTime = 3

I received the following error message:

The value for the @CleanupTime parameter is not supported. Cleanup is not supported on Linux.

So far so good, but what is the best way to delete old backups without destroying the backup chain?

My first thought was to have a script to delete

find /mssql/backup -name "*.bak" -type f -mtime +3 -exec rm -f {} ;
find /mssql/backup -name "*.trn" -type f -mtime +4 -exec rm -f {} ;

The internal system of the SQL Server instance does not recognize the cleanup after the script is run. The backup history in the internal backup management is not updated and in case of a restore the system wants backups that no longer exist.

Does anyone have a solution for the problem?

SQL Server – SQL 2017 does not apply a temporary table update

I am at a loss in this case. With a client app we support with Tempdb table updates between SQL 2012 and SQL 2016/2017, we encounter a strange situation. The app uses tempdb extensively to store values ​​in global temporary tables until they are committed.

If you run the application on the same database that is connected to SQL 2012, all line updates will run as expected.

If in SQL 2016/2017 exactly the same process is running in the same record, the tempdb tables are not updated.

The SQL 2012 instance runs on a Windows 2012 server, and the SQL 2016/2017 instances run on a Windows 2016 server. All patches were applied to SQL and the server.

When you review the processes in SQL Profiler, they will occur in exactly the same order between the SQL versions without errors. Everywhere, no errors are reported, logs, event viewer, etc. I have examined all permissions, facets on the server, the database, user permissions, instance settings, and temporary DB configurations. There are no significant differences. If you have encountered the same problem or have clues, I would welcome them.
Thank you very much

SQL Server 2017 uses no free space

On one of our read servers (SQL Server 2017 CU2 – yes, outdated), page life has recently dropped from an average of 15,000 seconds to 250 seconds.

It is one of 2 Load Balanced Read servers and its twin has not experienced this decline.

I find it interesting to note that the Free Memory (KB) performance counter is 303,100,000, while its twin uses far more free memory: The performance indicator is 30,125,800 (an order of magnitude smaller).

Both servers have a target server storage of 409,000,000.

I'm assuming that the PLE crashed heavily because SQL Server does not take up the free space, so it's not cached as before. How do I find out what's going on?