How do you make structural changes to Azure SQL Server DBs when you don’t have access via SSMS?

We’re no longer allowed to have access to UAT/PROD environments via SSMS at my organization. The way our deployment process works is tied to git pushes. So when you push to the DEV branch, the DEV web code and DB is updated, likewise when pushing to the QA branch and the UAT branch.

The problem is when there is a structural change to the DB, very often the deployment fails with the error data loss may occur. In the past, with on-prem solutions, when we would publish the DB, if we encountered the data loss may occur error we could uncheck Block incremental deployment if data loss might occur in Visual Studio and the deployment would work. We never incurred any data loss either. Since this option is no longer available, it was suggested we use pre and post deployment scripts.

What do I need to put in the pre and post deployment scripts to prevent the data loss error? Our Visual Studio DB Project already contains all the table/view/SP/function definitions.

8 – How to programmatically grant access to private files?

I was working under the idea that i could use hook_file_download to grant access to private files; but it seems that this hook can only be used to restrict access to files, not to grant access.

I have seen suggestions of other hooks like file_access and file_access_alter; but none of these exist any more.

magento2 – How to add constant in core class ? and how to access that ? in magento 2

  1. create di.xml in to the following location

app/code/Vendor/Extension/etc/di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <preference for="MagentoCatalogModelCategory" type="VendorExtensionModelCategory" />
</config>
  1. create Category.php file on this location.

app/code/Vendor/Extension/Model/Category.php

namespace VendorExtensionModel;

class Category extends MagentoCatalogModelCategory
{
    const STATUS_PICKING = 'picking';

  public function __construct()
    {
        echo "Model Rewrite Working"; die();

    }
}

reporting – Google Analytics 4 – Explore section reports share with edit access

I am using GA4 property to track my website data.
I have created a couple of reports from “Explore” option on the left side. (Funnel/ free form/ bar/ donut).

I want to share this report to other users – who are having the following access – Edit, Collaborate, Read and Analyze.

But when they view report shared by me – they are not able to edit any report property – for example not able to change the date on the top left, not able to change the metric value/ not able to change the dimension value.

How to share editable exploration report in GA4 ? Is there an option of this? Should I change the access of the users?

[WTS] 20% OFF Windows VPS- RDP Access – One-click upgrades – 24/7 Support – Host.co.in

Host.co.in was founded in 2005 and offered High Quality, Reliable, and Affordable Web Hosting Services in India. We are the fast-growing and wildly successful web hosting company focused on delivering high-performance, secure IT solutions and services.

For those webmasters, who are looking for Cheap Web Hosting, Host.co.in is the Best Solution. With Host.co.in, stand apart in the sphere of World Wide Web with hosting for all your business needs enabling you to undertake smooth execution of your core business.

20% OFF on Windows VPS Hosting Plans, Use Code 20VSH, Offer ends on 31’July 2021

*******Below is the list of Windows VPS Hosting plans:*******

Windows VPS Starter

• 2vCPU Core
• 3 GB RAM
• 500 GB Data Transfer
• 60 GB Storage
• Plesk (Optional)
• Admin RDP Access
• 24×7 Support
• 30 Days Money Back

Price ₹799/mo. with code "20VSH"(/COLOR) | Order Now

Windows VPS Business

• 3vCPU Core
• 4 GB RAM
• 750 GB Data Transfer
• 90 GB Storage
• Plesk (Optional)
• Admin RDP Access
• 24×7 Support
• 30 Days Money Back

Price ₹1439/mo. with code "20VSH"(/COLOR) | Order Now

Windows VPS Enterprise

• 4vCPU Core
• 6 GB RAM
• 1000 GB Data Transfer
• 120 GB Storage
• Plesk (Optional)
• Admin RDP Access
• 24×7 Support
• 30 Days Money Back

Price ₹2079/mo. with code "20VSH" | Order Now

Windows VPS Corporate

• 6vCPU Core
• 8 GB RAM
• 1500 GB Data Transfer
• 150 GB Storage
• Plesk (Optional)
• Admin RDP Access
• 24×7 Support
• 30 Days Money Back

Price ₹2719/mo. with code "20VSH" | Order Now

For a full list of Windows VPS Hosting features, Avail to This Offer, Visit Today:
https://www.host.co.in/windows-vps-hosting

Why CHOOSE US?

