Entity Framework – SQL Server/ Stored Procedure

Background

Let us look further into Entity Frameworks.

As Entity Framework supports the full repertoire of programmable objects in SQL Server, we can use Stored Procedures and Functions, in addition to Tables and Views.

 

Database

SQL Server

Diagram

Stored Procedure

Stored Procedure – dbo.usp_TraceFlagSourceFetch

if object_id('[dbo].[usp_TraceFlagSourceFetch]') is null
begin
	exec('create procedure [dbo].[usp_TraceFlagSourceFetch] as ');
end
go

alter procedure [dbo].[usp_TraceFlagSourceFetch] 
(
	@id int
)
as
begin

	select 
			  tblTFS.id
			, tblTFS.[sequenceNbr]
			, tblTFS.[status]
			, tblTFS.
			, tblTFS.[title]
			, tblTFS.[url]
			, tblTFS.[addedBy]
			, tblTFS.[dateAdded]
	from   [dbo].[traceFlagSource] tblTFS

	where tblTFS.id = @id

end
go

grant execute on [dbo].[usp_TraceFlagSourceFetch]   to [edmgen]
go


 

Visual Studio

Launch Visual Studio and open the Project.

Solution Explorer

Access the Solution Explorer and double click on the edmx file.

EDMX

Here is what our EDMX Diagram looks like.

 

Model Browser

Let us review the Model Browser.

Right click in an empty spot on the diagram panel and from the drop-down menu choose, Model Browser.

Diagram Panel – Menu

Model Browser Panel – What Is?

Access the “Model Browser“.

An edmx contains the following section, Diagrams, Conceptual model, and Data Store.

We have already covered the Diagram.

The Conceptual Model reflects the Object Components ( Entity Types, Complex Types, Enum Types, Association, and Function Imports ).

And, the last section is the Data Store.

 

Model Browser Panel – Original

 

Update Model

Let us update the model so that we can have access to the recently created or exposed Stored Procedure.

Update Model – Choose Your Database Objects and Settings

Before Creating \ Exposing

Here is what the “Update Wizard” looks like before exposing the Stored Procedure.

 

After Creating \ Exposing

Upon creating the SP, usp_TraceFlagSourceFetch, it shows up in the Update Wizard’s Add Tab.

 

Add the Database Stored Procedure

 

Model Browser Panel – Post Adding Database Object

Once we update our Database Model and choose to Add the Stored Procedure, we will revisit the Model Browser.

The pertinent areas are :

  1. Model
    • Function Imports
      • usp_TraceFlagSourceFetch
  2. Store
    • Stored procedures / Functions
      • usp_TraceFlagSourceFetch

 

Function Import – default

During the process of updating the model with the Stored Procedure, the Wizard also creates a default Function Import.

Model Browser – Model – Function Imports – usp_TraceFlagSourceFetch

Properties

Let us quickly review the properties of our auto-created Function Import

Menu

To access the property right click on the Function and select Properties from the dropdown menu.

Properties

Explanation
  1. Stored Procedure Name
    • We see the name of the  underlying Stored Procedure, usp.TraceFlagSourceFetch,
  2. Return Type
    • And, also notice that the system has auto created a Return Type
      • The Return Type is usp_TraceFlagSourceFetch_Result1

 

Properties – Return Type

We are able to access the “Return Type” and review the structure of hat is actually Returned

Edit Function Import

By default the Return is an auto-created type.

It’s naming syntax is <SP>_Result#.

 

Edit Function Import .. #2

We should click on the “Get Column Information” button to get the actual columns and their metadata.

 

Mapping Details

If we access the Model Browser and review the Mapping Details for our selected SP, here is what we see:

 

 

Add New – Function Import

When defining our Stored Procedure we made sure to include the same columns as the table that we are exposing.

And, in so doing, we can explicitly map the Return Type to our table.

Add New – Function Import – Menu

Right click in an empty area on the diagram model and choose the “Add New” \ “Function Import” menu entry.

 

Add New – Function Import – TraceFlagSourceFetch

