I think so, Javad Zarif is on every media outlet. I mean, we're not nearly as exposed to it as we are Saudi and Israeli propaganda. But neither the Sauds nor the Israeli's try to appeal to Americans directly.
The Israeli and Saudi game is largely a mirror image of America at a smaller scale -- staying out of the limelight.
i had forgotten about zarif. think there is also an iranian-american professor who is falrly pro-government and has done interviews with the bbc. still i have no idea what name recognition stats are like for these people.
I don't think presstv has seen any real success, I do think Javad has forced a much needed pivot in the Saudi/Iran issue.
The inverse has happened with Saudi Arabia in the past year, fyi. Also from Gallop: 37% favorable to 31% favorable, 55% unfavorable, to 65% unfavorable.
And, that's with all the propaganda about the heir.
the saudis very publicly being close to trump probably hasn't helped their image. or the fact that almost everything they've done in the last 5 years or so has been a disaster
Just saying their immense wealth, massive military, and failed attempts at puppet-mastery are failing in the eyes of every nation. While smooth talkers in sharp suits and direct engagement seem to be working for the likes of Canada of Iran even though neither of those countries is doing anything useful or different except in rhetoric and appearance.
Just seen this. Doesn't matter if you believe in evolution or intelligeet design. Either way, we as a species need culling http://www.bbc.com/news/uk-england-birmingham-42271150
I am using Postgres 9.3.
I have 2 tables : authn_session and customer. Every authn_session belongs to a customer (and hence has a customer_id as a column which is a FK to customer's id).
Note : These tables contain additional FK references to other table(s) and indexes.
Now, I start 2 differe...
I'm trying to set up a test environment for Service Broker communication between 2 SQL Server 2016 SP1 instances. I've created db master keys, certificates and endpoints in the master db for each instance, as in the code listed below. For now my goal is to synchronize data between 2 tables. On th...
On the Service Broker/Log Shipping thing: I'm no expert in either, but it is my impression that both are useful for their intended applications. LS in particular seems to have a solid fanbase. Has it been made effectively redundant by basic AGs or something?
@sp_BlitzErik i like AGs but it's really hard to get everyone to connect to the right name with a driver that supports multisubnetfailover and not do annoying stuff like block DDL on the secondaries
it's a gym day i'm wearing contacts so i don't look like a nerd and get wedgies
@PaulWhite does sql server's optimizer have a fallback algorithm (or a different heuristic/search space) after a certain number of joins are encountered?
As far as I know, SQL Server holds X locks for the duration of a transaction no matter which isolation level is in use. What about the U lock? If a transaction reads 100 records in an UPDATE statement (U locks) but updates 10 records only, will we end up with 90-U and 10-X after the update is don...
I am struggling with this query a lot mainly because of the repetition which possibly could be reduced - hopefully.
The general idea is to display sums of each table for a given month and display it as a pivot table.
Current code is in my opinion very messy and repetitive but the main thing is ...
@gbn one of my favorite things to do was make IP address labels and stick them on things that didn't have IP addresses, like coffee machines and lamps.
bottled water must be rather expensive around there.
@sp_BlitzErik our new electricity meter proudly states a MAC address and a public key fingerprint on itself. It either connects via some wireless solution, or it does not, as there is no network cable to attach.
@gbn By and large I try to avoid internet connected things where I can't reinstall the O/S. Even mobile phones are grudgingly accepted.
@PaulWhite Interesting factoid: Rotorua had a manual exchange up until 1970 because the sulphur compounds in the air would corrode electromechanical ones.
@sp_BlitzErik Remember these are $100 NZ peso bills, which are worth about three fiddy each.
@PaulWhite Lack frequently. I've long since concluded that simplicity has some intrinsic value because it has fewer failure modes.
I have nostalgic fantasies of a world where computer architectures were much simpler. When I were a lad I could go from a standing start to writing assembler code on a BBC micro between christmas and about april or may the following year.
Today, going from no programming experience to writing Win32 system code is not something most folks could do in three or four months.
@gbn's experience with CORAL-66 is similar to a few old greybeard stories I've heard about folks working on minicomputer architectures where they knew what the compiler would emit for given keywords.
Kit like that was simple enough that a reasonably competent programmer could be expected to gain a working knowledge of the whole system. Unix was about the last widely used platform on which you could do that without being Mark Russinovich.
Uphill both ways etc.
@PaulWhite I know the gift for the man who has everything ...
Unless they're trying to prevent gaming the system specifically for a badge, that doesn't matter much. If unregistered dummy users create daft questions and mark the answer as chosen, the answer gets +15 REP.
I'm just sayin yo, getting chosen answers is easier than getting upvotes. And, it seems to be in part because people asking good questions can't upvote. =/
Well, I have any easy solution to that. ;) I've offered it multiple times. Put all questions about SQL on topic here. If a question is tagged with just a sql or an rdbms, prompt the user to see if they want to migrate it to DBA.SE from SO.
It probably instantly double the traffic here and alleviate misplaced questions on SO.
I'd even be for not-prompting the user. It would be dirt simple to infer the kinds of questions that belong here just from the tags provided by the user asking the question.
Usually you pay an upfront cost for an influx of users, and then the community matures and you'd get that help. Problem is now people are growing up with DBA questions on StackOverflow because they're "basic" and on topic there. Got to invest in that borg of reviewers.
> If data alignment is unimportant (either just for a specific function or because the data type specifies byte alignment anyway) then it's possible to avoid some of the overhead of PG_DETOAST_DATUM. You can use PG_DETOAST_DATUM_PACKED instead (customarily hidden by defining a GETARG_DATATYPE_PP macro) and using the macros VARSIZE_ANY_EXHDR and VARDATA_ANY to access a potentially-packed datum. Again, the data returned by these macros is not aligned even if the data type definition specifies an alignment. If the alignment is important you must …
the mobile site really weird. that ui is confusing too.
for instance, if you hit it on the desktop, it's not immediately clear how to get back to the desktop version and it stores the setting in a cookie or something horrible.
The link is on the bottom "full site", and cursor is broken on it.
I am using Postgres 9.3.
I have 2 tables : authn_session and customer. Every authn_session belongs to a customer (and hence has a customer_id as a column which is a FK to customer's id).
Note : These tables contain additional FK references to other table(s) and indexes.
Now, I start 2 differe...
I am struggling with this query a lot mainly because of the repetition which possibly could be reduced - hopefully.
The general idea is to display sums of each table for a given month and display it as a pivot table.
Current code is in my opinion very messy and repetitive but the main thing is ...
