Dos Batch File – Special Characters

Background

If you end up having special characters as in the case of nice passwords and also needing to use delayed expansions in your batch file, you might have to escape those passwords.

Batch File

Deploy


@echo off

if not exist log mkdir log

SETLOCAL DISABLEDELAYEDEXPANSION

set "_errorlevelSaved="

REM Batch files - number of command line arguments ( nimrodm )
rem https://stackoverflow.com/questions/1291941/batch-files-number-of-command-line-arguments

set argC=0

for %%x in (%*) do Set /A argC+=1

echo Argument Count is %argC%

set "_app=sqlcmd.exe"

set _dbHost=%1

IF NOT "%2"=="" set "_dbUsername=%2"

IF NOT "%3"=="" set "_dbPassword=%3"

set "_appOption=-S %_dbHost% -b "

IF NOT "%_dbUsername%"=="" set "_appOption=%_appOption% -U%_dbUsername% "

IF NOT "%_dbPassword%"=="" set _appOption=%_appOption% -P"%_dbPassword%"

set "_filename=modules.txt"

echo appOption is %_appOption%

rem goto skipped

SETLOCAL ENABLEDELAYEDEXPANSION

set _fileCount=0

for /f "tokens=1,2 delims=," %%a in ('type %_filename%') do (

	set /A _fileCount+=1

	set _folder=%%a

	set _file=%%b

	set "_fileFull=!_folder!\!_file!"

	echo Processsing file !_fileCount!  - !_fileFull!

	%_app% %_appOption% -i !_fileFull!	

	set "_errorlevelSaved=%errorlevel%"

	rem echo _errorlevelSaved is %_errorlevelSaved%

	IF NOT _errorlevelSaved NEQ 0 GOTO exception

)

:skipped

goto completed

:exception

echo "Error Level %_errorlevelSaved%"

:completed

SETLOCAL DISABLEDELAYEDEXPANSION

endlocal

Invoke

Outline

  1. Server Name :- 118.90.10.1
  2. User :- dadeniji
  3. Password :- paul.winters

Actual Invocation


deploy 118.90.10.1 john paul.winters

Output

Output – Textual

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'dadeniji'..

Output – Image

sqlcmd.specialCharacters.inbatchfile.(dadeniji)20181209.0700AM

 

Workaround

In our case we have special characters in our password and we are getting failed logins, and so we have to escape each special character.

Outline

In this sample we escaped the period in our password.

  1. The actual password is paul.winters.
  2. The only character that needs to be escaped is the period.
  3. And, so we ended up with paul^.winters.

 

Actual Invocation


deploy 118.90.10.1 john paul^.winters

Output

sqlcmd.specialCharacters.inbatchfile.(john.smith)20181209.0707AM

Dedicated

Dedicating to Rob van der Woude’s.

Rob van der Woude’s Scripting Pages
Escape Characters
Link

SQL Server – Installation on Linux/CentOS

Background

Let us install SQL Server v2017 on our CentOS System.

Installation

Outline

  1. Repositories
    • Review registered Repositories
    • Add missing Repositories
  2. MS SQL Server Engine
    • Install
    • Configure
  3. Services
    • Service Review
  4. Adjust Network Firewall Rules
  5. Validate

Repositories

Review Registered Repositories

yum repolist

Syntax

yum repolist

Output

yum.repolist.20181126.0831PM.PNG

Explanation

We do not see the repositories that we need :-

  1. Repositories
    • packages-microsoft-com-mssql-server-2017

 

yum repository – add

Sample
Sample – Add SQL Server RTM

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017-gdr.repo

 

Sample – Add Cumulative Patch

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

 

Review Registered Repositories

yum repolist

Syntax

yum repolist

Output

yum.repolist.post.20181126.1034PM

Explanation
  1. Repositories
    • packages-microsoft-com-mssql-server-2017

 

Install

Install SQL Server Engine

Syntax

yum install -y mssql-server

Output

install.20181126.0859PM.PNG

 

Configuration

License

Syntax

sudo /opt/mssql/bin/mssql-conf setup
Output

sudo-ms-config-20181126-0914PM.PNG

 

Explanation
  1. Licensing
    • Developer
  2. sa password
    • Enter and Confirm sa password

Services

Review Services :- mssql-server

Syntax

systemctl status [service]
Sample

systemctl status mssql-server

Output

systemctl.20181126.0917PM.PNG

Explanation
  1. Service is running

Firewall

iptables

Our Firewall Software is iptables.

Port TCP/1433 ( mssql-server )

