SQL Server 2017 – Developer Edition – ISO

Background

Currently, I have SQL Server 2014 Developer Edition on my laptop.

Recently found out that since my machine is now Windows 10, I can have SQL Server 2017 Developer Edition.

 

Download ISO

Let us go download v2017 Developer Edition.

v2017 is available here.

Available

Image

Textual

  1. Free Trial Evaluation
  2. Developer edition
  3. Express edition

Developer Edition

If we click on the “Download now” button underneath the “Developer edition“, we will notice that the name of the file that will be availed is SQLServer2017-SSEI-Dev.exe.

Already have that file and it is a small file.

I don’t really want a small file, I want the full ISO.

 

Self-Prepare ISO

Download Bootstrap

To get a nice ISO, please process with downloading SQLServer2017-SSEI-Dev.exe.

 

Prepare ISO

Outline

  1. Select an installation type
  2. Specify SQL Server Installer download
    • Which package will you like to download
      • ISO
      • CAB
    • Click on the Browser folder button
      • Choose an existing folder or create a new folder
      • Click the OK button
    • Click the OK button
  3. Download Media

Screen shot

Select an Installation Type

 

Specify SQL Server Installer download

Browse Folder

Download Media

Download Successful

 

Installed

Once the files was packaged into a nice ISO, was able to install it.

 

Conclusion

So unfortunately, it appears that one cannot download v2017 as a nice offline ISO.

But, please do not let that overly deter you.

Go ahead and download SQLServer2017-SSEI-Dev.exe and run it.

You will be able to prepare an ISO through running that package.

Bill Wiese

Videos

  1. YouTube
    • Videos
      • On November 23rd, 1998 Bill Wiese experienced something so horrifying it would continue to captivate the world for over a decade. Bill shares his terrifying experience as described in his book, “23 Minutes in Hell.” This powerful message will change your life! This video is taken from his DVD which is included with his 3rd book, “23 Questions about Hell.” Copyright 2010 by Bill Wiese. (DVD includes additional content).
        Link

 

In depth

  1. Wife
    • Married way over my Head
  2. Came back from Hell?
    • Question
      • Lazarus ( Luke 16 )
    • Response
      • I was not dead
      • This is a vision
  3. How can a christian see Hell
    • Can enter in Spiritual Body
    • Only in vision can a Christian see hell
    • Spirit & Physical Body
      • Ezekiel 8
        • Ezekiel 8 ( KJV )
          Link
      • 1st Corinthians 15
        • It is sown a natural body; it is raised a spiritual body. There is a natural body, and there is a spiritual body.
          Link
      • Revelation 5
        • Then one of the elders said to me, “Do not weep! See, the Lion of the tribe of Judah, the Root of David, has triumphed.
          He is able to open the scroll and its seven seals.”
          ( Revelation 5:5 )
        • And hast made us unto our God kings and priests: and we shall reign on the earth.
          ( Revelation 5:10 )
      • Genesis
        • And he brought him forth abroad, and said, Look now toward heaven, and tell the stars,
          if thou be able to number them: and he said unto him, So shall thy seed be.
          ( Genesis 15:5 )
  4. God hid it from my mind
    • but they were kept from recognizing him ( Luke 24:16 )
  5. Fear of the Lord
    • For who in the skies is comparable to the LORD? Who among the sons of the mighty is like the LORD,
      A God greatly feared in the council of the holy ones, And awesome above all those who are around Him?
      O LORD God of hosts, who is like You, O mighty LORD? Your faithfulness also surrounds You.…
      ( Psalm 89:7 )
    •  I will make an everlasting covenant with them: I will never stop doing good to them, and I will inspire them to fear me, so that they will never turn away from me.
      Jeremiah 32:40 )
  6. Passion to witness
    • Bill Bright
      • Only 2% of Christians witness
    • Charles Spurgeon
      • 90% of our witness is through our life example
        • Do we keep our word
        • Do we show up on time
        • Do we walk in excellence
        • Do we show forgiveness
        • All those things that people observe
    • Bible versus
      • Judgement
        • Knowing the terror of the Lord, we persuade men
          • Ministry of Reconcilliation
            Link
            11 Therefore, knowing the fear of the Lord, we persuade others. But what we are is known to God, and I hope it is known also to your conscience.
            12 We are not commending ourselves to you again but giving you cause to boast about us, so that you may be able to answer those who boast about outward appearance and not about what is in the heart.
            13 For if we are beside ourselves, it is for God; if we are in our right mind, it is for you.
            14 For the love of Christ controls us, because we have concluded this: that one has died for all, therefore all have died;
            15 and he died for all, that those who live might no longer live for themselves but for him who for their sake died and was raised.
            ( 2 Corinthians 5:11-15)
        • When I say to the wicked, ‘You wicked person, you will surely die,’ and you do not speak out to dissuade them from their ways, that wicked person will die for their sin, and I will hold you accountable for their blood.
          ( Ezekiel 33:8 )
    • Why did I not know you
      • Hopelessness
        • For the grave cannot praise you,
              death cannot sing your praise;
          those who go down to the pit
              cannot hope for your faithfulness.
          ( Isaiah 38:18 ) [ Link ]

 

 

