Topics created by baileigh

Unfortunately, Android 10 brought some substantial privacy changes, like the restriction of access to the /proc/net/ filesystem, which contained info about the device's network state. So even if you were to simulate Root access with Termux you wouldn't be able to get the IP of your SSH. As of now, your only option is to get a phone with Android 9 or lower or root your phone.

Just figured it out myself but if you have a wallet phone and a chip card, the NFC is what's triggering wechat to come up. Try turning off NFC and see if it helps.

When filling in the form one enters e-mail address. The app sends a verification code to that e-mail address – without any notice, or submitting the form. Not sure if one have to press the “Apply verification” button (which is after the input) for the e-mail to be sent, but it does not hurt. It also might work differently if one use a mail-account linked to the phone. (As in apply might auto-fill, but I do not know). In my case I had to press that “button”/label for it to send a new verification that worked. I also had some lag on the first almost dozen e-mails which made me going down a rabbit hole. After verification one have to enter WiFi password and also have Bluetooth turned on. Would have to figure out why it need both WiFi and Bluetooth but that is another matter.

I dont think it bothers shearing/using durability if the sheep (or in your case, sheep) doesnt have any wool. In the case of multiple sheep within range of the dispenser, it likely picks at random (among the eligible sheep of course, aka the ones with wool).

There is only one benefit I know. It is ridiculously fast, probably the fastest method of bridging. It's definitely not useless, but I think there are three reasons that most people don't use it. It's really really hard to do. It requires a high cps or really accurate timing and with both, it's easy to miss a block and die. It's risky. I'm not a high-level player, but I think a lot of high-level players have decided that its speed is not fast enough to justify how easy it can be to fall off vs the speed of ninja bridging. It takes a while to start it. I've only seen one person do it, so I could be wrong, but it took him a while to get started bridging because he had to aim at the right spot and get his trigger finger ready, which could make you vulnerable to an attack. Like I said before, I'm not a very good bed wars player, this is just my observation. Imho it's better to practice regular speed bridging (some call it ninja bridging). Even Technoblade who is amazing at bed wars doesn't God bridge (at least to my knowledge) and he seems to be doing fine.

Normally around the coast is fairly safe, but you need to find a spot that's quiet but still has a decent amount of equipment for you to get armed up quickly. And ideally where you can easily find a vehicle too, in case the storm circle ends up far away so you've got transport to save yourself. Some suggestions the house on the coast south of Chonkers Speedway: there's up to five chests there and six slurp barrels for shields (dig through the floor in the garage). There are two road cars there and you can head north to Chonkers to grab a car with off-road tyres if you need it either the house on the hill above Camp Cuddle - up to four chests inside (first one at the very top in the roof) and two just outside, and if someone else lands there you can flee down the hill or the garage just west of Camp Cuddle - less equipment but still a decent amount of potential shields and cars to get away in the dock on the coast north of Logjam; again 4+ chests or any of the islands on the far east of the map, which are normally fairly quiet. The one north of the bay though, north east of the Ruins, probably has most stuff. But you're going to have to learn to fight. Waiting until everyone else has wiped each other out won't work in general, because when you kill someone you get all of their ammo, building materials and the pick of their equipment, so if you end up fighting someone who's been killing other people at the end you'll be heavily outgunned. Yes, they'll be weaker too if you catch them just after a fight but they can heal up pretty quickly so it's only a small window of opportunity. as the storm circles get smaller you often end up stumbling on others as you get into the circle, so you'll end up in combat whether you like it or not just to keep safe. Try landing at Logjam for a few games. It's moderately popular (often 4-5 others will land there too): as long as you can find a chest and grab a weapon quickly you'll have a fighting chance, and there are plenty of chests around once you've learned where. Work out which weapons work well for you at what ranges, and you'll die a few times, but you'll get the hang of it.

As far as I know, no. There's no such option. Not a real solution, but since you are carrying Pokemon with a low Research level your best bet is to sort the list by Research level. Doing that you'll get all Pokemon with the incomplete Dex page at the top.

According to Reddit, you need to upgrade the Blacksmith to the second stage in order to get the dog. This means beating the Arch-Illager for the first time. I did it and the dog is there.

Turns out these items are used as defaults for all Valorplates. To actually salvage them you will need to unlock all Valorplates first and then unequip these items.

