Bishop Robert Barron – “Priest, Prophet, King”

 

Videos

  1. “Priest, Prophet, King” Sample – Lesson 1
    • Profile
      • A sample video from “Priest,Prophet,King”, a dynamic new video series from Fr. Barron debuting in August 2014. Learn more at http://PriestProphetKing.com.
    • Videos
      • Video #1
        Channel :- Bishop Robert Barron
        Published on May 8, 2014
        Link
  2. Bishop Barron on the Devil
    • Profile
      • Bishop Barron on the Devil
    • Videos
      • Video #1
        Channel :- Bishop Robert Barron
        Published on :- 2012-July-25th
        Link
  3. Bishop Barron on The Prosperity Gospel
    • Profile
      • Another part of a video series from Wordonfire.org.
      • Bishop Barron will be commenting on subjects from modern day culture.
    • Videos
      • Video #1
        Channel :- Bishop Robert Barron
        Published on :- 2010-April-8th
        Link
  4. Bishop Robert Barron – 2016 CBE Keynote Speech
    • Profile
      • The Catholic Church’s social teachings about capitalism were the topic of Bishop Barron’s keynote address. “Every single pope in the church has affirmed the most central element of the market economy: private property,” he said. “Private property is grounded in the dignity and freedom of the individual. Private property allows the diffusion of power, not concentration in the hands of a few. The Church likes the entrepreneurial spirit.” Yet the popes have noted that because God made the world for everyone, the common good must be uppermost in the minds of capitalist Christians.
    • Videos
      • Video #1
        Channel :- The Orange Catholic Foundation
        Published on :- 2016-Mar-18th
        Link
  5. Fr. Robert Barron on the Temple: Mundelein Seminary Lecture Series
    • Profile
      • Fr. Robert Barron is discusses the theology of the Jewish Temple and why it is the meeting of Heaven and Earth.
    • Videos
      • Video #1
        Channel :- Mundelein Seminary
        Published on :- 2014-Sept-9th
        Link
  6. Bishop Barron: Sainthood, sanctity and what makes us holy
    • Profile
      • Bishop Robert Barron gives an excellent keynote address at the Adoremus Eucharistic Congress 2018 in Liverpool reflecting on sainthood, sanctity and what makes us holy.
    • Videos
      • Video #1
        Channel :- Catholic Church England and Wales
        Published on :- 2018-Sept-12th
        Link
  7. “The Mystery of God” – Sample Lesson
    • Profile
      • Lesson 1 from Fr. Robert Barron’s “The Mystery of God” film and study program. Learn more at http://MysteryOfGod.com. This sample lesson is on “Atheism and What We Mean By ‘God'”.
    • Videos
      • Video #1
        Channel :- Bishop Robert Barron
        Published on :- 2015-Jun-27th
        Link

 

In depth

“Priest, Prophet, King” Sample – Lesson 1

  1. Early Christians took Three great archetypes from the Old Testament
    • Priest
    • Prophet
    • King

 

 

 

Rod Stewart

Background

There are so many good things to say about Soulful Rod Stewart.

Yet, it is so far better to have him say it himself.

 