SQL Server – Dynamic SQL Queries – Duplicate Plans ?

Background

In the last couple of weeks we have taken a sure aim at some of our dynamic queries.

This morning came in and started reviewing our cached plans and noticed that we might have duplicates.

 

Cached Plans

Image

Here is a slimmed down version of our cached Plans

Explanation

I was wondering why it seems I have duplicate entries filtering on timePeriod, stateLimit, and Phone.

The first entry has 2040 hits and the other 134 matches.

 

Comparison

SQL Server Management Studio ( SSMS )

I tried to compare the plans using SQL Server Management Studio v2017, but nothing jumped at me.

 

Dynamic Management Views

sys.dm_exec_plan_attributes

I also looked at the normal causes such as:

  1. userid
    • attribute user_id
  2. Set Options
    • Attribute set_options
      • Quoted Identifier
      • Ansi Nulls

 

Text File Comparison

I then saved the query plans into text files and used an online text comparison tool.

DiffNow

DiffNow is here.

From the few differences between the files, here is why my eyes finally rested.

Image

 

Explanation

  1. Saw that @stateLimit only appears in the second plan

 

In Code

Output

Using XQuery was able to confirm that different queries is indeed attributable to slight variation in filtering columns.

Parameter List

Sample 1

 

Sample 2

 

Take away

Thankfully considering text file comparison got me closer to identifying the causation of the “duplicate” plans.

Damon Thompson – Kinsman Redeemer

 

Videos

  1. YouTube
    1. Small Segment
      Link
    2. Full Segment
      Church :- Redemption Point Church Highland Park Campus,Chattanooga Tennessee
      Publisher :- Ricky Ricardo Smith
      Date Preached :- 2016-August-28th
      Date Published :- 2016-August-29th
      Link

Outline

  1. Redeem the Land
    • Passages
      • If one of your fellow Israelite’s becomes poor and sells some of their property, their nearest relative is to come and redeem what they have sold. ( Leviticus 25:25-28 )
      • Jeremiah said, “The word of the Lord came to me: .. your uncle is going to come to you and say, ‘Buy my field, because as nearest relative it is your right and duty to buy it.’” ( Jeremiah 32:6-9 )
  2. Redeem the Enslaved
    • Passages
      • “If a foreigner residing among you becomes rich and any of your fellow Israelites become poor and sell themselves to the foreigner or to a member of the foreigner’s clan, they retain the right of redemption after they have sold themselves.” ( Leviticus 25:47-55 )
  3. Provide Heir
    • Then Judah said to Onan, “Sleep with your brother’s wife and fulfill your duty to her as a brother-in-law to raise up offspring for your brother. ( Genesis 38:8-10 )
    • If brothers are living together and one of them dies without a son, his widow must not marry outside the family. Her husband’s brother shall take her and marry her and fulfill the duty of a brother-in-law to her. ( Deuteronomy 25:5-10 )
    • Moses told us that if a man dies without having children, his brother must marry the widow and raise up offspring for him. ( Matthew 22:23-28 )
  4. Justice
    • The avenger of blood shall put the murderer to death when they meet. ( Numbers 35:16-21 )
  5. Trustee for the Redeemed Land
    • Any man or woman who wrongs another in any way and so is unfaithful to the Lord is guilty and must confess the sin they have committed. They must make full restitution for the wrong they have done. ( Numbers 35:16-21 )
    • I will give you the keys of the kingdom of heaven ( Matthew 16:13-20 )

 

Passages

Redeem the Land

Leviticus 25:25-28

 

Jeremiah 32:6-9

Redeem From Slavery

Leviticus 25:47-55

 

Provide a Heir

Genesis 38:8-10

 

Deuteronomy 25:5-10

 

Matthew 22:23-28

 

Justice

Numbers 35:16-21

 

Provide Trustee for the Redeemed

Numbers 5:5-8

 

Matthew 16:13-20

 

What we are entrusted with ….

Intro

The last few months has been interesting.

 

Journey

Change Agent

There was a change I wanted to implement in our Development process, but I was not quite sure we had identified the right person in our Development group to make sure that the change will be well received and successfully carried to completion.

As chance will have it, some one sent me a script to deploy; as I reviewed the script, I suggested some changes.  The person actually received the suggestions and implemented them.

I suggested a couple of peripheral changes and he incorporated those as well.

Furthermore, he shared that he always wondered about same peculiarity in the system and he is happy that he now knows how to better accommodate it.

A week or two later he was let go as part of a cost cutting measure.

 

Guardian Angel

A story was told about a Guarding Angel.