Unfortunately, it's not possibile. See https://www.reddit.com/r/PS4/comments/62u0x2/helptransferring_game_data_between_accounts/ and https://www.reddit.com/r/PS4/comments/8yckxw/saved_data_transfer_between_different_psn_accounts/ . This could be due to trophies being linked to them.

I cannot say for certain if it works with Animal Crossing however, I was in a similar situation for Pokemon Sword and Shield (please see my answer here for a similar question but for Pokemon: https://gaming.stackexchange.com/questions/362618/are-the-pok%c3%a9mon-sword-and-shield-expansion-version-exclusive/371702#371702 ) Basically, I bought the Expansion for both Sword and Shield on one account. My switch has 3 profiles. Every profile could play the expansion on both games, even though it was only bought with the primary. I would be very surprised if it works differently for Animal Crossing as I feel like this wouldn't be a per game restriction and would be a per device restriction. However, as you said that you play it with the digital version on the second account, it may not actually work, as my experience has been with either everyone using the same phycial version or everyone using the same digital version, not a mixture of both. I sadly cannot test that for you as I am not going to rebuy either Sword or Shield. Extra Speculation, not guaranteed to be true: If it helps, I have had some experience with a modded switch and the ID of the game is not different depending on if it is a digital version or a physical version, so that may mean the DLC will work with both. But please do note, this part is pure speculation.

In most cases, the bipod should deploy automatically, but when I use the bipod, it sometimes doesn't deploy properly (I'm assuming it's a bug.) After several attempts, I was able to confirm that the bipod deploys just like any other underbarrel attachment (such as laser sight, flashlight, GL, Masterkey), by pressing the key to use the attachment. If you're on console(PS4/5, Xbox), hold down(↓) on your D-pad. If you're on PC, just simply hit X on your keyboard.

This depends a lot on your company. As you say, it's not technically advanced, and as such solutions that depend on technical changes may be somewhat hard to implement. Stable storage format I would start in your own area and devise a scheme in which you organize the collected data. As a software developer, I'm always inclined to develop an automatic solution, but you're probably better off with a manual process that you follow reliably. This may be as simple as having Excel files organized in folders by reporting period. The key is that you don't change the format and process too often, so you get familiar with it, and maintaining the data becomes fluent over time. Automated collection For the data that currently needs to be collected using e-mail, I would try to meet with the people who have access to that data to find ways of automatically extracting it. If it's in databases, something like a scheduled script to perform some SQL and send you the results might be enough. Setting up the first of such scripts will likely be a bit of work and will require the assistance of knowledgeable colleagues. The work will become easier once you have done it for one or two data sources, as you then know whom to ask and how to best format the data. More automation - maybe, maybe not You might be tempted to add more automation so that data collected from the different sources is automatically consolidated. I would not plan for that until you have sufficient experience with manually performing the process, so you really know what works and should be automated. However, you should also consider that part of data collection is quality control, and it might be better to keep the manual consolidation step as you are able to see data inconsistencies early. Putting such checks into code is possible but harder than you might think, and probably not worth it, depending on the volume of data.

TL;DR You have mixed some concepts. As Stanislav has written; there are two approaches. Predictive and Adaptive Within Adaptive you may find both incremental and iterative which are distinct from each other. However, it is highly likely that Incremental is also found within Predictive models. How Does That Work? Increments are pre-defined packages of functionality that build on the previous increment. They are planned and part of a larger architecture. We will add VISA, then Mastercard, then PayPal then... Ultimately they make something bigger. So we can have a Predictive Model that has incremental delivery. An iteration is a defined package of work that is responding to feedback and may take the architecture/organisation/service in completely unknown directions because satisfying a user makes sense. We will allow users to use one type of payment and then ask users what payment types are missing and analyse that in line with market research... We can have an Adaptive Model that may have Iteration and in doing so it will also increment the product or service. Ultimately iteration makes something better, not necessarily bigger. We may change it completely. Wider Breakdown Incremental As an analogy, we build modern bridges using an Predictive Model in an incremental way. We conceptualise the bridge for feasibility then we build a model but crucially, once the full delivery begins we add 1 section of a bridge at a time until you have a bridge. Like this. An incremental approach in software engineering is the same. You build section by section, or component by component or feature by feature until your vision (largely defined at the start) is complete. Iterative An Adaptive Model using an iterative approach is looking at an obstruction and thinking how could we get across this? You might start with a simple path down either bank and wading through the water. Users are unhappy and it does not work in winter. A user may ask to transport goods so you iterate a design that includes a small gondola ferry. Another user explains they need the ability to go backwards whilst another user goes forward so you replace the ferry with a log bridge. Automobiles are invented and you need to respond to weight capacity so you strengthen the bridge but sediment flow within the water dictates wood is no longer suitable so you decide to close the bridge and rebuild it with modern techniques. Financial considerations dictate you have to charge a toll but traffic declines so you respond with toll charges only one-way.... At no point did you start the process deciding a concrete, three-pylon, toll-booth bridge was the solution. You started with solving a customer problem of getting from one side to the other. You iterated to the most suitable solution that customers, stakeholders, market conditions, technology and your own ingenuity would allow. Other Considerations Both techniques may or may not have plans and those plans may or not be effective Iteration requires a commitment to responding to change even if that change comes very late in the build (that can be hard to take for developers, it means being happy you did not build it fully rather than being unhappy your work was wasted) Incremental design does not require as much respond to change since you can theoretically plan all of your increments up front depending on how confident you are Late changes to an incremental design can be damaging if the architecture cannot absorb the changes A large product or service may have a mix of incremental AND iterative design (for instance a component or feature may be iterated within a larger incremental design) Iterative ideas are crucial to Agile but you can both increment and iterate without subscribing to the wider Agile Manifesto or any specific framework. Historical Reasoning Lastly, to know the genesis of incremental design is to understand computing. In the 60s-80s, production environments were highly expensive and entry to production was queued. In turn, this meant testing was expensive and also queued. So, the impact was that a potential mistake in your design was very costly. It made sense to gather as many requirements as possible up front and try and fix (or baseline) those requirements in collaboration with a customer before you ever committed a line of code. The baseline would be communicated and everyone would expect that to be delivered. The disadvantage was that changing the baseline required approval and not everyone was empowered to do so and governance would be involved... In the modern era, we can literally spin up testing resources and higher environments for pennies. We can solve problems quickly and there are likely frameworks or packages we can take from the community. The penalty for a mistake in modern software engineering is much lower so we can allow ourselves the freedom to build things quickly and let the user feedback drive what we do next. Do we fix A or improve B or add C or make D more performance etc. However, there are still organisations that struggle with that (for a variety of reasons) and the Agile Manifesto was an attempt to encourage greater ability to respond quickly to feedback. As of 2021 we now have hundreds of documented patterns for how we respond to feedback and incorporate iteration into a workflow. Some patterns rely on management agreeing to cede power to the development team. In that regard, iteration may fail based on a variety of creative, cultural, organisational or knowledge barriers. MVP Addendum The Minimum Viable Product is closely tied to iteration but it is a widely misunderstood concept in engineering and within Agile. Largely because most Agile practitioners have little experience in startups; most worked in scaled organisations. It is best to divorce your learnings about iteration from MVP however once you are ready you can understand the MVP concept with a careful reading of the blogs of Marty Cagan.

I'm going to answer this question a different way. When we're talking about database servers, the data within said databases is typically far more valuable than anything sitting on the file system. Database servers can be brought back online, databases can be restored from backups, etc... Not to diminish the fact that a user with OS access can wreck havoc and take a database offline. I'd be far more concerned what a malicious user would do to a database with write permission. They can manipulate data, delete data, insert bad data, etc. If a user is truly wanting to be malicious, this is all the access the would need to be destructive. Depending how aggressive they are, data changes could go undetected for weeks or months, making the chance of recovery challenging. So in this case, what are you trying to protect against? Preventing a trusted database users from making accidentally changes at the OS level? Making sure the scope of a malicious user is limited?

Given data: DECLARE @Table1 table ( TeacherID integer NOT NULL, ImageName varchar(20) NOT NULL ); DECLARE @Table2 table ( TeacherID integer NOT NULL, ImageName varchar(20) NOT NULL ); INSERT @Table1 (TeacherID, ImageName) VALUES (341, '10.jpeg'), (341, '20.jpeg'), (341, '30.jpeg'), (734, '40.jpeg'), (734, '50.jpeg'), (734, '60.jpeg'); INSERT @Table2 (TeacherID, ImageName) VALUES (341, '1.jpeg'), (341, '2.jpeg'), (734, '3.jpeg'), (734, '4.jpeg'); The basic idea is: WITH CombinedData AS ( -- Get data from both sources SELECT T1.TeacherID, T1.ImageName FROM @Table1 AS T1 UNION ALL SELECT T2.TeacherID, T2.ImageName FROM @Table2 AS T2 ), ImageNumbers AS ( -- Extract just the numbers from the ImageName -- for ordering purposes next SELECT CD.TeacherID, CD.ImageName, ImageNumber = CONVERT(integer, REPLACE(CD.ImageName, '.jpeg', '')) FROM CombinedData AS CD ), NumberedRows AS ( -- Number the rows for each TeacherID -- in ImageNumber order -- These will be column numbers after the pivot SELECT I.TeacherID, I.ImageName, RowNum = ROW_NUMBER() OVER ( PARTITION BY I.TeacherID ORDER BY I.ImageNumber) FROM ImageNumbers AS I ) -- Pivot the data SELECT P.TeacherID, Image1 = P.[1], Image2 = P.[2], Image3 = P.[3], Image4 = P.[4], Image5 = P.[5] FROM NumberedRows PIVOT ( MAX(ImageName) FOR RowNum IN ([1], [2], [3], [4], [5]) ) AS P; Results: TeacherID Image1 Image2 Image3 Image4 Image5 341 1.jpeg 2.jpeg 10.jpeg 20.jpeg 30.jpeg 734 3.jpeg 4.jpeg 40.jpeg 50.jpeg 60.jpeg https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=8f13a1d6fcc49e56e1ef8dcd800639c5 If you need a dynamic pivot because you don't know in advance how many columns there will be, see: https://dba.stackexchange.com/q/63698/1192 https://dba.stackexchange.com/q/31760/1192

They don't. I've tested this. Create a database and enable query store. CREATE DATABASE QueryStoreTest GO USE QueryStoreTest; GO ALTER DATABASE QueryStoreTest SET QUERY_STORE = ON ( OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = ( STALE_QUERY_THRESHOLD_DAYS = 1 ), DATA_FLUSH_INTERVAL_SECONDS = 900, MAX_STORAGE_SIZE_MB = 50, INTERVAL_LENGTH_MINUTES = 60, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 10, WAIT_STATS_CAPTURE_MODE = ON, QUERY_CAPTURE_MODE = ALL /* this is required for the testing */ ); GO Create and run a time-consuming query. I've used this one: SELECT * FROM sys.all_columns AS ac CROSS JOIN sys.all_parameters AS ap CROSS JOIN sys.all_objects AS ao Run the query to completion or stop the execution in the SSMS, and the query can be found in the query store. SELECT qsq.query_id , qsq.query_hash , qsp.plan_id , qsqt.query_sql_text , qsrs.count_executions , qsrs.execution_type_desc FROM sys.query_store_query AS qsq LEFT JOIN sys.query_store_plan AS qsp ON qsp.query_id = qsq.query_id LEFT JOIN sys.query_store_query_text AS qsqt ON qsqt.query_text_id = qsq.query_text_id JOIN sys.query_store_runtime_stats AS qsrs ON qsrs.plan_id = qsp.plan_id WHERE qsqt.query_sql_text LIKE '%cross join%' AND qsqt.query_sql_text NOT LIKE '%query_store%' The execution type is either Regular or Aborted. But if you kill the session from another window, there is neither increase in the count_executions nor a new record.

Unless I am missing a business requirement, or a detail in your code, I think you're making your procedure a whole lot more complicated than necessary. There's not a need to create the table, then look up the name of the table, then rename the table, then add the primary key constraint all as separate steps, wrapped in a transaction to ensure consistency. Instead you can do it all in one step. A few other code-review type notes on your code: You are using a nvarchar variables to support unicode, but doing the assignment using "regular" single quotes. To support unicode strings, you'll need to use the N' prefix to quote unicode strings. There is an inline constraint creation that is possible for CREATE TABLE https://sqlblog.org/2019/09/12/bad-habits-to-kick-avoiding-the-schema-prefix , including using the sys schema prefix on sp_executesql. Never rely on the ordinal position of a stored procedure. Explicitly name the parameters as you pass them. Most developers (including Microsoft for system stored procedures) avoid changing the position of parameters--but if they do, it will break your code if you assume the position. Named parameters never has that problem. Here's my version of your procedure: CREATE OR ALTER PROCEDURE [lake].[create_terminal_raw_log_table] ( @terminal_name nvarchar(100) ) WITH EXECUTE AS 'dbo' AS DECLARE @table_name nvarchar(128); DECLARE @dynamic_sql nvarchar(1000); -- We want the table name to be the input value with `_raw_log` appended: -- I could skip even using this variable, -- and just use `@terminal_name + N'_raw_log'` -- in the two spots I reference @table_name -- but if you use the table name a bunch of times, -- this is easier. SET @table_name = @terminal_name + N'_raw_log'; --Use dynamic SQL to create the table --With the PK Constraint created in-line. SET @dynamic_sql = N'create table [lake].' + QUOTENAME(@table_name) + N' ( id bigint not null, [timestamp] datetime2(3) not null, cmd varbinary(max) not null, CONSTRAINT ' + QUOTENAME(N'PK_' + @table_name) + N' PRIMARY KEY CLUSTERED (id) );'; EXEC sys.sp_executesql @stmt = @dynamic_sql; GO Make sure you test! You'll want to do some quick sanity tests to make sure that your procedure actually works. I like to make sure that I test with unicode characters (I always use emojis), and any other specific concerns (like SQL injection, white space in object names, min or max length, etc). For example: EXEC [lake].[create_terminal_raw_log_table] @terminal_name = N'nds'; EXEC [lake].[create_terminal_raw_log_table] @terminal_name = N'amtwo'; EXEC [lake].[create_terminal_raw_log_table] @terminal_name = N'; DROP PROCEDURE [lake].[create_terminal_raw_log_table];'; EXEC [lake].[create_terminal_raw_log_table] @terminal_name = N'It Works!! '; SELECT TableName = o.[name] FROM sys.objects AS o JOIN sys.schemas AS s ON s.schema_id = o.schema_id WHERE s.name = N'lake' AND o.type = 'U'; Returns these results: TableName ------------------------------------------------------------------- nds_raw_log amtwo_raw_log ; DROP PROCEDURE [lake].[create_terminal_raw_log_table];_raw_log It Works!! _raw_log (4 rows affected)

The following commented code does what you need: SELECT D.DescriptionId, [CreatedAt(Description)] = D.CreatedAt, T.ThreadId, [CreatedAt(Thread)] = T.CreatedAt FROM ( -- Find next CreatedAt date SELECT D.*, NextCreatedAt = LEAD(D.CreatedAt, 1, D.CreatedAt) OVER ( PARTITION BY D.AssessmentId ORDER BY D.CreatedAt) FROM dbo.Descriptions AS D ) AS D CROSS APPLY ( -- State match SELECT TOP (1) T.* FROM dbo.Threads AS T WHERE T.AssessmentId = D.AssessmentId AND D.[State] = 1 AND T.[State] = 1 -- Or UNION ALL -- No State match SELECT TOP (1) T.* FROM dbo.Threads AS T WHERE T.AssessmentId = D.AssessmentId AND D.[State] = 0 AND T.CreatedAt > D.CreatedAt AND T.CreatedAt < D.NextCreatedAt ORDER BY T.CreatedAt DESC ) AS T; DescriptionId CreatedAt(Description) ThreadId CreatedAt(Thread) 56 2022-02-06 15:09:49.500 67 2022-02-06 15:10:18.657 68 2022-02-06 15:11:14.167 70 2022-02-06 15:11:27.263 71 2022-02-06 15:12:03.780 70 2022-02-06 15:11:27.263 https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=a6faabd4778443ae8593176714dfb102

I would follow this path: Generate dacpac from the root database if you don't have already a dacpac as update. Generate a scirpt of https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage?view=sql-server-ver15 commands using that dacpac as source, having one command for each target database. Execute those commands. In this way you can create a dacpac from your root database: sqlpackage.exe /action:extract /targetservername:server_name /targetdatabasename:root_database_name /targetfile:"\root_database_name.dacpac" then you have to apply it to each database you need. To apply a dacpac to a database you have to use this command \SqlPackage.exe /Action:Publish /SourceFile:"\root_database_name.dacpac" /TargetDatabaseName:db_name /TargetServerName:server_name You should have a a way to select all database you have to applay that dacpac select name from sys.databases where name like 'mydb%' -- or another filter you have so if you puth all together, you can do something like this: select '\SqlPackage.exe /Action:Publish /SourceFile:"\root_database_name.dacpac" /TargetDatabaseName:' + name +' /TargetServerName:server_name' from sys.databases where name like 'mydb%' In the query output you will have all the commands needed. This is an easy option. Probably there are better... Hope to be of help.