SQL Server Data Tools – Data Link Properties – Server Name Drop Down Empty

I’m using VS 2019 with the latest version of SQL Server Integration Services Projects plugin. I have 2 local SQL Server instances installed on the same machine which are up and running (including Browser service). SQL Server is 2017 and 2019 (default and named instance respectively) and their Hide Instance flag is set to No. When adding Data Link for Data Flow SSIS tasks server drop down not showing my SQL instances like that: enter image description here

At the same time if I type in SQL Server instance name I can connect just fine. What can be causing my SQL instances not showing up here?

VpM speed down after 1-20 min

Hi! whats the problem or wrong setup may be in this case:

I start 2-3 projects. Each in own bunch of emails (Catchallboxes, Asiavirtualsolutions and mail.ru with no spam.

In each project I set  90% engines (for tier2).  Machine power is over. No more than 1-3% CPU use (the same digits in RAM).

———

Projects start well with 90-100-300 VPM speed and down and down. 10 min. 70 VPM, 20 min 30 VPM and after coule of hourse no more than 2-5 VPM.

 I tested 50-300 treads in global settings but no result. Speed down fast soon in all settings.

Sitelists and projects – all the same I use before. For example – GSA has keep stable speed 40-60  VPM  from week to week and last days I cant find the problem point.

Any idease please 

How do I adjudicate a player trying to sweep kick an enemy’s legs to knock them down?

I’m new to D&D. I already read both the Player’s Handbook and Dungeon Master’s Guide (I’m mastering) and I would like to know how I could handle this situation:

A player wants to do a sweep kick on an enemy’s legs and knock him down. He rolls a 20 and does the damage, but what about taking the enemy down? There is no rule that covers it.

Following the rules, the player would have to do a specific action to try to push the enemy down, and there would have to be a resisted check to see if the player can actually drop the enemy, so how could I deal with that?

How to prepare my party to reasonable be able to bring down a prismatic wall?


Background

In my campaign I have a villain who uses misdirection and avoidance as their main combat methods. As last resort when the party confronts them in their lair it would be appropriate for them to use Prismatic Wall to prevent the party from killing or capturing them.

Prismatic Wall requires 7 different, very specific, spells in a specific order to remove. Namely; Cone of Cold, Gust of Wind, Disintegrate, Passwall, Magic Missile, Daylight, and Dispel Magic.

This enemy is clever but arrogant, they will likely cast this spell toward the end of a drawn out battle meaning the party may already be down on resources. Without warning they might need to defeat a Prismatic Wall the party may expend the required resources before it appears.

Party Details

In my party I have:

  • A Half-Elf Wizard
  • A Human Druid
  • A Gnome Oracle
  • A Halfling Bard
  • A Half-Orc Paladin.

The party is currently 9th level and they will likely confront this enemy some time between 12th and 14th level depending on how direct their approach is.

The party is equipped slightly below normal for their level due to some decisions made to this point in the campaign. None of their current items will be a particular benefit in this task.

The Problem

I would like my party to have a reasonable chance of actually being able to bring down this wall. If I just throw it at them the chance of this is basically 0. This is the first campaign for all of my players and they have never encounter anything like this before.

Between the various spellcasters in the party they already have access to 5 out of the 7 required spells. Disintegrate and Passwall being the exceptions. I can easily provide them access to the others between now and the confrontation. However, the party does not always prepare these specific spells and may not have them available when required.

How can I, as DM, prepare my players to defeat a Prismatic Wall spell, without explicitly telling them it is coming?

I will likely need to provide them both with information on how to defeat it and provide some resources to help them do so. I am willing to provide help in the form of items, lore dumps from NPCs and potentially NPC allies, though I prefer not to have NPC perform critical actions in place of the players.

Can a creature with wings choose to fall to get down faster?

A dragon flies at 4000 feet of altitude and needs to get to ground level as fast as possible.

With a double-move and a fly speed of 200, it can only move 400 feet per round.

But, can it choose to stop flapping its wings and fall (I would assume maybe 500 or 1000 feet per round), and then use the Fly skill to negate the 20d6 of falling damage when it hits the ground?

Can players choose specific points in space, down to the inch, to cast a spell so as to avoid hitting a prone character?

Say there is a character that is prone, such as if they were unconscious, and they are surrounded on all 8 square grids (assuming that a grid is being used) by other creatures. Can a player cast a spell that has a sphere effect such as fireball or shatter such that only the 8 creatures surrounding the one that is prone be hit?

Would this potentially have any adverse effects with potentially breaking or having any unintended consequences for any other spells/effects down the line if this were allowed?

Obviously when it comes to casting some spells, the caster has the option to "choose a point in space", but when playing with the understanding of a grid system that works in chunks of a given dimension does is it feasible to have spells cast in such a way so that a body lying prone won’t be affected by a spell cast just overhead?

SQL – Date Range Broken Down by Individual Month and Year while maintaining the ID


I need help breaking down a date range, from an existing table, into the individual month and year of the date range while maintaining the Identification Number assigned to that date range. Thanks!

CREATE TABLE #TEMP (BILL_YR INT, BEGIN_DT DATETIME, END_DT DATETIME )  INSERT INTO #TEMP (BILL_YR, BEGIN_DT, END_DT) VALUES ('1','2019-01-01','2019-12-31'), ('2','2020-01-01','2020-12-31') 

EXPECTED RESULT

BILL_YR MONTH    YEAR 1       1        2019 1       2        2019 1       3        2019 1       4        2019 1       5        2019 1       6        2019 1       7        2019 1       8        2019 1       9        2019 1       10       2019 1       11       2019 1       12       2019 2       1        2020 2       2        2020 2       3        2020 2       4        2020 2       5        2020 2       6        2020 2       7        2020 2       8        2020 2       9        2020 2       10       2020 2       11       2020 2       12       2020 

How to interpret “round up or down” in monster CR calculation

In the "Creating Quick Monster Stats" section of the DMG (p.274) we are given the procedure for determining the CR of a new DM-designed monster. Step 4 of that procedure (pp.274-275) tells us to calculate a defensive challenge rating, an offensive challenge rating, and then the

Average Challenge Rating. The monster’s final challenge rating is the average of its defensive and offensive challenge ratings. Round the average up or down to the nearest challenge rating to determine your monster’s final challenge rating. For example, if the creature’s defensive challenge rating is 2 and its offensive rating is 3, its final rating is 3.

How are we to take the instruction to "round up or down"?

Does the DMG mean to say that it is DM’s choice (rather than defined procedure) whether to round up or down? And that once that decision is made you move to the nearer CR in that direction?

Or, is this passage saying that the rounding should take you to the nearest CR, regardless of whether this means rounding up or down? For example, if the DCR was 1/2 and the OCR was 2, the average CR would be 1.25, which we would round down to 1, because 1.25 is nearer to 1 than 2. But if the DCR was 3 and the OCR was 1/4, the average CR would be 1.625, and we would round up to 2 because 1.625 is nearer 2 than it is 1.

The example then given shows rounding up, but in the confusing case of 2.5 being equidistant from both 2 and 3, which doesn’t let us parse which of the two possible meanings is intended.

There are a number of CR-calculation questions on this site, but I haven’t found this specific question. I understand that the final CR is by DM fiat, involves many other considerations, and is not a direct result of this specific procedure – I am just trying to understand what the actual procedure described in this passage is.