• Complete Control
• Host multiple websites
• Strong Platform
• Private Server Hosting
• Exceptional Performance
• Managed VPS Hosting
• Remote Data Backups
• Optional Control Panel

Contact information:

In case you have any questions, you can contact our sales department by initiating a chat or by dropping an email to sales@host.co.in or call us on 1800 212 6630.

.(tagsToTranslate)webmaster forum(t)internet marketing(t)search engine optimization(t)web designing(t)seo(t)ppc(t)affiliate marketing(t)search engine marketing(t)web hosting(t)domain name(t)social media

wallet – I have an hw.1 I want to access

What can I do to recover my bitcoin from this device?

If the device believes it is in the hands of thieves (many failed PINs) it should never divulge its contents to anyone under any circumstances. I don’t know much about the HW 1 but I’d hope (and you should too) it would either self destruct or require some sort of full-reset to be usable again – losing all its contents in the reset process.

The way to recover control over the money is to use the recovery words you wrote down and kept safe back when you first set-up the device.

As one reviewer said in 2016:

The on-boarding process is quick and easy, asking the user to pick a four-digit PIN and to write down a series of ‘recovery words’ on a bundled informational sheet.

These words allow the wallet to be regenerated onto a replacement HW.1 should you lose or damage your original, and represent the device’s weakest link. When you’ve recorded the words, the card should be sealed away in a safe and treated with the same care you would furnish upon a stack of banknotes to the value of your Bitcoin hoard.

Ledger no longer provide support for the HW 1 but the recovery words will work with later Ledger devices.

✅ 50 Addon / Website @ $2.99 – cPanel – Multi PHP – Free Unlimited SSL – SSH Access


HOST ODA – Fastest SSD Hosting provider

HOST ODA a leading web hosting and services company, which has been providing quality web hosting solutions to businesses and individuals since 2018. Our goal is to provide outstanding services for the best possible price. To achieve these goals we are constantly innovating and upgrading our services at no additional cost to our customers.

Checkout Our Amazing Budget cPanel Hosting Plans !!

Our web hosting plans are suitable for small to medium-sized blogs, personal, charity or business websites.

Features for all plans:

– Reliable Service, Stable and Fast Server.

– Pure SSD Disk

– No overloading

– Hosting from own dedicated server

– Powered by cPanel

– Free Transfer when you switch to us

– Instant activation

– Softaculous Auto installer

– 30 Day Money back Guarantee

– 99.9% Uptime Guarantee.

– latest mysql

– Apache Latest w/ Symlink Protection

– PHP ALL versions w/ GD, TTF, Mbstring, PDO & more!

– 24×7 Ticket/Email support.

– Expert Support Team

– SSH Access

USA Location Servers

Accepted Payment Methods: PayPal, Bitcoins, Credit Cards

Budget Basic – Host 5 Websites
Multi Domain / Addon Domain

$5.99 / YR

200 MB Space Limit

10 GB Band Width

10 Email

10 Database

10 Sub Domain

5 Domain Pointer

5 Website Limit

SSH Access

cPanel Control Panel

Multi PHP

Free Unlimited SSL

Softaculous Autoinstaller

Website Optimizer

Free Unlimited SSL

IP Blocker

ORDER NOW

Budget Business
Multi Domain / Addon Domain

$1.99 / Month

500 MB Space Limit

15 GB Band Width

15 Email

15 Database

15 Sub Domain

10 Domain Pointer

10 Website Limit

SSH Access

cPanel Control Panel

Multi PHP

Free Unlimited SSL

Softaculous Autoinstaller

Website Optimizer

Free Unlimited SSL

IP Blocker

ORDER NOW

Budget Professional
Multi Domain / Addon Domain

$2.99 / Month

1000 MB Space Limit

20 GB Band Width

50 Email

50 Database

50 Sub Domain

50 Domain Pointer

50 Website Limit

SSH Access

cPanel Control Panel

Multi PHP

Free Unlimited SSL

Softaculous Autoinstaller

Website Optimizer

Free Unlimited SSL

IP Blocker

ORDER NOW

Check Packages >> Click Here

Contact Us

Website: https://www.hostoda.com/

Email : sales [at] hostoda.com

sharepoint online – How to change the message in any site from “This site hasn’t shared with you” to “Let us know why you want the access of this site”


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




dnd 5e – What is the earliest level that a player character can gain access to a wish spell?

