Prior to the availability of the chickenpox vaccine in the mid-90s, I recall the prevailing medical recommendation was to expose children to the virus at "chickenpox parties" with other kids who were sick. (Today of course, there is a vaccine which is a more controlled way of gaining immunity.) What aspects/conditions of the disease made […]
https://github.com/jeremyduanewallace TELL ME CAN YOU FIND THIS GITHUB ACCOUNT FOMYOUR TERMINAL WITHOUT USING A GUI ANDBIF SO WHAT WAS THE UTILITY YOU USED EMAIL ME Who is this one ☝️ USA Liberty
Hardware: Hackintosh running Mavericks. Problem: I had a DMG where I store (stored…) stuff I obviously wanted to keep private, so I unchecked the "Save in my keychain" option. Some weeks ago, beginning to upgrade all my passwords (iPad, phone etc) to something less crackable (like the 6-digit iPhone lock screen) I changed the password […]
I am typing something in a text field press ctrl+cmd+Space to show the emoji selector type an emoji name click the emoji I want 💪 But the computer delay between (2) and (3) is way too long, and the first few characters of the emoji name isn’t entered into the emoji search bar. The animation […]
What does it mean if suddenly queries start spending a long time in the starting thread state? This is our RDS Performance Insights dashboard slicing by "waits", showing huge bumps in sessions stuck on "starting": I found info on these in the General Thread States docs, but the description of the "starting" thread state is […]
I’m trying to setup logical replication between two database instances. I’ve created a publication on the main db, and a subscription on the replica. Specifically: on main db: create publication chris for all tables; on replica db: CREATE SUBSCRIPTION chris CONNECTION ‘host=localhost port=5540 dbname=finder connect_timeout=10’ PUBLICATION chris; However for some reason the replica does not […]
What are best practices steps when the Windows Server machine hosting SQL Server 2016 R2 and failover cluster (2 node and shared folder witness) on windows server 2016 is moved to another domain? What steps definitely/might need to be done for SQL Server and failover cluster before and after the new domain is joined?
I’ve read @Mike answer to How to tell if database tuning is fruitful (PostgreSQL), and that’s the kind of approach I’m thinking about for monitoring the performance of my database (of a web application, many connections, heavy writes and reads all the time, very dynamic data). The approach sums up like this: I want to […]
I know how to set statistics level for a particular column i.e alter table table_name alter column column_name set statistics 100; However if i wish to set statistics level for a particular table or for a particular schema, is there is one liner command ??