/etc/sysconfig
Outline
  1. Using an editor load /etc/sysconfig/iptables
  2. Add Entry for TCP/port 1433
    • -A INPUT -p tcp -m state –state NEW -m tcp –dport 1433 -j ACCEPT
Image – Pre

firewall.etc.sysconfig.pre.20181126.0942PM.PNG

Image – Post

firewall.etc.sysconfig.post.20181126.1052PM

Reload
Syntax

sudo systemctl reload iptables

Validation

SQL Query

@@version

Syntax

select @@version

Output

@@version.20181126.1110PM

 

References

  1. CentOS.Org
  2.  DigitalOcean
    • Mitchell Anicas
      • How To List and Delete Iptables Firewall Rules
        Link
  3. Sharad Chhetri
    • How to start / stop / restart / reload iptables on CentOS 7 / RHEL 7
      Link

 

 

Recycle Bin Emptying Using Powershell

Background

One might find that the Recycle Bin is taking up a good chuck of storage.

Remediation

Powershell

Let us use Powershell to dump our recycle bins.

Cmdlet :- Clear-RecycleBin

Syntax

Here is the Syntax

Clear-RecycleBin-Syntax

Sample

All Drives
Script
Clear-RecycleBin  -Force
Output

force.20181124.1008AM.PNG

Drive Letters Specified
Script
Clear-RecycleBin  -DriveLetter "C", "D","E"
Output

foldersSpecified.20181124.0950AM.PNG

Confirm
Confirm – True
Script
Clear-RecycleBin  -Confirm:$true
Output

confirmTrue.20181124.0955AM

Explanation
  1. Prompted
Confirm – False
Script
Clear-RecycleBin  -Confirm:$false
Output

confirmFalse.20181124.0957AM.PNG

Explanation
  1. Not Prompted

Errors

Error :- Clear-RecycleBin : The system cannot find the file specified
Sample

Clear-RecycleBin -Confirm:$false -DriveLetter "C", "D","E"

Output – Image

error.cannotFindtheFileSpecified.20181124.1030AM

Output – Textual

Clear-RecycleBin : The system cannot find the file specified
At line:1 char:1
+ Clear-RecycleBin -Confirm:$false -DriveLetter "C", "D","E"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (RecycleBin:String) [Clear-RecycleBin], Win32Exception
+ FullyQualifiedErrorId : FailedToClearRecycleBin,Microsoft.PowerShell.Commands.ClearRecycleBinCommand

Overlook

Try to use “-ErrorAction SilentlyContinue


Clear-RecycleBin -Confirm:$false -DriveLetter "C", "D","E"  -ErrorAction SilentlyContinue

Dedicated

Dedicated to Gee Law

Gee Law

Blog Posts & Git Hub Issues

  1. GeeLaw.blog
    • PowerShell codebase misuses SHEmptyRecycleBin function in Clear-RecycleBin cmdlet
      Link
  2. GitHub
    • PowerShell
      • Misuse of `SHEmptyRecycleBin` in `Clear-RecycleBin` cmdlet #6743Link

Sidenotes

Link
Sidenote
 I wish Raymond Chen could write a blog entry on SHEmptyRecycleBin if there’s something interesting to add. He’s an expert of Windows shell programming. However, his suggestion box is currently closed and there’s no prescribed way to make a suggestion (though I could have sent him an email, but that would be too impolite), so I can only make wishes.

MS Windows – List Groups a user belongs to

Background

Let us use built-in tools to review our Active Directory group memberships.

Outline

  1. whoami
    • whoami /groups
  2. dsquery
    • dsquery | dsget

Machine

whoami

whoami – List Local Groups

Script

whoami /groups /fo csv | find /V "%USERDOMAIN%\" | more

Output

whoami – List Domain Groups

Script

whoami /groups /fo csv | find "%USERDOMAIN%\" | more

 

Domain

dsquery

dsquery | dsget

Script

dsquery user -samid %username% | dsget user -memberof

Output

dsquery_dsget_20170929_0400pm.png

References

  1. whoami
    • Command Line Reference
      Link
    • John Savill
      • How can I determine which groups I’m a member of for my current logon session?
        Link
  2. dsquery // dsget
    • ss64.com
      • DSQuery user (installable option either via RSAT /AD DS or adminpack.msi)
        Link
      • StackExchange
        • superuser.com
          • Using the “net user” command in Windows XP to list all group memberships for a specific Active Directory user
            Link

SQL Server – Integration Services Catalog – Standard Reports – Execution Logs – Permission

Background

One of the managers in our Development group opened up a Ticket last night.