Wish is a 9th-level spell. It’s only on the wizard and sorcerer spell lists.

Full caster classes (including sorcerers and wizards) gain 9th-level spell slots at level 17 in the class. Multiclassed spellcasters know/prepare spells as if single-classed, so you need at least 17 levels in either sorcerer or wizard to have a 9th-level spell slot and thus be able to learn the spell.

The one exception is the bard class, thanks to their Magical Secrets feature:

By 10th level, you have plundered magical knowledge from a wide spectrum of disciplines. Choose two spells from any class, including this one. A spell you choose must be of a level you can cast, as shown on the Bard table, or a cantrip.

The chosen spells count as bard spells for you and are included in the number in the Spells Known column of the Bard table.

You learn two additional spells from any class at 14th level and again at 18th level.

Using the Magical Secrets feature, you can learn 2 spells from any class spell list at 18th level. As full casters, bards also get a 9th-level slot by that point, so they can learn wish using the feature.

Finally, Arcana Domain clerics get the Arcane Mastery feature at 17th level (SCAG, p. 126):

At 17th level, you choose four spells from the wizard spell list, one from each of the following levels: 6th, 7th, 8th, and 9th. You add them to your list of domain spells. Like your other domain spells, they are always prepared and count as cleric spells for you.

They could choose wish as their 9th-level spell from the feature. (Thanks to David Coffron for pointing this out!)

There are a few magic items that can let you cast the wish spell or cast it for you. However, it’s up to the DM whether to even roll on the tables to determine treasure, or whether to allow you to gain items that let you cast the wish spell. Given how powerful wish can be, the DM might be hesitant to do so any sooner than you could normally learn the spell.

The lowest-rarity item, the Efreeti Bottle, is still listed as “very rare”, and only has a 10% chance of giving you wishes:

When you use an action to remove the stopper, a cloud of thick smoke flows out of the bottle. At the end of your turn, the smoke disappears with a flash of harmless fire, and an efreeti appears in an unoccupied space within 30 feet of you.

The first time the bottle is opened, the GM rolls to determine what happens.

On a roll of 91-00 on the percentile dice (“d100”), it gives the following result:

The efreeti can cast the wish spell three times for you. It disappears when it grants the final wish or after 1 hour, and the bottle loses its magic.

All but one of the remaining items that allow you to cast wish are legendary items. The first and probably most controversial is the Deck of Many Things. Only one of the cards in the Deck, the Moon, lets you cast wish (with the other possible effects ranging from campaign-destroyingly good to campaign-destroyingly bad):

Moon. You are granted the ability to cast the wish spell 1d3 times.

A much simpler item that lets you cast wish is the Luck Blade:

Wish. The sword has 1d4–1 charges. While holding it, you can use an action to expend 1 charge and cast the wish spell from it. This property can’t be used again until the next dawn. The sword loses this property if it has no charges.

The Ring of Three Wishes is probably the most straightforwardly named of the bunch, and does what it says on the tin:

While wearing this ring, you can use an action to expend 1 of its 3 charges to cast the wish spell from it. The ring becomes nonmagical when you use the last charge.

And finally, the last item (or pair of items) is an artifact, the Eye and Hand of Vecna (DMG, p. 224). Attuning to both items involves some self-mutilation (and removing either one afterwards kills you), but you gain a variety of benefits and incur a few dangers. If you attune to both, the last benefit listed is:

You can use an action to cast wish. This property can’t be used again until 30 days have passed.

There is, of course, the possibility (however unlikely) of acquiring a 9th-level spell scroll with the wish spell on it. Spell scrolls can only be used by those with the spell on their class spell list, so only sorcerers or wizards can do it (or bards who pick the spell with the Magical Secrets feature, but they’d already know the spell that way so it’s kind of pointless for them). Note that even lower-level sorcerers/wizards could use a wish spell scroll, but they’d have to pass a DC 19 check using their spellcasting ability (Charisma for sorcerers, Intelligence for wizards):

If the spell is on your class’s spell list but of a higher level than you can normally cast, you must make an ability check using your spellcasting ability to determine whether you cast it successfully. The DC equals 10 + the spell’s level. On a failed check, the spell disappears from the scroll with no other effect.

The Magic Item Rarity table on DMG p. 135 suggests that very rare items be limited to 11th-level or higher characters, and that legendary items be limited to 17th-level or higher characters.