Explanation

  1. Function Import Name
    • We offered a name and that name is TraceFlagSourceFetch
  2. Return a collection of
    • Entities
      • traceFlagSource

Add New – Function Import – TraceFlagSourceFetch – Get Column Information

Upon clicking on the “Get Column Information” button, we are able to review the list of columns.

 

Model Browser Panel – Post Adding a “Function Import”

Explanation

Quick review, we have two Function Imports:

  1. TraceFlagSourceFetch
    • The one we defined ourselves
  2. usp_TraceFlagSourceFetch
    • The one auto-created for us

 

Code


      var varTFS = dbDE.usp_TraceFlagSourceFetch(iID);

            //Iterate list
            foreach (usp_TraceFlagSourceFetch_Result1 objTFS in varTFS)
            {

                // prepare UI output
                strLog
                    = String.Format
                        (
                              FORMAT_TRACESOURCE_LIST
                            , objTFS.source
                            , objTFS.title
                            , objTFS.url
                        );

                Console.WriteLine(strLog);

                // Output Line Break
                Console.WriteLine(CHAR_LINEBREAK);

           } //foreach

 



Dashboard
Home
Comments I’ve Made
Site Stats
My Blogs
Blogs I Follow
Akismet Stats
Omnisearch

Store
Store
Premium Themes
My Domains
Manage Purchases
Billing History

Posts
All Posts
Add New
Categories
Tags
Copy a Post

Media
Library
Add New

Links
All Links
Add New
Link Categories

Pages
All Pages
Add New
Copy a Page

Comments

Feedback
Polls
Ratings
Feedback

Appearance
Themes
Customize
Widgets
Menus
Header
Background
AMP
Mobile

Plugins

Users
All Users
Invite New
My Profile
Personal Settings

Tools
Available Tools
Import
Export
Delete Site

Settings
General
Writing
Reading
Discussion
Media
Sharing
Polls
Ratings
AdControl
Email Post Changes
OpenID
Webhooks
Collapse menu
My Site
+ ADD NEW WORDPRESS
Learning in the Open
learningintheopen.org
Stats Stats
Plan
Premium
Publish
Blog Posts
Add
Pages
Add
Media
Add
Personalize
Themes
Customize
Configure
Sharing
People
Add
Plugins
Domains
Add
Settings
WP Admin
Reader
Streams
Followed Sites
Manage
Discover
Search
Recommendations
My Likes



Daniel Adeniji
@danieladeniji
Sign Out
Profile
My Profile
Account Settings
Manage Purchases
Security
Notifications
Special
Get Apps
Next Steps
Help
Write
Log Out
Help Screen Options
Edit Post Add New
The backup of this post in your browser is different from the version below.	 Restore the backup
This will replace the current editor content with the last backup version. You can use undo and redo in the editor to get the old content back or to return to the restored version.
Dismiss this notice.
There's an easier way to create on WordPress.com. Switch to the improved editor.
Post updated. View post
Dismiss this notice.
Enter title here
Entity Framework - SQL Server/ Stored Procedure
Permalink: https://learningintheopen.org/2017/05/26/entity-framework…stored-procedure/ ‎Edit Get Shortlink
 Add Media Add PollAdd Poll  Add Contact Form  Add LocationVisualText
bilinkb-quotedelinsimgulollicodemoreclose tagsproofread

<h1>Background</h1>

Let us look further into Entity Frameworks.

As Entity Framework supports the full repertoire of programmable objects in SQL Server, we can use Stored Procedures and Functions, in addition to Tables and Views.

&nbsp;

<h1>Database</h1>


<h2>SQL Server</h2>


<h3>Diagram</h3>

<a href="https://learningintheopen.org/2017/05/26/entity-framework-sql-server-stored-procedure/diagram_traceflag/#main" rel="attachment wp-att-53111"><img class="alignnone wp-image-53111" src="https://danieladeniji.files.wordpress.com/2017/05/diagram_traceflag.png" alt="" width="1207" height="524" /></a>

<h3>Stored Procedure</h3>


