## Get every column in database that contains only Null records

I am responsible for a poorly designed legacy application that has 700+ MSSQL tables and plenty of columns that are completely unused. I would like to run a script to return the column and table name of every column that has only null records. Does anyone have any suggestions on I could accomplish this?

## Is it safe to use the Windows “Compress directory to save space” feature on the directory that contains my MySQL general log file?

I have changed MySQL 8 on my Windows 10 development machine to write logfiles (general log and slow queries log) to "E:\mysql logfiles". I’d like to compress this directory using the Windows "Compress Directory to save space" advanced feature in the Windows 10 directory properties to save space (currently my logfile is over 50 GB). I’m wondering though: is this a good idea? Or will this break MySQL in (subtle or not) ways?

## List of equally distanced numbers in an interval [a,b] that contains both a and b

I’m writing a program that should split a given interval $$[a,b]$$ into a list of $$\sqrt{N}$$ equidistant numbers:

N = 27; a = -1; b = 1; p = 3; Range[a, b, RealAbs[b - a]/(N^(1/p) - 1)]  {-1, 0, 1} 

The result should be a list that has $$N^\frac{1}{p}$$ numbers, and that contains both $$a$$ and $$b$$. The program works when $$N=x^p$$, where $$x$$ is an integer, but fails to include $$b$$ in the list when this condition is not met.

For example, when $$p=2$$ and $$N$$ is not a perfect square:

Np = 10; a = -1; b = 1; p = 2;  Range[a, b, RealAbs[b - a]/(Np^(1/p) - 1)] // N  {-1., -0.0750494, 0.849901} 

Is there a way to specify that both ends, $$a$$ and $$b$$, should be part of the list, and then equally split the interval into a total of $$\sqrt{N}$$ equidistant numbers?

## What book contains the rules for creating travelling shows?

I noticed that the Palladium website has a Traveling Show Creation Log. Presumably this worksheet would be used while working through the rules, detailed in a supplement of some kind, for defining a traveling show and its membership. In which book can I find the rules for traveling show creation?

## What powers might an artifact posess which contains the domain of a god? [closed]

I was not sure whether I should post this here or if I should take this question to the world-builders, but since it pertains more of the mechanical side of things I felt this was the right place:

I recently acquired a campaign setting in which there are no more gods and all that is left divine-wise are their divine/unholy servants, the arch-seraphs and arch-daemons. While brainstorming campaign-ideas I came up with remnants of the dead gods which are spread around the world, news of which spark a huge amount of conflict in the scramble for the last remnants of the truely divine. I got most of it fleshed out lore-wise, but i am kind of stumped with the powers of the remnants. I plan to make the remnants contain different divine domains, namely Creation, Destruction, Renewal and Fate, but I do not know what powers these artifacts should possess, considering that my players probably will get their hands on at least one or two of them. I have vague ideas for Renewal and Fate: for Renewal I would be going in the direction of restoration, healing, maybe refilling used powers, Fate could be predicting fate (some kind of divination magic maybe?) and/or changing fate (forcing/allowing rerolls perhaps)? For the other two, I do not seem to be able to come up with even the broadest strokes of thematicly fitting powers (apart from being able to cast domain spells, those feel like a given, but not like they are enough).

TLDR: My questions are these:

1. What powers apart from casting domain-spells could artifacts containing the divine domain of Creation, Destruction, Renewal or Fate possess? Consider that players will most likely get their hands an a few of them.
2. How powerful should the spellcasting of the artifacts be? My naive first idea would be 20-ish, since they would be fueled by the divine domain of a true god, but depending on when the players get their hands on them that could destroy the power-balance…
3. What are your thoughts on making the artifacts semi-sentient to fully sentient?

## windows 10 showing me that bWAPP contains a reverse shell

i have downloaded bwapp from official site and windows 10 defender showing me that it contains a reverse shell ( i know these things are there for practice ) but in earlier days it is not showing that. Is it good to use it is safe to use

Or it is just a False Positive

## Searching for substring in field that contains variable length of arrays of json objects

I am trying to construct a sql query, that searches for a substring within a field. The issue is that the field contains an array of one or more json objects.

For example the table looks like so:

day     |   items ____________________ Sunday  | [{"apples":5, "bananas":2}, {"pears":12, "cucumbers":9}, ...] Monday  | [{"apples":6, "bananas":1}, {"watermelon": 1}] Tuesday | [{"apples":4, "bananas":3}, {"tomatoes": 1}] 

How do I construct a SQL query that searches for a substring in items given it is not a string ?

Thanks

## Can’t understand difference in fulltext results – contains, contains with wildcard, freetext

I have a table with an fulltext index on the column named Filecontent. The table has a row where content contains "W 917". For context, the content column on this rows contains much more than just what I’m searching for.

I don’t understand why I’m getting different results depending on whether I’m using contains, contains with wildcard or freetext. Why is CONTAINS without wildcard getting results, but CONTAINS with wildcard doesn’t?

-- Searching for "W 917" -- No match - CONTAINS with wildcard SELECT * FROM InvoicePDFContent t1 WHERE CONTAINS(t1.Filecontent, '"W 917*"')  -- Match - CONTAINS SELECT * FROM InvoicePDFContent t1 WHERE CONTAINS(t1.Filecontent, '"W 917"')  -- Match - FREETEXT SELECT * FROM InvoicePDFContent t1 WHERE FREETEXT(t1.Filecontent, '"W 917"')   -- Searching for "W" -- Match - CONTAINS with wildcard SELECT * FROM InvoicePDFContent t1 WHERE CONTAINS(t1.Filecontent, '"W*"')  -- No match - CONTAINS SELECT * FROM InvoicePDFContent t1 WHERE CONTAINS(t1.Filecontent, '"W"')  -- No match - FREETEXT SELECT * FROM InvoicePDFContent t1 WHERE FREETEXT(t1.Filecontent, '"W"') ยดยดยด 

## Does a regular expression exist for any number that contains no more than two 5s and no 6 twice in a row?

For example, a valid number would be 6165156 and an invalid number would be 1566515.

I have tried many times to construct a finite state machine for this with no success, which leads me to believe the language is not regular. However, I am unsure how to formally prove this if that is indeed the case. I tried applying the pumping lemma but I am not completely sure how to apply it to this particular language.

Any help is appreciated!

## Fall of Plaguestone: why is my group failing so hard? [Contains Spoilers]

I’m new to pathfinder and started it with my group on roll20 due to Corona. I have decade long gm experience in in games like DSA (Das Schwarze Auge) and Shadowrun but not for Dungeon Crawlers.

Long story short: We are playing the Fall of Plaguestone module and my group (Rogue, Sorcerer, Paladin and Priest) needed hard intervention from my part as not to die on multiple encounters. Since I still need to get a feel for the difficulty I’m not changing anything from the module and play it by the letter.

The group nearly died by: (contains spoilers)

Enemies are totally able to one-hit my players with a critical hit and I feel the only reason they survive at all are the mighty resurrection possibilities of the priest (the 3 action heal). I’m looking for advice how to make the adventure more fun by not obviously saving my group but also for other opinion on how difficult that module is.