Videos

  1. Some Guys Have All The Luck
    • Videos
      • Rod Stewart – Some Guys Have All the Luck / Addicted to Love (from One Night Only!)
        Channel :- Rod Stewart
        Published on :- 2016-Oct-5th
        Link
      • Video #1
        Channel :- Macik0073
        Published on Mar 3, 2012
        Link
  2. So far away
    • Videos
      • Video #1
        Channel :- nightfawn27
        Published on May 23, 2010
        Link
  3. Rod Stewart – Forever Young (Official Video)
    • Videos
      • Forever Young
        Channel :- Alberto Cruz
        Published on : – 2010-May-28th
        Link
  4. Rod Stewart – You’re In My Heart
    • Videos
      • Music video by Rod Stewart performing You’re In My Heart. (P) 2004 RCA Records, a division of Sony Music Entertainment
        Channel :- Rod Stewart
        Published on : – 2016-Oct-5th
        Link
  5. Rod Stewart – First Cut Is The Deepest (from One Night Only!)
    • Profile
      • Music video by Rod Stewart performing First Cut Is The Deepest. (P) 2004 RCA Records, a division of Sony Music Entertainment
    • Videos
      • Rod Stewart – First Cut Is The Deepest (from One Night Only!)
        Channel :- Rod Stewart
        Published on : – 2016-Oct-5th
        Link
  6. Reason To Believe
    • Profile
      • Music video by Rod Stewart performing Reason to Believe. (C) 2004 RCA Records, a division of Sony Music Entertainment
    • Videos
      • Video #1
        Channel :- Reason To believe
        Published on :- 2016-August-5th
        Link
  7. Jeff Beck, Rod Stewart – People Get Ready
    • Profile
      • Jeff Beck’s official music video for ‘People Get Ready’ ft. Rod Stewart.
    • Videos
      • Jeff Beck, Rod Stewart – People Get Ready
        Published on :- 2013-July-20th
        Link
  8. Rod Stewart – Have You Ever Seen The Rain
    • Profile
      • Rod Stewart – Have You Ever Seen The Rain (Official Music Video)
    • Videos
      • Video #1
        Channel :- Rod Stewart – Have You Ever Seen The Rain (Official Music Video)
        Published on :- 2009-August-25th
        Link

Lyrics

Forever Young

May the good Lord be with you down every road you roam.
And may sunshine and happiness surround you when you’re far from home.
And may you grow to be proud, dignified and true.
And do unto others as you’d have done to you.
Be courageous and be brave.
And in my heart you’ll always stay

Forever young. (Forever young)
Forever young. (Forever young)

May good fortune be with you, may your guiding light be strong,
Build a stairway to heaven with a prince or a vagabond.
And may you never love in vain.
And in my heart you will remain

 

Some Guys Have All The Luck

Alone in a crowd on a bus after working, I’m dreaming
The guy next to me has a girl in his arms, my arms are empty
How does it feel when the girl next to you says she loves you?
Seems so unfair when there’s love everywhere but there’s none for me

Someone to take on a walk by the lake Lord, let it be me
Someone who’s shy, someone who’d cry at sad movies
I know I would die if I ever found out she was foolin’ me
You’re just a dream, and as real as it seems, I ain’t that lucky
Some guys

 

So far away

So far away
Doesn’t anybody stay in one place any more?
It would be so fine to see your face at my door
And it doesn’t help to know you’re just time away
Long ago I reached for you and there you stood
Holding you again would only do me good
Oh how I wish I could but you’re so far away
One more song about moving along the highway
I can’t say much of anything that’s new
But if I could only work this life out my way
I’d rather spend it being close to you
But you’re so far away
Doesn’t anybody stay in one place any more?
It would be so fine to see your face at my door
And it doesn’t help to know you’re so far away
So far away, yeah, you’re so far away
Traveling around sure gets me down and lonely
Nothing else to do but close my mind
And I sure hope the road don’t get to own me
There’s so many dreams that I’ve yet to find

Alistair Begg

 