However, the magic item tables on the following pages do list specific magic items as possible treasures, and the treasure hoard tables do give guidance on randomly determining the contents of a large cache of treasure, whether that’s the accumulated wealth of a large group of creatures, the belongings of a single powerful creature that hoards wealth, or a reward from a wealthy/powerful benefactor for completing a quest (DMG p. 133):

When determining the contents of a hoard belonging to one monster, use the table that corresponds to that monster’s challenge rating. When rolling to determine a treasure hoard belonging to a large group of monsters, use the challenge rating of the monster that leads the group. If the hoard belongs to no one, use the challenge rating of the monster that presides over the dungeon or lair you are stocking. If the hoard is a gift from a benefactor, use the challenge rating equal to the party’s average level.

Every treasure hoard contains a random number of coins, as shown at the top of each table. Roll a d100 and consult the table to determine how many gemstones or art objects the hoard contains, if any. Use the same roll to determine whether the hoard contains magic items.

The Efreeti Bottle corresponds to a roll of 71 on the d100 on Magic Item Table H (DMG p. 148). Magic Item Table I (DMG p. 149) includes the Luck Blade (corresponding to a roll of 11–15), the Deck of Many Things (81), and the Ring of Three Wishes (94).

The table for treasure hoards corresponding to CR 5–10 creatures (DMG, p. 137) has two rows that involve rolling once on Magic Item Table H; following these guidelines, it’s only possible if the DM rolls 99 or 100 on the d100 when determining the treasure hoard. In order to then get an Efreeti Bottle, the DM would need to roll a 71 on another d100 for the magic item table. (And in order to then have the efreeti grant you 3 wishes, they’d need to roll a 91-00 on the d100 when the bottle was actually used by a character.)

Alternately, the treasure hoard table for CR 11–16 creatures (DMG, p. 138) includes a few more rolls that could theoretically result in an item that lets you cast wish. If the DM rolls 83–92 on the d100 for the treasure hoard table, they can roll 1d4 times on Magic Item Table H (to potentially get an Efreeti Bottle). If they instead roll 93–00 on the d100 for the treasure hoard table, they can roll once on Magic Item Table I. (And they’d then need to roll an 11–15, 81, or 94 on the d100 for the magic item table to result in an item that can let you cast wish.)

Finally, the treasure hoard table for CR 17+ (DMG, p. 139) states that a roll of 73–80 corresponds to 1d4 rolls on Magic Item Table H; a roll of 81–00 corresponds to 1d4 rolls on Magic Item Table I.

Artifacts (such as the Eye and Hand of Vecna) are a totally different beast, beyond even the highest treasure hoard or magic item tables (DMG, p. 219):

An artifact is a unique magic item of tremendous power, with its own origin and history. An artifact might have been created by gods or mortals of awesome power. It could have been created in the midst of a crisis that threatened a kingdom, a world, or the entire multiverse, and carry the weight of that pivotal moment in history.

(…)

Characters don’t typically find artifacts in the normal course of adventuring. In fact, artifacts only appear when you want them to, for they are as much plot devices as magic items. Tracking down and recovering an artifact is often the main goal of an adventure. Characters must chase down rumors, undergo significant trials, and venture into dangerous, half-forgotten places to find the artifact they seek. Alternatively, a major villain might already have the artifact. Obtaining and destroying the artifact could be the only way to ensure that its power can’t be used for evil.

All in all, the DMG does not really expect low-level characters to be able to cast wish even through magic items. You can only expect to have a fairly significant chance to get a magic item that lets you do so once you’re already high enough level to cast the spell (assuming you don’t multiclass). This is probably at least somewhat by design, given that even the spell description begins:

Wish is the mightiest spell a mortal creature can cast. By simply speaking aloud, you can alter the very foundations of reality in accord with your desires.

Frankly, you’re better off talking to your DM about finding a way to cast simulacrum directly rather than trying to cast wish to replicate its effect, given how potentially world-changing (and campaign-affecting) wish can be.

Access location-dropdown in preview with the keyboard?

I want to access the location dropdown in the “file-dialog” (no glue how to name that). Before Big Sur, I could cycle through the 3 fields (Name, Tags, Ort (=english: Location) with the Tab-key.
Now (within Big Sur) it just cycle throuth the first 2 fields. With the Tab-key I cannot access the location dropdown anymore.

How can I access it with the keyboard again?

enter image description here