<h4>Stored Procedure - dbo.usp_TraceFlagSourceFetch</h4>



if object_id('[dbo].[usp_TraceFlagSourceFetch]') is null
begin
	exec('create procedure [dbo].[usp_TraceFlagSourceFetch] as ');
end
go

alter procedure [dbo].[usp_TraceFlagSourceFetch] 
(
	@id int
)
as
begin

	select 
			  tblTFS.id
			, tblTFS.[sequenceNbr]
			, tblTFS.[status]
			, tblTFS.
			, tblTFS.[title]
			, tblTFS.[url]
			, tblTFS.[addedBy]
			, tblTFS.[dateAdded]
	from   [dbo].[traceFlagSource] tblTFS

	where tblTFS.id = @id

end
go

grant execute on [dbo].[usp_TraceFlagSourceFetch]   to [edmgen]
go


 

Visual Studio

Launch Visual Studio and open the Project.

Solution Explorer

Access the Solution Explorer and double click on the edmx file.

EDMX

Here is what our EDMX Diagram looks like.

 

Model Browser

Let us review the Model Browser.

Right click in an empty spot on the diagram panel and from the drop-down menu choose, Model Browser.

Diagram Panel - Menu

Model Browser Panel - What Is?

Access the "Model Browser".

An edmx contains the following section, Diagrams, Conceptual model, and Data Store.

We have already covered the Diagram.

The Conceptual Model reflects the Object Components ( Entity Types, Complex Types, Enum Types, Association, and Function Imports ).

And, the last section is the Data Store.

 

Model Browser Panel - Original

 

Update Model

Let us update the model so that we can have access to the recently created or exposed Stored Procedure.

Update Model - Choose Your Database Objects and Settings

Before Creating \ Exposing

Here is what the "Update Wizard" looks like before exposing the Stored Procedure.

 

After Creating \ Exposing

Upon creating the SP, usp_TraceFlagSourceFetch, it shows up in the Update Wizard's Add Tab.

 

Add the Database Stored Procedure

 

Model Browser Panel - Post Adding Database Object

Once we update our Database Model and choose to Add the Stored Procedure, we will revisit the Model Browser.

The pertinent areas are :

  1. Model
    • Function Imports
      • usp_TraceFlagSourceFetch
  2. Store
    • Stored procedures / Functions
      • usp_TraceFlagSourceFetch

 

Function Import - default

During the process of updating the model with the Stored Procedure, the Wizard also creates a default Function Import.

Model Browser - Model - Function Imports - usp_TraceFlagSourceFetch

Properties

Let us quickly review the properties of our auto-created Function Import

Menu

To access the property right click on the Function and select Properties from the dropdown menu.

Properties

Explanation
  1. Stored Procedure Name
    • We see the name of the underlying Stored Procedure, usp.TraceFlagSourceFetch,
  2. Return Type
    • And, also notice that the system has auto created a Return Type
      • The Return Type is usp_TraceFlagSourceFetch_Result1

 

Properties - Return Type

We are able to access the "Return Type" and review the structure of hat is actually Returned

Edit Function Import

By default the Return is an auto-created type.

It's naming syntax is <SP>_Result#.

 

Edit Function Import .. #2

We should click on the "Get Column Information" button to get the actual columns and their metadata.

 

Mapping Details

If we access the Model Browser and review the Mapping Details for our selected SP, here is what we see:

 

 

Add New - Function Import

When defining our Stored Procedure we made sure to include the same columns as the table that we are exposing.

And, in so doing, we can explicitly map the Return Type to our table.

Add New - Function Import - Menu

Right click in an empty area on the diagram model and choose the "Add New" \ "Function Import" menu entry.

 

Add New - Function Import - TraceFlagSourceFetch

Explanation

  1. Function Import Name
    • We offered a name and that name is TraceFlagSourceFetch
  2. Return a collection of
    • Entities
      • traceFlagSource

Add New - Function Import - TraceFlagSourceFetch - Get Column Information

Upon clicking on the "Get Column Information" button, we are able to review the list of columns.

 