Videos

  1. Spiritual Warfare
    • Profile
      • Part One
        • By: Alistair Begg – Jesus secured salvation for all believers when He defeated Satan at the cross. Until Christ returns, however, spiritual warfare rages on in this world and should not be easily dismissed. In His mercy, God has provided the armor by which we can withstand such fierce opposition. In this overview of God’s protective provision, Alistair Begg exhorts us to resist Satan’s accusations, look outside ourselves to Christ, and recall the truth that in Christ, we already have the victory.
      • Part Two
        • By: Alistair Begg – Every believer dwells in the spiritual realm and will encounter battle with our adversary, the devil, until Christ’s return. Alistair Begg urges us to remain alert to Satan’s subtle, fiery darts, and outlines a practical strategy to employ in the midst of the struggle. As students of God’s Word, we can persevere—conscious of our weakness, but strong in the Lord; resolute because of His goodness; and with every confidence in our unity with the One who reigns victorious.
    • Videos
      • Spiritual Warfare, Part One
        • Video #1
          Channel :- Alistair Begg
          Published on :- 2018-May-23rd
          Link
      • Spiritual Warfare, Part Two
        • Video #1
          Channel :- Alistair Begg
          Published on :- 2018-May-23rd
          Link
  2. Prophet, Priest, King
    • Profile
      • Understanding the breadth of Christ’s finished work is essential for the Christian life. This study in Hebrews 1 reminds us that Jesus is the Prophet who revealed God finally and fully, the Priest who reconciled lost people to God by sacrificing himself, and the triumphant King who reigns over all that he has made.
    • Scripture
      • Hebrews 1
        • Prophets
          • In the past God spoke to our ancestors through the prophets at many times and in various ways, 2 but in these last days he has spoken to us by his Son ( Hebrew 1:1 )
        • Priest
          • After he had provided purification for sins ( Hebrew 1:3 )
        • King
          • But about the Son he says,

            “Your throne, O God, will last for ever and ever;
                a scepter of justice will be the scepter of your kingdom.
            You have loved righteousness and hated wickedness;
                therefore God, your God, has set you above your companions
                by anointing you with the oil of joy.”

            ( Hebrew 1:8-9 )

    •  Videos
      • Prophet, Priest, King
        • Video #1
          Channel :- Alistair Begg
          Published on :- 2012-Jan-4th
          Link
  3. The Peril of Spiritual Apostasy – Alistair Begg Sermons
    • Profile
      • The Peril of Spiritual Apostasy – Alistair Begg Sermons Hebrews 6:4 For it is impossible, in the case of those who have once been enlightened, who have tasted the heavenly gift, and have shared in the Holy Spirit.
    • Videos
      • Video #1
        Channel :- Christian Praise and Worship in Songs, Sermons, and Audio Books
        Published on Mar 21, 2014
        Link
  4. Signs of the Ends
    • Profile
      • Most of the time, when the topic is “the end of the world,” you hear a lot of speculation about dates and events and meanings. Mark 13 shows us a striking difference in the way Jesus approached this subject. Instead of speculating about dates, the Lord provided His followers with practical instruction – actions and attitudes that will equip us to face the future He has planned.
    • Videos
      • Video #1
        Channel :- Alistair Begg
        Published on Sep 20, 2012
        Link
  5. The Danger of Deception
    • Profile
      • When someone claims to speak on God’s behalf, it’s absolutely essential that we evaluate their message’s credibility. Join us on Truth For Life as Alistair Begg examines the apostle John’s warning to be on the lookout for deceivers.
    • Videos
      • Part 1
        • The Danger of Deception (Part 1 of 2) —5/18/2019
          Channel :- Alistair Begg
          Published on :- 2019-May-19th
          Link

 

Sample Database – w3resource

Background

Looking for sample database model for a query that I had in mind.

Found a simple on at w3Resource.

 

w3Resource

The sample is title “SQL Exercises, Practice, Solution – exercises on employee Database”.

And, it is available here.

 

Model

Data

Employee

 

SQL

Data Definition Language ( DDL )

Employee

SQL


if schema_id('w3resource') is null
begin

    exec('create schema [w3resource] authorization [dbo]')

end
go

/*

    w3resource
    SQL employee Database [115 Exercise with Solution]
    https://www.w3resource.com/sql-exercises/employee-database-exercise/index.php

*/