Ticket

The ticket read “Database: sql_server – Issue with table refresh to dev SQL database“.

1 – Daniel Response

As a “smart aleck”, I replied :-

Can you please use SQL Server Management Studio to troubleshoot.
I think as a senior member we gave you ample permissions to troubleshoot.
You want to look at the following:

A) SQL Server Agent
B) SQL Server SSIS Catalog
C) File System Log Folder & Files

If you get permission issue, please let us know and I will create a task and grant you additional permissions.

2 – Manager Response

Daniel,

I have looked at some of this stuff and have not been able to determine what the problem is. It could be that I just don’t know what to look at.

I will reach out the developer to see if she can help me. Please keep this ticket open in case I need to ask for some guidance/assistance from you.

Thanks,
Manager

Issue

Report

Image

report_empty.201816.0102PM.png

Observation

Let us see why she all tallies are coming up zero.

And, all no detail records.

Trouble Shooting

Integration Services Catalogs

Outline

Let use review SSISDB folder permissions for our principal.

Catalog

Catalog – SSISDB

Folder Permissions
Image

folderPermissions.20181116.1107AM.PNG

Explanation

Principal has Read and Read Objects permissions.

Though she has read objects permissions it does not seem to be sufficient.

Remediation

Grant additional permission

In MS SQL Servers v2016 and above, we can grant ssis_logreader role membership to the principal.

Krishnakumar Rukmangathan
Link

The SSIS upgrade to the SSIS 2016 can be an option here. SSIS 2016 brought a new role in the SSISDB, This new ssis_logreader database-level role that you can be used to grant permissions to access the views that contain logging output to users who aren’t administrators.

Ref: Link

Change Code

Outline

  1. SSISDB Database
    • Create new database role
    • Add principals to created database role
    • Alter Code to check role membership

Processing

Create new role

SQL

USE [SSISDB]
GO

if not exists
    (

        select *

        from   sys.database_principals tblSDP

        where  tblSDP.[name] = 'ssis_logreader'
    )
begin

    print 'Create Role - ssis_logreader ...'

    CREATE ROLE [ssis_logreader]
        authorization [dbo];

    print 'Created Role - ssis_logreader '		

end
GO

Add Members to new role

SQL
Syntax

USE [SSISDB]
GO

ALTER ROLE [role]
    ADD MEMBER [principal]
GO

Sample

USE [SSISDB]
GO

ALTER ROLE [ssis_logreader]
    ADD MEMBER [LABDC\psmith]
GO

Amend Code

Outline
  1. Amend the following views
    • Database :- SSISDB
      • Views
        • catalog.event_messages
        • catalog.executions
      • Code original
        • Database Role Membership
          • ssis_admin
            • IS_MEMBER(‘ssis_admin’)
        •  SQL Server Role Member
          • sysadmin
            • IS_SRVROLEMEMBER(‘sysadmin’)
[catalog].[event_messages]
SQL
USE [SSISDB]
GO

ALTER VIEW [catalog].[event_messages]
AS
SELECT     opmsg.[operation_message_id] as [event_message_id],
           opmsg.[operation_id],
           opmsg.[message_time],
           opmsg.[message_type],
           opmsg.[message_source_type],
           opmsg.[message],
           opmsg.[extended_info_id],
           eventmsg.[package_name],
           eventmsg.[event_name],

           message_source_name =
                      CASE
                        WHEN (opmsg.message_source_type = 10) THEN 'ISServerExec'
                        WHEN (opmsg.message_source_type = 20) THEN 'Transact-SQL stored procedure'
                        ELSE eventmsg.message_source_name
                    END,
           eventmsg.[message_source_id],
           eventmsg.[subcomponent_name],
           eventmsg.[package_path],
           eventmsg.[execution_path],
           eventmsg.[threadID],
           eventmsg.[message_code]
FROM       [internal].[operation_messages] opmsg LEFT JOIN [internal].[event_messages] eventmsg
           ON opmsg.[operation_message_id] = eventmsg.[event_message_id]
WHERE     (

                opmsg.[operation_id] in
                (
                    SELECT [id] FROM [internal].[current_user_readable_operations]
                )

                OR (IS_MEMBER('ssis_admin') = 1)

                OR (IS_SRVROLEMEMBER('sysadmin') = 1)

               -- Added on 2018-11-16 11:47 AM
               OR (IS_MEMBER('ssis_logreader') = 1)

           )
GO

[catalog].[event_messages]
SQL

USE [SSISDB]
GO

