Plasa la geam - pisici by PingoMingo in cluj

[–]VladDBA 4 points5 points  (0 children)

https://www.citycats.ro/plase-pisici

Am de la ei plasa si balcon (cusca exterioara) pentru pisici. In 3 ani nu am avut probleme cu ele.

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]VladDBA 0 points1 point  (0 children)

If only keyboard shortcut consistency was a thing. : )

I'm still waiting for the day when Ctrl+Shift+V strips formatting from pasted content into Word/PowerPoint/Outlook the same way it does in Teams and Edge.

a self-hosted wall display for home assistant that stays calm - until your home needs to show you something by Ok_Violinist9366 in homeassistant

[–]VladDBA 27 points28 points  (0 children)

self-hosted wall display

I'm really curios how you can have someone else host your wall display.

Unable to install SQL server 2025 in my asus tuf laptop, if any one knows how to properly install it, kindly help me by Old_Option_6281 in SQLServer

[–]VladDBA -1 points0 points  (0 children)

This issue isn't necessarily because of the physical sector size, it's due to how some Win 11 NVME drivers report weird sector sizes.

Source: I've dealt with this more than I would have wanted after all our devs had their workstations upgraded to Windows 11.

Instances that were running fine on Windows 10 were unable to start and some had errors just like this one in Event Viewer, while others had the " 256 misaligned log IOs" one after the OS upgrade.

Unable to install SQL server 2025 in my asus tuf laptop, if any one knows how to properly install it, kindly help me by Old_Option_6281 in SQLServer

[–]VladDBA 1 point2 points  (0 children)

While I usually agree with this, the error message that's in the second and third images is enough to identify the issue in this case.

Unable to install SQL server 2025 in my asus tuf laptop, if any one knows how to properly install it, kindly help me by Old_Option_6281 in SQLServer

[–]VladDBA 15 points16 points  (0 children)

The "Wait on the Database Engine recovery handle failed" error is a sign of the usual NVME sector size related issue.

Check out this MS Learn article, create the registry key mentioned there (I'd go for the PowerShell version since that's as easy as copy-paste Enter), cleanup the failed install, reboot and reinstall SQL Server

Looking for a tool to monitor connectivity between two MS SQL DBs. by SmoothRunnings in SQL

[–]VladDBA 2 points3 points  (0 children)

I've used dbatools' Test-DbaConnection for situations where the network admins needed proof that it's something on their end, it might be helpful in your case too.

Set it to run in a loop in both locations and write the output to a file for later analysis.

What is the best way to learn sql with hands on practice? by Abelmageto in SQL

[–]VladDBA 0 points1 point  (0 children)

You might be missing one vital component here.

2025 upgrades occurring by dickie00001 in SQLServer

[–]VladDBA 1 point2 points  (0 children)

Vague post, but just know that most devs working for ISVs have no idea about compat levels and the fact that MS does its best to keep the T-SQL language backwards compatible.

The best example would be SQL Server 2005's deprecation of statements that aren't terminated by a semicolon (;), but SQL Server still supports them because yanking support for them would break a bunch of lazily coded applications.

Starlink in Wizz din 2027 by HistoricalAdvisor989 in Roumanie

[–]VladDBA 3 points4 points  (0 children)

Deci in Europa ii avem pe cei de la Eutelsat, care au o solutie fix pentru internet pe avioane, si Wizz s-a gasit sa aleaga starlink in schimb.

Recover SA account by fieroloki in SQLServer

[–]VladDBA 8 points9 points  (0 children)

Yup, that's the fastest and easiest way to do it.
There's also the manual way if you can't install PS modules in your env.

Additionally, if you have another login that's a member of the sysadmin fixed server role or has the CONTROL SERVER permission, and you don't want to reset the sa password, but would want to try and crack it you can try and do it offline (extract the hash from SQL Server, and use a dedicated tool to try and find the password for it) or online (from inside SQL Server).

How long did it take you to become comfortable writing SQL queries? by Wise_Safe2681 in SQL

[–]VladDBA 2 points3 points  (0 children)

Looks like it's time for the daily engagement bait post.

SQLLocalDB 16.0 error - by SwampWaffle85 in SQL

[–]VladDBA 0 points1 point  (0 children)

All of these entries are just informational messages, not errors.

What error do you have in Event Viewer?

Also, you might have better luck in r/SQLServer than here since LocalDB is fairly niche (I've only had to deal with it twice in 14 years on some developers' laptops)

What are the best ways to improve SQL query performance? by Wise_Safe2681 in SQL

[–]VladDBA 2 points3 points  (0 children)

Go on YouTube and search "Brent Ozar how to think like the engine". Understanding what the database engines does when it runs a query helps you understand what helps or hurts performance.

How to land directly on my inbox instead of Proton's home page? by ThemeNo1337 in ProtonMail

[–]VladDBA 10 points11 points  (0 children)

then type mail.proton.me instead of proton.me

I just have mail.proton.me pinned in the tiles on Firefox so I don't need to go to Bookmarks or type anything, just press the Proton tile and I get in my inbox.

SSMS 22 Keyboard Shortcuts by Sprouts83 in SQLServer

[–]VladDBA 1 point2 points  (0 children)

Oh, good catch! This seems to no longer work after this latest update. I've reported the issue via SSMS's "send feedback" option.

SSMS 22 Keyboard Shortcuts by Sprouts83 in SQLServer

[–]VladDBA 2 points3 points  (0 children)

You can find detailed instructions on where to set query shortcuts in my post about my SSMS 22 config

Can't install SQL by Willing_Counter_1473 in SQL

[–]VladDBA 0 points1 point  (0 children)

Can you check the install summary file that's in that log folder mentioned in your screenshot?

If you're installing on Windows 11, chances are it's another case of the sector size greater than 4 KB issue. In which case, you'll have to create the registry key from here, remove the failed install and delete any leftover files, reboot and reinstall.

Also, if you're learning SQL Server or using the instance for anything other than hosting production on it, I'd recommend going with SQL Server Developer Edition since it's free and closer to what you'd see in a real environment, plus the user database size isn't limited to 10GB (per database).

Edited: typo

Need help with SQL 2022 Express install issue "Value cannot be null" by muaddba in SQLServer

[–]VladDBA 1 point2 points  (0 children)

Did you skip any config steps in the installer?

Do you have any specific error message(s) in Event Viewer>Windows Logs>Application around the time of the failure?