/*

    drop table [w3resource].[employee];

*/
if object_id('[w3resource].[employee]') is null
begin

    create table [w3resource].[employee]
    (
          [id]              int          not null
                            identity(1,1)

        , [empID]           int          not null

        , [empName]         varchar(60)  not null

        , [jobName]         varchar(60)  null

        , [managerID]       int          null

        , [hireDate]        date         null

        , [salary]          decimal(10,2) null

        , [commision]       decimal(7,2) null

        , [departmentID]    int          null

        , constraint [PK_w3resource.employee]
            primary key
            (
                [empID]
            )
        , constraint [FK_w3resource.employee.managerID]
            foreign key
            (
                [managerID]
            )
            references [w3resource].[employee]
            (
                [empID]
            )

   ) 

end   

go



 

Data Manipulation Language ( DML )

Employees

SQL



set nocount on
go

set XACT_ABORT on
go


/*

    w3resource
    SQL employee Database [115 Exercise with Solution]
    https://www.w3resource.com/sql-exercises/employee-database-exercise/index.php

*/

delete 
from    [w3resource].[employee]
;

DBCC CHECKIDENT ('[w3resource].[employee]', RESEED, 0)  
go

insert into [w3resource].[employee]
(
      [empID]   
    , [empName] 
    , [jobName] 
    , [managerID]
    , [hireDate]
    , [salary]
    , [commision]
    , [departmentID]
)     
select   
      63819 as [empID]   
    , 'Kayling' as [empName] 
    , 'President' as [jobName] 
    , null as [managerID]
    , '1991-11-18'
    , 6000
    , null
    , 1001


union all

select   
      66928 as [empID]   
    , 'Blaze' as [empName] 
    , 'Manager' as [jobName] 
    , 63819 as [managerID]
    , '1991-05-01'
    , 2750
    , null
    , 3001

union all

select   
      67832 as [empID]   
    , 'Clare' as [empName] 
    , 'Manager' as [jobName] 
    , 63819 as [managerID]
    , '1991-06-09'
    , 2550
    , null
    , 1001

union all

select   
      65646 as [empID]   
    , 'Jonas' as [empName] 
    , 'Manager' as [jobName] 
    , 63819 as [managerID]
    , '1991-04-02'
    , 2957.00
    , null
    , 2001

union all

select   
      67858 as [empID]   
    , 'Scarlet' as [empName] 
    , 'Analyst' as [jobName] 
    , 65646 as [managerID]
    , '1997-04-19'
    , 3100.00
    , null
    , 2001


union all

--Frank
select   
      69062 as [empID]   
    , 'Frank' as [empName] 
    , 'Analyst' as [jobName] 
    , 65646 as [managerID]
    , '1991-12-03'
    , 3100.00
    , null
    , 2001


union all

-- Sandrine
select   
      63679 as [empID]   
    , 'Sandrine' as [empName] 
    , 'Clerk' as [jobName] 
    , 69062 as [managerID]
    , '1990-12-18'
    , 900
    , null
    , 2001

union all

-- Adelyn
select   
      64989 as [empID]   
    , 'Adelyn' as [empName] 
    , 'Salesman' as [jobName] 
    , 66928 as [managerID]
    , '1991-02-20'
    , 1700
    , 400
    , 3001


union all

-- Wade
select   
      65271 as [empID]   
    , 'Wade' as [empName] 
    , 'Salesman' as [jobName] 
    , 66928 as [managerID]
    , '1991-02-22'
    , 1350.00
    , 600.00
    , 3001

union all
-- Madden
select   
      66564 as [empID]   
    , 'Madden' as [empName] 
    , 'Salesman' as [jobName] 
    , 66928 as [managerID]
    , '1991-09-28'
    , 1350.00
    , 600.00
    , 3001

union all

-- Tucker
select   
      68454 as [empID]   
    , 'Tucker' as [empName] 
    , 'Salesman' as [jobName] 
    , 66928 as [managerID]
    , '1991-09-08'
    , 1600.00
    , 0.00
    , 3001

union all

-- Adnres
select   
      68736 as [empID]   
    , 'Adnres' as [empName] 
    , 'Clerk' as [jobName] 
    , 67858 as [managerID]
    , '1997-05-23'
    , 1200.00
    , null
    , 2001

union all