ALTER VIEW [catalog].[executions]
AS
SELECT     execs.[execution_id],
           execs.[folder_name],
           execs.[project_name],
           execs.[package_name],
           execs.[reference_id],
           execs.[reference_type],
           execs.[environment_folder_name],
           execs.[environment_name],
           execs.[project_lsn],
           execs.[executed_as_sid],
           execs.[executed_as_name],
           execs.[use32bitruntime],
           opers.[operation_type],
           opers.[created_time],
           opers.[object_type],
           opers.[object_id],
           opers.[status],
           opers.[start_time],
           opers.[end_time],
           opers.[caller_sid],
           opers.[caller_name],
           opers.[process_id],
           opers.[stopped_by_sid],
           opers.[stopped_by_name],
           opers.[operation_guid] as [dump_id],
           opers.[server_name],
           opers.[machine_name],
           ossysinfos.[total_physical_memory_kb],
           ossysinfos.[available_physical_memory_kb],
           ossysinfos.[total_page_file_kb],
           ossysinfos.[available_page_file_kb],
           ossysinfos.[cpu_count]
FROM       [internal].[executions] execs INNER JOIN [internal].[operations] opers
           ON execs.[execution_id]= opers.[operation_id]
           LEFT JOIN [internal].[operation_os_sys_info] ossysinfos
           ON ossysinfos.[operation_id]= execs.[execution_id]
WHERE      (
                opers.[operation_id] in
                        (
                           SELECT id
                           FROM [internal].[current_user_readable_operations]
                        )

                OR (IS_MEMBER('ssis_admin') = 1)

                OR (IS_SRVROLEMEMBER('sysadmin') = 1)

               -- Added on 2018-11-16 11:51 AM
                OR (IS_MEMBER('ssis_logreader') = 1)

            )

GO

Validation

Once the changes outlined above are done, one can validate by taken upon the user of the user and try to access the view.

SQL


EXECUTE AS LOGIN = 'LAB\dog';

     select top 100 *
     from [catalog].[executions]
     order by
          1 desc

revert

Output

Output – No Access

executeAs.noAccess.20181116.1247PM.PNG

Output – Sufficient Access

executeAs.sufficientAccess.20181116.1250PM

 

Summary

Revising Microsoft’s code should not be not taken lightly.

But, I think in this case there is a bit of justification.

Those are :-

  1. There is no error message when the user tries to access the reports.
    • The report skeleton is still present
    • It is just that records are filtered out
  2. Other remediation choices such as granting membership in ssis-admin ( database role ) and sysadmin ( Sql Instance Role) are more high bar

References

  1. Microsoft
    • Microsoft Developer
      • SQL BI / Data Access Technologies
        ( SSIS, SSRS, SSAS, Data Access, POWER BI, PBI RS, Azure AS, SSMA, LINQ, System.Data … )

        • How a non-Admin users of SSIS 2012/2014 can view SSIS Execution Reports
          Link
  2. SQL Server Central
    • Home»SQL Server 2012»SQL 2012 – General»SSIS Execution Reports Permission
      • SSIS Execution Reports Permission
        Link

Who is holding T-Bills

Backdrop

Let us use “Mihir Sharma’s Isolating Saudi Arabia Will Be Harder Than It Looks” poem as our backdrop.

  1. At the same time, however, it’s risky to keep cutting bits out of the global financial system and expecting it to survive. Russian sanctions strained it. Iranian sanctions might break the SWIFT system unless Europe and America can agree on a path forward. Any attempt to isolate Saudi Arabia could be the last straw. Already there are mutters in the Gulf about “alternate” ways to ensure the flow of finance, especially if the Magnitsky Act is invoked.
  2. Integrating global finance has been a real achievement of the past century. The question now is whether the world is willing to take the risk of balkanizing it.

T-Bills Holding

Graphs

Statistica Portal

Government Finances – Who’s Holding U.S. Government Debt

Link

whoIsHoldingUSGovernmentDebt_20181103_0913AM

 

Who is selling?

  1. Russia
    • 2018-March Thru May
      • Between March and May, Russia’s holdings of US Treasury bonds plummeted by $81 billion, representing 84% of its total US debt holdings.
  2. Turkey
    • 2018-1st Half
      • Turkish Central Bank sells off half of US government bonds in 6 months ( Link )
        • Turkey’s holdings of U.S. bonds, bills and notes have fallen 45.24 percent in the first half of this year, dropping to $28.8 billion in June with a selloff worth $23.8 billion, according to a U.S. Treasury Department report released Wednesday.
        • The U.S. Treasury has a floor of $30 billion to be classified as a major holder.
        • At the end of December 2017, Turkey was reported to hold U.S. Treasury bonds worth $52.6 billion.
  3. Japan
    • Schiff Gold
      • Who Is Buying US Treasuries ( Link )
        • The Japanese rank as the second-largest holder of US Treasuries, but they’ve been systematically selling. Over the past six months, the Japanese have shed $63 billion in US debt. Since July 2016, they have reduced Treasury holdings by $123 billion.

 