Model Browser Panel - Post Adding a "Function Import"

Explanation

Quick review, we have two Function Imports:

  1. TraceFlagSourceFetch
    • The one we defined ourselves
  2. usp_TraceFlagSourceFetch
    • The one auto-created for us

 

Code

We have to stub codes to share:

The first one calls the Function created by default.

And, the other one calls the function we created and casted to our Table.

Code - Default Function


private void listTraceFlagSourceUseSPImplicit(int iID)
{ 

	//invoke the default Function
	var varTFS = dbDE.usp_TraceFlagSourceFetch(iID);

	//Iterate list
	//Remember that it Returns data as a usp_TraceFlagSourceFetch_Result1
	foreach (usp_TraceFlagSourceFetch_Result1 objTFS in varTFS)
	{

		// prepare UI output
		strLog
			= String.Format
				(
					  FORMAT_TRACESOURCE_LIST
					, objTFS.source
					, objTFS.title
					, objTFS.url
				);

		Console.WriteLine(strLog);

		// Output Line Break
		Console.WriteLine(CHAR_LINEBREAK);

   } //foreach


} //listTraceFlagSourceUseSPImplicit

Code - Explicit Function


public void listTraceFlagSourceUseSPExplicit(int iID)
{

	//invoke the explicit Function
	//Remember that the data return is strongly type
	//and it is a table
	var varTFS = dbDE.TraceFlagSourceFetch(iID);

	//Iterate list
	//Using foreach expose each list element in varTF
	foreach (traceFlagSource objTFS in varTFS)
	{

		// prepare UI output
		strLog
			= String.Format
				(
					  FORMAT_TRACESOURCE_LIST
					, objTFS.source
					, objTFS.title
					, objTFS.url
				);

		Console.WriteLine(strLog);

		// Output Line Break
		Console.WriteLine(CHAR_LINEBREAK);

	} //foreach
	


} //listTraceFlagSourceUseSPExplict


Sql Server Profiler

Let us target SQL Server Profiler and see what our payload looks like:

Explanation:

  1. Event Class
    • RPC:Completed
    • TextData
      • Sample
        • exec [dbo].[usp_TraceFlagSourceFetch] @id=2559
    • CPU
      • 0
    • Reads
      • 2
    • Writes
      • 0

 

Listening

Behind every post there is a story.

But like Rick, this is how I will have to end this Story.

Slick Rick - Bedtime Story
Link

He dropped the gun, so went the glory
And this is the way I have end this story

Just another case 'bout the wrong path,
Straight 'n narrow or yo' soul gets cast(?)

 

 

Married with secrets

Introduction

Last weekend I spoke to a young lady I met in College.

I told her about being addicted to the show Fatal Attraction.

She said there are numerous shows along same lines.

And, so that is how I found “Married with secrets“.

 