-- Julius
select   
      69000 as [empID]   
    , 'Julius' as [empName] 
    , 'Clerk' as [jobName] 
    , 66928 as [managerID]
    , '1991-12-03'
    , 1050.00
    , null
    , 3001

union all

-- Marker
select   
      69324 as [empID]   
    , 'Marker' as [empName] 
    , 'Clerk' as [jobName] 
    , 67832 as [managerID]
    , '1992-01-23'
    , 1400.00
    , null
    , 1001

go

 

Source Control

GitHub

DanielAdeniji/w3ResourceDBSample
Link

Alistair Begg On Ananias

Background

It is quite easy to be be lured into sleep by Alistair Begg’s smooth accent and delivery.

 

Alistair Begg

Do you know how many will be converted if you take them under Christ?

 

Scripture

Acts 22:6-21

Link

  1. 6 “About noon as I came near Damascus, suddenly a bright light from heaven flashed around me. 7 I fell to the ground and heard a voice say to me, ‘Saul! Saul! Why do you persecute me?’
  2. 8 “‘Who are you, Lord?’ I asked.
  3. “ ‘I am Jesus of Nazareth, whom you are persecuting,’ he replied. 9 My companions saw the light, but they did not understand the voice of him who was speaking to me.
  4. 10 “‘What shall I do, Lord?’ I asked.
  5. ” ‘Get up,’ the Lord said, ‘and go into Damascus. There you will be told all that you have been assigned to do.’ 11 My companions led me by the hand into Damascus, because the brilliance of the light had blinded me.
  6. 12 “A man named Ananias came to see me. He was a devout observer of the law and highly respected by all the Jews living there. 13 He stood beside me and said, ‘Brother Saul, receive your sight!’ And at that very moment I was able to see him.
  7. 14 “Then he said: ‘The God of our ancestors has chosen you to know his will and to see the Righteous One and to hear words from his mouth. 15 You will be his witness to all people of what you have seen and heard. 16 And now what are you waiting for? Get up, be baptized and wash your sins away, calling on his name.
  8. 17 “When I returned to Jerusalem and was praying at the temple, I fell into a trance 18 and saw the Lord speaking to me. ‘Quick!’ he said. ‘Leave Jerusalem immediately, because the people here will not accept your testimony about me.’
  9. 19 “‘Lord,’ I replied, ‘these people know that I went from one synagogue to another to imprison and beat those who believe in you. 20 And when the blood of your martyr Stephen was shed, I stood there giving my approval and guarding the clothes of those who were killing him.’
  10. 21 “Then the Lord said to me, ‘Go; I will send you far away to the Gentiles.’ ”

 

Video

  1. Alistair Begg
    • Alistair Begg–Philemon, Part 1
      • Videos
        • Part 1
          • Video #1
            Channel :- Grace Bible Church
            Published on :- 2017-Jun-21st
            Link

Philemon

 

Videos

  1. Victory Church
    • Profile
      • Philemon is the story of a runaway slave named Onesimus. Stealing from his master and running away to Rome, Onesimus comes in contact with the apostle Paul. Paul then asks Onesimus to return to his master, even though he was a run away, even tho he stole. Onesimus owed a great debt. A debt he could not pay. Though his journey, we are shown an incredible picture of purpose, grace and redemption.
    • Videos
      • Video #1
        Channel :- Victory Church
        Published On :- 2015-July-7th
        Link
  2. Alistair Begg
    • Alistair Begg–Philemon, Part 1
      • Videos
        • Part 1
          • Video #1
            Channel :- Grace Bible Church
            Published on :- 2017-Jun-21st
            Link
  3. David Leone’, ‎Omega of Apostasy
    • Study in the book of Philemon (The Gospel Theater)
      • Profile
        • The book of Philemon has great insights into the great cosmic conflict and the stage in which the gospel is set.
      • Videos
        • Video #1
          Channel :- David Leone’
          Streamed live on Sep 19, 2018
          Link

 

In Depth