Graphs

Russia

US Treasury Holdings By Russia

US-treasury-holdings-Russia-2018-04

 

Who is buying

  1. Ireland
    • It’s no surprise that economic juggernauts China and Japan keep swapping places at the top of the list of biggest U.S. creditors. What might strike observers as odd, however, is that tiny Ireland has been lurking at No. 3 for more than a year.
    • The country holds more than $310 billion in U.S. government paper, according to the Treasury International Capital, or TIC, report released on Monday.
    • But Ireland’s ranking is puzzling given that economic heavyweights with deeper financial markets, including the United Kingdom and Germany, keep less Treasurys on their books than an arguably peripheral member of the eurozone. Ireland does not have Japan’s massive pension fund and life insurance companies that need to buy long-dated government debt to match their lengthy liabilities. Nor does it have China’s exporters, whose rapid growth has enabled the country to accumulate its hoard of foreign-exchange reserves.
    • Investors and analysts suspect Ireland appears as one of the U.S.’s largest creditors on paper because Google parent Alphabet and other American corporations like to hold their overseas profits in highly liquid Treasurys. These cash-rich firms want to avoid the 35% repatriation tax, but they don’t want to let the foreign-earned cash sit idly by.
    • “There might be some correlation because U.S. corporations with European subsidiaries tend to hold most of their offshore corporate cash in Ireland and Luxembourg. Those are the two main places where they have their offshore cash,” said Lance Pan, director of investment research at Capital Advisors Group, which manages money for American firms.
    • As a country that offers a combination of low corporate taxes and an English-speaking workforce, it’s little surprise Ireland is now the country of choice for many U.S. companies looking for a launching pad for European operations. It currently hosts the European headquarters of Google, Facebook, Apple, and Microsoft
    • The four firms including Amazon which has located its main office in Luxembourg, hold more than $200 billion worth of government paper, according to their corporate filings.
    • Microsoft and Apple alone added more than $80 billion of U.S. government paper in the past five years, doubling the previous amount. At the same time, Ireland’s holdings have grown at a similar pace, rising $200 billion since 2012.
    • Most of the sovereign paper in the country is placed in so-called custodial accounts. But the Treasury Department does not differentiate the composition and identity of the actual owners, and simply categorizes by nationality—in other words, central banks are lumped with private money managers.
  2. American institutional and individual investors
    • Who Is Buying US Treasuries
      • According to Wolf Street, “Mostly American institutional and individual investors, directly and indirectly, through bond funds, pension funds, and other ways.”
      • The question is how much of the load can these investors absorb? And how high will interest rates have to climb in order to keep them buying? Keep in mind, rising interest rates don’t just impact bond yields. On the flip-side, debtors are paying more to service their debts. That means leveraged companies and consumers with massive credit card balances. That’s not good news in a world drowning in debt.

 

US Federal Reserve

  1. Schiff Gold
    • Who Is Buying US Treasuries ( Link )
      • The Federal Reserve is another big player in the US Treasury market. The central bank holds about $2.39 trillion on federal debt, much of it purchased over the last decade through its QE programs.
      • But the Fed isn’t buying right now either. Its Treasury holdings fell by $70 billion from the beginning of its QE unwind last fall through April.