A daughter was born and her mother soon became a single parent.

A man came forth promising employment within strict guidelines.

Both sides kept their ends.

Another lady came and gave money placed in a tidy envelopment.  Unrequested and Unexpected.  Asked why, she replied that the Lord asked her to do it.

That friendship lasted over twenty years.  And, only came to temporary suspension upon the Angel’s return to Heaven.

 

Nobility

It just so happens that there are organizational changes that we need to align with.

As these pieces are being moved and new homes tested out, natural and technical pairings are considered and given the opportunity to develop and nourish.

Better outcomes are more likely through nobility, upbringing, fellowship, self initiation, and ongoing commitment to growth.

 

Summary

Each of us is either headed into change or fastening our self in some change.

Both sides are more alike than we might first understand.

I pray encouragement, temperament, understanding, and providence in managing what we are entrusted with.

Tyler Cowen

 

Stories

America’s ‘Complacent Class’: How Self-Segregation Is Leading To Stagnation

With NPR associate editor Reena Advani
Link

In a new book, The Complacent Class, economist Tyler Cowen argues that the United States is standing still.

People have grown more risk averse and are reluctant to switch jobs or move to another state, he says, and the desire to innovate — to grow and change — has gone away.

In an interview with NPR’s Rachel Martin, Cowen says he’s worried that more and more communities are self-segregating — by income, education or race.

“We’re making decisions that are rational and even pleasurable from an individual point of view, but when everyone in society behaves this way — to cement in their own security, their own mobility — social mobility as a whole goes down, inequality goes up, many measures of segregation go up,” he says. “And ultimately a bill for this comes due.”

On how self-segregation leads to complacency

If you live in Arlington, Va., and if you move to Ann Arbor, Mich., or even Santa Monica, Calif., those places are more alike than ever before. But most importantly, segregation by income has gone up in virtually every part of this country. So wealthier people tend to live together more than before and so do poorer people. And this is bad for the country as a whole and we see a version of this in the last election where so many people are shocked by the candidate who actually won.

On what this complacency means

[I]f you cease being challenged and you think your way of life is the only way, ultimately that way will become weak, it will be subject to less improvement, you will enter a kind of bubble and continually be surprised by the challenges the outside world keeps on throwing at you. But you’re not very well-equipped intellectually to handle them.

On the fact that median male wage was higher in 1969 than it is today

It is truly a shocking fact. Now you could argue the measurements are not perfect, that’s true, but that even the numbers can come out that way. So many of the advances in our economy have come from women working more, working harder, getting more educated. That’s great. But when it comes to males, something has very badly gone wrong.

I think we have switched to a service-sector economy — most jobs are now service sector. That’s bad for some percentage of men. Jobs require more and more that you be skilled in information technology. That’s great for the top 1 percent, 10 percent, 15 percent. Not so great for the median or the bottom third for males.

On why he writes in his book: “The biggest story of the last 15 years, both nationally and globally, is the growing likelihood that a cyclical model of history will hold rather than a model of ongoing progress.”

In the 1990s, pretty much everything seemed to be going in the right direction. More countries were democratic, more countries were becoming free. Lately we see China, Russia, Turkey moving back in a much more authoritarian direction, significant parts of the Middle East up in flames. The forward march of progress is not the main story today.

The risk of an unraveling of the basic liberal globalized world order has been going up for some number of years now and only now do we see it with Brexit and the election of Trump. We need to take this risk very seriously.

On why he feels optimistic and not unsettled

I think of the ’80s and ’90s as very calm, smooth optimistic decades. But when you think back to our broader history — the Civil War, the Great Depression, the Vietnam War, Richard Nixon trying to undermine the Constitution — those are all terrible, deeply unpleasant events, but we did get through them. And I think viewed in a longer-run perspective, this country will recapture its dynamism. I think innovations that have been restricted to the tech sector will move through most of our economy.

At some point real wages will go up quite a bit more again. My hope is the current political mood is something we’re getting out of our system rather than a permanent change. So ultimately I would bet on optimism, but I think those big bumps in the road, they’re not distant. Right now we’re just at them.

NPR associate editor Reena Advani contributed to this report.

Videos

  1. NPR
    • America’s ‘Complacent Class’: How Self-Segregation Is Leading To Stagnation
      • America’s ‘Complacent Class’: How Self-Segregation Is Leading To Stagnation
        Published On :- 2017-March-2nd 5:08 AM ET
        Link
  2.  YouTube
    • Ted Talk
      • Be Suspicious of Stories
        • Be suspicious of stories | Tyler Cowen | TEDxMidAtlantic
          Channel :- Tedx Talks
          Published On :- 2009-Nov-8th
          Link
    • Politics & Prose
      • Tyler Cowen, “The Complacent Class
        Interviewer :- Derrick Thompson
        Channel :- Politics & Prose
        Published On :- 2017-March-8th
        Link