Alistair Begg

Alistair Begg–Philemon, Part 1

  1. Do you know how many will be converted if you take them under Christ
    • Barnabas
      • Luke 9

 

Transact SQL :- List Default Constraints

Background

List SQL Server Default Constraints.

Metadata

If one decides to use Sequences, one has to be able to document where it is being used.

Identity Columns

Identify Columns has self documenting tooling.

Inclusive :-

  1. sys.columns
    • is_identity
  2. sys.identity_columns
  3. OBJECTPROPERTY
    • TableHasIdentity
  4.  COLUMNPROPERTY
    • IsIdentity

Sequence

There is really nothing like a Sequence Column.

They are defined outside of a table definition.

It is not intrinsic so to speak.

It is a service that can be used as a communal toolset.

Outline

To detect use we can ask :-

  1. sys.columns
  2. sys.default_constraints
  3. sys.sql_expression_dependencies

Code


  set noexec off
 go

 /*
    exec sp_helpuser
 */
 if (
             ( SUSER_ID('rdsa') is not null )
        and  ( db_name() = 'master')
    )
 begin

    print 'We are on Amazon AWS/RDS and cannot create objects in the master database'
    print 'Please stop processing!'

    set noexec on
 
 end
 go
 
 
 if SUSER_ID('rdsa') is null
 begin

    use [master]
 
 end
 go
 

 if object_id('[dbo].[sp_helpConstraintDefault]') is null
 begin

    exec('create procedure [dbo].[sp_helpConstraintDefault] as ')

 end
 go

 alter procedure [dbo].[sp_helpConstraintDefault] 
 as
 begin
  
   select 

              [schema]
                = tblSS.[name]

            , [object] 
                = tblSO.[name]

            , [column] 
                = tblSC.[name]

            , [columnType]
                = tblST.[name]

            , [is_identity]
                = tblSC.is_identity

            , [is_rowguidcol]
                = tblSC.is_rowguidcol

            , [columnDefault]
                = tblSDC.[name]
   
            , [definition]
                = tblSDC.[definition]

            , [referencedObject]
                = quotename
                    (
                        tblSORefS.[name]
                    )
                    + '.'
                    + quoteName
                        (
                            tblSORef.[name]
                        )

            , [referencedObjectType]
                = tblSORef.[type_desc]

    from   sys.columns tblSC

    inner join sys.types tblST
            
        on  tblSC.system_type_id = tblST.system_type_id

        and tblSC.user_type_id = tblST.user_type_id

    inner join sys.objects tblSO
            
        on tblSC.[object_id] = tblSO.[object_id]
    
    inner join sys.schemas tblSS
            
        on tblSO.[schema_id] = tblSS.[schema_id]

    inner join sys.default_constraints tblSDC

        on  tblSC.object_id = tblSDC.parent_object_id

        and tblSC.column_id = tblSDC.parent_column_id

    left outer join sys.sql_expression_dependencies AS tblSSED 
        
        on tblSC.[default_object_id] = tblSSED.referencing_id

    left outer join sys.objects tblSORef

        on tblSSED.referenced_id = tblSORef.[object_id]

    left outer join sys.schemas tblSORefS
        on tblSORef.[schema_id] = tblSORefS.[schema_id]

    order by

              tblSS.[name]

            , tblSO.[name]

            , tblSC.[name]
    
 end
 go

 /*
    We are on RDS, please skip marking as system object!'
 */
 if SUSER_ID('rdsa') is null
 begin

    print 'Marking [dbo].[sp_helpConstraintDefault] as system object ...'

    exec sp_MS_marksystemobject '[dbo].[sp_helpConstraintDefault]'
 
    print 'Marked [dbo].[sp_helpConstraintDefault] as system object!'

 end
 go

 set noexec off
 go

Output

Output – Sequence – #1

Output – Database – Idf – #1

 

Source Control

GitHub

Repository

DanielAdeniji/dbo.sp_helpConstraintDefault
Link