World Drowning In Debt

  1. Zero Hedge
    • Tyler Dunden
      • IMF Sounds The Alarm On Global Debt, Warns “United States Stands Out” ( Link )
        • What we again find odd is how quiet everyone was for the past ten years when central banks, by keeping interest rates at record low levels, enabled the world’s biggest debt issuance spree, for both public and private debt, and now that debt is at a level that even Goldman recently said is no longer sustainable, suddenly everyone – from central banks, to bank CEOs, to NGOs – is screaming from the rooftops how dangerous debt really is …
        • Reading the IMF report between the lines, it is nothing more than advance scapegoating for the inevitable global debt crisis that is coming, and which not even the IMF is hiding any more. What is most comical – if completely expected – is that the IMF is now blaming it all on Trump: not on generations of economists who steered the world to the point where there is more than $3 of debt for every $1 of GDP, and not on central bankers who flooded the world with debt so that the richest 0.01% can be richer than their wildest dream. Nope: it’s all Trump’s fault.
        • Somehow we doubt this advance damage control will work after the next, and likely final, crash.
        • “We urge policymakers to avoid pro-cyclical policy actions that provide unnecessary stimulus when economic activity is already pacing up,” Gaspar said; what he really meant was “Trump, stop what you are doing before you lead to a debt funding crisis, that finally bursts the global debt bubble. “
        • There is another threat: rising rates. The IMF said that the interest burden has doubled in the past ten years to close to 20% of taxes, an escalating cost which “reflects in part the increasing reliance on nonconcessional debt, as countries have gained access to international financial markets and expanded domestic debt issuance to nonresidents.”
        • Echoing its warning from April 2017, The IMF again noted it is was concerned that private sector debts make the global economy more vulnerable to a new financial crisis started by “an abrupt deleveraging process” where borrowers all tighten their belts simultaneously, sending the economy into a nosedive.
        • “In the event of a financial crisis, a weak fiscal position increases the depth and duration of the ensuing recession, as the ability to conduct countercyclical fiscal policy is significantly curtailed.”
        • So what should policymakers – having gotten used to flooding the world in debt – do? Why the opposite, of course: as the FT summarizes, with the global economy growing strongly, the IMF recommended countries stop using lower taxes or higher public spending to stimulate growth and instead try to reduce the burden of public sector debts so that countries have more leeway to act in the next recession.
        • Translation: no tax cuts, no increases to deficit spending, i.e. another dig at everything that Trump is doing.
        • In fact, the IMF singled out the Trump administration’s tax cuts for criticism, since they left the US with a deficit of 5% of national income into the medium term and a persistently rising level of debt in GDP. It also explains why the IMF forecasts the US is the only nation whose debt load will rise in the next 5 years.

          “In the United States fiscal policy should be recalibrated to ensure that the government debt-to-GDP ratio declines over the medium term. This should be achieved by mobilising higher revenues and gradually curbing public spending dynamics, while shifting its composition toward much-needed infrastructure investment.”

 

Iran

New Payment System

  • Al Jazeera
    • EU and Iran agree on new payment system to skirt US sanctions
      • In a major snub to the United States, the European Union has decided to set up a new mechanism to enable legal trade with Iran without encountering US sanctions.
      • The EU will create new payment channels to preserve oil and other business deals with IranFederica Mogherini, the bloc’s foreign policy chief said late on Monday, in a bid to evade US punitive measures.
      • Mogherini’s announcement came after a meeting with foreign ministers from Britain, France, Germany, Russia, China, and Iran on the sidelines of the United Nations General Assembly in New York.
      • “In practical terms this will mean that EU member states will set up a legal entity to facilitate legitimate financial transactions with Iran and this will allow European companies to continue to trade with Iran in accordance with European Union law and could be open to other partners in the world,” she told reporters after the closed-door meeting.
      • The EU, along with Russia and China, said in a joint statement that the so-called “Special Purpose Vehicle” will “assist and reassure economic operators pursuing legitimate business with Iran”.
      • The statement added that the six countries signatory to the 2015 nuclear agreement “reconfirmed their commitment to its full and effective implementation in good faith and in a constructive atmosphere”.

SWIFT

  1. Wkipedia
    • As mentioned above SWIFT had disconnected all Iranian banks from its international network as a sanction against Iran. However, as of 2016 Iranian banks which are no longer on international sanctions lists, were reconnected to SWIFT. Even though in theory this enables movement of money from and to these Iranian banks, foreign banks remain wary of doing business with the country. Due to primary sanctions, transactions of U.S. banks with Iran, or transactions in U.S. dollars with Iran, remain prohibited.
    • Similarly, in August 2014 the UK planned to press the EU to block Russian use of SWIFT as a sanction due to Russian military intervention in Ukraine.However, SWIFT refused to do so. In their official statement they said, “SWIFT regrets the pressure, as well as the surrounding media speculation, both of which risk undermining the systemic character of the services that SWIFT provides its customers around the world”.  SPFS, a Russia-based SWIFT equivalent, was created by the Central Bank of Russia as a backup measure.
    • In September 2018 the European Union foreign policy head, Federica Mogherini, proposed the development of a new “special purpose financial vehicle” intended to bypass the U.S. controlled Society for Worldwide Interbank Financial Telecommunication payments system – commonly known as SWIFT. The seven founding members of this new system are to be Iran, the European Commission, Germany, France, the U.K., Russia and China – but not the United States.
    • The United States, having withdrawn from the JCPOA – better known as “the Iran Nuclear Deal” – has decreed severe sanctions against any nation trading with Iran. The new payments system is designed to remove certain banking transactions with Iran from the purview of U.S. authorities, and as such, to escape U.S. sanctions against nations trading with Iran. The goal is to encourage Iran to continue to adhere to the terms of the JCPOA, which forbids the testing, development and manufacture of nuclear weapons.
    • In time, it could be used more generally to evade other U.S. sanctions, such as those against the German-Russian pipeline project known as Nordstream 2.
    • SWIFT has also rejected calls to boycott Israeli banks from its network.