Videos

  1. Married With Secrets – Season 1 – Episode 7 – Anger ( Reckless Abandon )
    A spoiled 16-year old cheerleader becomes pregnant by her 21- year old boyfriend and is prompted to commit bloody murder.
    And a guy who has it all decides to kill his wife and the judge overseeing his divorce when things just don’t go his way.

    Link

    • Person :-
      • Amy Preasmyer ( Cheerleader
      • Jennifer Kellog ( Friend )
      • Ricky Cowels ( Boy Friend)
    • Location :- Lancaster, CA
    • IMDB
  2. Married With Secrets – S01E01 – A Darker Shade of Blue
    Link

    • Person :-
      • Dr. Jean-Claude Dominique
      • Eliette Dominique ( Nurse / Wife )
      • Marie Betsy Barlabier, his childhood sweetheart from Haiti.
      • Aly Dominique ( Brother )
      • Rachel Dominique, Daughter
      • Jean-Claude Dominique, Junior
    • Location :-
      • New York
    • Story :-
      • THE BEDSIDE MANNER OF A DEVIOUS DOCTOR
        Link
  3. Married With Secrets – S01E02 – Obsession Has Its Price
    Link
  4. Married With Secrets – S01E05 – Fear the Ether Man
    A serial rapist known as the Ether Man lurks in the shadows of Albuquerque, New Mexico.
    Victims can’t identify the masked attacker and worse still, it looks like he’s expanding his hunting grounds. Can anyone stop him before it’s too late?
    Published On :- 2016-Dec-13th
    Link
  5. Married With Secrets – S01E06 – Yes, Master
    Participants :- Heather Garraus, Ignacio Garraus, Shawna Nelson 
    Link

    • Story
      • Ignacio Garraus: ‘I loathe myself’
        Link

Summary

Not all ends badly.

In the case of Dr. Jean-Claude Dominique, Rachel, his daughter from his marriage to Eliette Dominique, graduated with degrees from a prestigious Ivy League School.  And, she is now a practicing Attorney.

Jean-Claude Dominique, Jr graduated with a degree in Engineering and his pursuing\pursued his Masters.

Internet Information Server (IIS) – Application Pool – Tracking – Day 2

Background

This is the second post on our series on tracking the status of IIS’s Application Pool.

Lineage

Here is our initial post:

  1. Internet Information Server (IIS) – Application Pool – Tracking
    Link

 

TroubleShooting

Event Viewer

Log Parser Studio

Queries

Query – Get All WAS Entries
Query
SELECT TOP 1000

         TO_STRING(TimeGenerated, 'yyyy-MM-dd HH:mm:ss') as TimeGenerated
       , ComputerName
       , EventCategoryName
       , EventTypeName
       , EventID
       , SourceName
       , Message as Message
  
from  '[LOGFILEPATH]'

where ( SourceName = 'WAS' ) 
 
ORDER BY
           ComputerName
         , TO_STRING(TimeGenerated, 'yyyy-MM-dd HH:mm:ss') DESC

Output

 

Query – Get WAS Entries – Application Pool Disabled
Query


SELECT TOP 1000

         TO_STRING(TimeGenerated, 'yyyy-MM-dd HH:mm:ss') as TimeGenerated
       , ComputerName
       , EventCategoryName
       , EventTypeName
       , EventID
       , SourceName
       , Message as Message
  
from  '[LOGFILEPATH]'

where ( SourceName = 'WAS' ) 
 
and ( Message like '%disable%' ) 

ORDER BY
           ComputerName
         , TO_STRING(TimeGenerated, 'yyyy-MM-dd HH:mm:ss') DESC
Output

 

Summary

There are a few entries bearing the Source WAS in Windows System Event Viewer.
Inclusive are :

  1. A process serving application pool ‘DefaultAppPool’ failed to respond to a ping. The process id was ‘6208’.
  2. A process serving application pool ‘DefaultAppPool’ suffered a fatal communication error with the Windows Process Activation Service. The process id was ‘13844’. The data field contains the error number.
  3. A worker process with process id of ‘21412’ serving application pool ‘DefaultAppPool’ has requested a recycle because the worker process reached its allowed processing time limit.
  4. Application pool ‘DefaultAppPool’ is being automatically disabled due to a series of failures in the process(es) serving that application pool.

 

The ones most pernicious is “Application pool ‘DefaultAppPool’ is being automatically disabled due to a series of failures in the process(es) serving that application pool. “

Internet Information (IIS) / Log Parser – Queries – String Pattern Matching

Background

Looking for File I/O Exceptions in the Event Viewer.

 

Query

Sample

Sample 001

Code


SELECT TOP 100 
 
         TimeGenerated
       , ComputerName
       , EventCategoryName
       , EventTypeName
       , EventID
       , SourceName
       , Message as Mesg
       , Strings as Strings
       , EXTRACT_TOKEN(Strings,1,'|') AS AppName
       , EXTRACT_TOKEN(Strings,2,'|') AS AppVersion
       , EXTRACT_TOKEN(Strings,3,'|') AS S3
       , EXTRACT_TOKEN(Strings,4,'|') AS Module
       , INDEX_OF(Message, 'System.IO.IOException') as indexOf
       , case INDEX_OF(Message, 'System.IO.IOException') 
            when 0 then 'N'
            when NULL then 'N'
            else 'Y'
         end as IOE
       , CASE strcnt(Message, 'System.IO.IOException')
             when 0 then 'No'
             else 'Yes'   
         end as IOException
 
from  '[LOGFILEPATH]'
 
WHERE ( EventType = 1 OR EventType = 2 )

and    INDEX_OF(Message, 'System.IO.IOException') > 0

 
ORDER BY
         TimeGenerated DESC


Output

 

Explanation

  1. INDEX_OF
    • We use INDEX_OF to find the position of the sought string in the Message column
      • When the column contains System.IO.IOException the query returns the starting position of the found pattern
      • When not found, null is returned
  2. STRCNT
    • We invoke STRCNT to count number of matches
      • When String not found, 0 return
      • When matched, number of matches

 

References

  1. StackOverflow
    • Log Parser Case Statement
      Link

 

Internet Information Server (IIS) – Application Pool – Tracking

Background

We have a website that has been going offline.

TroubleShooting

MS Windows

Event Viewer

We started looking at the Event Viewer.

Windows Logs – System

Events

Here is what we see in the Event Viewer:

 

Source – WAS, Event ID = 5011

General
Image

 

Textual

A process serving application pool ‘DefaultAppPool’ suffered a fatal communication error with the Windows Process Activation Service.
The process id was ‘1720’. The data field contains the error number.

Details
Image

 

References

  1. IIS Windows Process Activation Service (WAS) > IIS Application Pool > IIS Application Pool Availability
    • Event ID 5011 — IIS Application Pool Availability
      Link

Summary

It looks like something is knocking our Application\Application Pool down.

 

 

Abacus Federal Savings in Chinatown, New York : SMALL ENOUGH TO JAIL

 

MarketWatch

The story behind the only bank prosecuted after the 2008 financial crisis

Link

After the 2008 financial crisis took millions of investment dollars from Americans, shell shocked financial advisers and briefly turned the country upside down, only one bank was indicted: Abacus Federal Savings in Chinatown, New York — the 2,531st largest bank in the U.S.

Founded by Chinese-American immigrant Thomas Sung in the 1980s, the bank has six branches in three states and primarily serves the Chinese community. Federal prosecutors indicted it in 2009 for mortgage fraud, securities fraud, and conspiracy after it reported to regulators it had discovered a loan officer was laundering money there.

Rather than plead guilty, the Sungs went to court. A new documentary from Oscar-nominated “Hoop Dreams” director Steve James follows the subsequent legal battle, which plays out in the film as a David and Goliath tale of a small bank taking the fall for the financial crisis over an isolated incident with a corrupt loan officer.

“Too big to fail turns into small enough to jail, and Abacus is small enough to jail,” journalist Matt Taibbi says in the film, calling the bank “as easy a target as you could possibly pick.”

With an intimate view of the fight for innocence from a stoic Thomas Sung, his razor sharp daughters (all lawyers), and his fiery wife, it’s clear the film has a sympathetic eye for Abacus as it goes up against the U.S. government, frequently comparing Thomas Sung to George Bailey in his wife’s favorite film, “It’s a Wonderful Life.”

“It seemed clear to us as filmmakers that this bank was the mirror opposite of the big banks,” director Steve James told MarketWatch in a recent interview, noting that the Sungs reported the fraud discovered at the bank themselves. “Yet they were the ones singled out, and it kind of leads one to the conclusion that this was about planting a flag and getting a trophy to be the one prosecutor, since the feds didn’t prosecute any big banks.”

Manhattan District Attorney Cyrus R. Vance Jr. argued that there was fraud widespread enough to warrant an investigation. In May 2012, he announced charges against the bank, two supervisors, and nine former employees — 184 counts including residential mortgage fraud, security fraud, conspiracy, and falsification of business records.

As the film expresses, the indictment put on trial not just the bank itself, but the reputation of Chinese immigrants and the cash culture of Chinatown. As Jill Sung, one of the daughters, notes at one point in the film, many of their members had never used a bank before. Now, with the movie’s premiere in New York on May 19 and the trial two years behind them, her focus has turned back on the bank.

“That is the hardest part, and what I focus on most, to ensure the bank can regain itself and be profitable,” Jill Sung told MarketWatch. “We are a community bank, a minority depository institution, which means we are mission-based to help our community. Any capital we get back we put back into the bank to help our community, so profitability to us is not just about dividends and shareholders — it’s about continuing to be able to do our mission and start being profitable again.”

The film is a celebration of the American dream — as well as a kind of eulogy for the community bank. Since the financial crisis, Jill Sung said not much has changed, though big banks continue to get bigger and community banks are consolidating. With scenes from George Bailey’s ‘Bailey Building and Loan’ woven among modern-day lines of neighbors and family outside Abacus throughout, the film shows something she says is central to their practice and is being lost: community.

“There are a lot of new banks that are creating digital communities, and I think it’s great — you can have a George Bailey of digital banks,” she said. “What’s more concerning is when you have big banks where there is no community, there’s no access, there is no feeling you can talk to anybody if you have a problem. The consumer suffers in the end because they get taken advantage of and have no other choices.”

Abacus was found “not guilty” on all 240 counts after months of deliberation and a hung jury.

 

Videos

Videos – Movies

  1. Abacus: Small Enough to Jail Trailer #1 (2017) | Movieclips Indie
    Link
  2. SinoVision English Channel Archives
    • Abacus: small enough to jail
      Abacus Federal Savings Bank is a family-run bank that has served New York’s Chinatown for over three decades. Its services include helping Chinese immigrants obtain loans for homes and small businesses and despite steady its growth, the bank was still only the 2651st largest bank in the country. Facing charges brought by Manhattan District attorney Cyrus Vance Jr, Abacus federal savings bank founder Thomas Sung and his four daughters decided to fight for justice. The legal battle was drawn out over five years and recorded by acclaimed filmmaker Steve James and made into the documentary.
      Published On :- 2017-May-18th
      Link
  3. Film Festival
    • Wisconsin
      • Madeline Uranek (left) and Ronnie Hess (right) from Open Doors for Refugees led a post-screening discussion of “Abacus: Small Enough to Jail,” a 2017 Wisconsin Film Festival selection.
        Link
  4. Director Steve James on ABACUS: SMALL ENOUGH TO JAIL (2017) – Celluloid Dreams
    Link

 

Videos – Law Case

  1. Bloomberg Law
    • Abacus Bank’s Lawyer: Fannie Mae Earned $120M Profit From Us
      Link

 

 

Scott Galloway

Introduction

Scott Galloway, a clinical professor of Business and Marketing,  discusses brand building, computer algorithm, and new interfaces such as Voice.

 

Wikipedia

Link
Scott Galloway is a clinical professor of marketing at the New York University Stern School of Business, public speaker, and entrepreneur.

He’s the founder of digital intelligence firm L2 and Firebrand Partners (founded in 2005), an activist hedge fund that has invested over $1 billion in U.S. consumer and media companies.
In 1992, Galloway founded Prophet, a brand and marketing consultancy firm that employs over 350 professionals in the United States, Europe, and Asia.
He has served on the board of directors of Eddie Bauer, The New York Times Company, Gateway Computer and Berkeley’s Haas School of Business. Galloway is also known for his public presentations and TED-style talks, in which he presents L2’s Digital IQ Index results, ranking over 700 global brands across dimensions including e-commerce, social media, and digital marketing.

Videos

  1. Business Insider
    Published On : -2017-April-23rd
    Link
  2. Scott Galloway – How Amazon is Dismantling Retail
    Scott Galloway speaks at L2’s Amazon Clinic about how Amazon is disrupting retail. Not only has Amazon changed consumer shopping habits, it has changed the relationship between shareholders and investors. Investors are no longer satisfied with steadily growing profits; instead they seek fast growth and strong vision – even at the expense of profitability. See video for insights on the future of brand, Alexa’s effect on households.
    Published On : -2017-April-17th
    Link