Quotes

  1. David Kotok, chairman of Cumberland Advisors
    • money.cnn.com [ Link ]
      • The bigger risk is that China or another country weans itself off US debt by slowing its purchases and waiting for existing Treasuries to mature.
      • “Gradualism could have a long-term impact on the United States. But that would be a patient policy that would not reveal itself easily,” said David Kotok, chairman of Cumberland Advisors.

 

Technical Summary

As it relates to Treasury Bills:

  1. Sold Off
    • Russia and Turkey have sold off
  2. Holding at Current Levels
    • Japan & China
  3. Buying
    • US Multi-Nationals ( Amazon, Microsoft, Google, Facebook ) are accumulating as part of off-shore business income
    • Resistant to bring on-shore due to exposure to Tax

International Money Transfer

  1. SWIFT
    • Pressured to exert itself as embargoes are launched against countries
    • It appears that Western Europe, Russia, and China might not go along

Closing

In closing, “How do you deal toughly with your banker?” – Hilary Clinton

Pastor Tim Omotoso – Rape Trial

Studies

Wikipedia

Link

  1. Prevalence
    • According to the report by the United Nations Office on Crimes and Drugs for the period 1998–2000, South Africa was ranked first for rapes per capital
    • A survey from the comprehensive study “Rape in South Africa” from 2000 indicated that 2.1% of women aged 16 years or older across population groups reported that they had been sexually abused at least once between the beginning of 1993 and March 1998
    • Similarly, The South African demographic and health survey of 1998 gave results of rape prevalence at 4.0% of all women aged between 15 and 49 years in the sampled households (a survey also performed by the Medical Research Council and Department of Health).
  2. Violence Against Women
    • The South African government reports that one of these reasons is the culture of patriarchy in South Africa. Its report states that patriarchy is firmly rooted in Black culture and fighting it is seen as attempting to destroy South African tradition or South African ideals.
    •  The danger from rape and sexual assault is compounded because of the prevalence of HIV/AIDS in South African townships. A woman being raped over the age of 25 has a one in four chance that her attacker is HIV positive and more women than men are affected from HIV/AIDS.
    • The perpetrators of rape in South Africa tend to be men known to the victim. It is reported that a husband or boyfriend kills a woman every six hours in South Africa.
    • Many men and women say that rape cannot occur in relationships; however, one in four women reported having been abused by an intimate partner.
  3. Violence against infants
    • Virgin
      • A significant contributing factor for the escalation in child abuse is the widespread myth in HIV ravaged South Africa that having sex with a virgin will cure a man of AIDS.
      • This virgin cleansing myth exists in Zambia, Zimbabwe and Nigeria.The child abusers are often relatives of their victims and are at times their fathers or providers.
  4. Corrective Rape
    • Lesbians in certain parts of South Africa also face a dangerous environment. Raping lesbians (a practice referred to as corrective rape) is believed to convert them to heterosexuality.
    • One notable case of this was the gang-rape and murder of Eudy Simelane, a member of the South African football team and LGBT-rights activist.  Lesbians have died from these attacks in the last 10 years and more than 10 lesbians per week are raped or gang-raped in Cape Town alone.
  5. Report
    • It is estimated that over 40% of South African women will be raped in their lifetime and that only 1 in 4 rapes are reported

Videos

  1. Rape Trial
    • Videos
      • The judge had to jump in when the lawyer asked this… (Omotoso trial)
        Channel :- Rising On A Point Of Order
        Date Published :- 2018-Oct-19th
        Link
  2. Solomon Izang Ashoms
    • DISCUSSION: Omotoso case with Solomon Izang Ashoms
      • Profile
        • Lets take the discussion further now we are joined by someone who has been in the forefront of this case, the founder of Seven Days Of Hope, Solomon Izang Ashoms
      • Videos
        • DISCUSSION: Omotoso case with Solomon Izang Ashoms
          Channel :- SABC Digital News
          Published On :- 2018-Oct-22nd
          Link
    • Newsroom: Religion and Money
      • Profile
        • We are now joined by Solomon Izang Ashoms, Nigerian Journalist to discuss the relationship between charismatic churches and money
      • Videos
        • DISCUSSION: Newsroom: Religion and Money
          Channel :- SABC Digital News
          Published On :- 2015-July-14th
          Link
  3. SABC Digital News
    • Videos
      • Makhosini Nkosi
        • Makhosini Nkosi reflects on Cheryl’s testimony in the Omotoso trial
          • Profile
            • Judge presiding over the trial of Nigerian pastor, Timothy Omotoso yesterday barred graphic questions asked by defence advocate, Peter Daubermann to the witness Cheryl Zondi saying they are unfair to her. During cross-examination, Zondi told the court that she never resisted when Omotoso allegedly sexually assaulted her because he told her she would experience the wrath of God if she refused. Now to talk to us about rape survivors and the criminal justice system we are now joined in studio by Makhosini Nkosi, Communications Specialist, and former Scorpions spokesperson.
          • Videos
            • Video #1
              Channel :- SABC Digital News
              Published On :- 2018-Oct-16th
              Link
      • Ulrich Roux
        • Makaula dismisses Omotoso’s defence team application: Ulrich Roux
          • Videos
            • Video #1
              Channel :- SABC Digital News
              Published On :- 2018-Oct-22nd
              Link
      • Vinesh Naidu
        • Omotoso trail takes a different turn
          • Profile :- Proceedings of the Pastor Timothy Omotoso trial took a different turn yesterday. Presiding Judge Mandela Makaula dismissed an application by the defence team that he recuse himself from the case. Omotoso’s lawyer Advocate Peter Daubermann accused Makaula of being aligned with witness Cheryl Zondi. To discuss this further, from our Port Elizabeth studios we’re joined by Vinesh Naidu, High Court Legal Practitioner at Legal Aid South Africa.
        • Videos
      • Nigerian Community
        • Nigerian community react to Omotoso trial
          • Profile
            • The Nigerian community in Nelson Mandela Bay have spoken out and voiced their views, about televangelist Nigerian Pastor Timothy Omotoso’s trial, that is currently ongoing in the Port Elizabeth High Court. The foreign nationals living in the friendly city, have condemned Omotoso’s alleged offenses. But, they have called on the South African Judiciary to conduct a fair and unbiased trial. Foreigners have also urged South Africans, not to generalise that all Nigerians as criminals. Our reporter Jayed-Leigh Paulse has more.
          • Videos
      • Nigerian Pastors
        • Newsroom: Nigerian Pastors Association in SA speak out
          • Profile
            • The Commission for the Promotion and Protection of the Rights of Cultural, Religious and Linguistic Rights of Communities is soon set to create a regulatory organisation for churches not belonging to any current regulatory body. This is light of several cases of charismatic pastors using controversial teaching methods. In the latest case, Nigerian pastor Tim Omotoso is accused of sexual assault. However, Nigerian pastors in South Africa are being monitored, and to talk to us more about this, we were joined in studio by the Vice President of the Nigerian Pastors Association in South Africa, Pastor O.C Festus, as well as the National President, Bishop Ranti Famodun
          • Videos
  4. eNCA
    • More witnesses come forward #Omotosoatrial
      • Profile
        • As the trial of rape-accused pastor Timothy Omotoso unfolds, others are coming forward with disturbing claims relating to the self-proclaimed “man of God.” Omotoso’s Jesus Dominion International church is still operating in Durban, where young girls were allegedly kept in upmarket houses against their will. eNCA’s Dasen Thathiah spoke to one of the church’s former members who says she rejected the pastor’s advances.
      • Videos
        • Video #1
          Channel :- eNCA
          Published On :- 2018-Oct-18th
          Link

In-depth

Solomon Izang Ashoms

DISCUSSION: Omotoso case with Solomon Izang Ashoms

  1. How is it possible for a Priest to convince someone that what he is doing is OK
  2. Girls went there by themselves
      • Hypnosis
        • Witch Doctor
        • Sleep Women

     

    • Human Wisdom
      • Brainwash
        • Get scripture to brainwash you
    • Supernatural Power
      • Devil gives them the spiritual power
      • Touch people and they fall
      • Control
      • A lot of spiritual implications to it
    • Motivation
      • Grow the Church
        • Get more power
        • Get more money
    • Enablers
      • Are they working under the Spell
      • Coming from poverty
        • Nice Clothes
      • Musically Inclined