Christianity and the Snake Show

Background

Again an area that is likely best left untouched.

But, the truth has its own value system.

Foundational

There are a couple of passages in the New Testament (NT) that speaks to the contact spots of worship and snakes.

Here are those verses:

And these signs shall follow them that believe: In my name shall they cast out devils; they shall speak with new tongues. They shall take up serpents; and if they drink any deadly thing, it shall not hurt them; they shall lay hands on the sick, and they shall recover. (Mark 16:17-18)

Behold, I give unto you power to tread on serpents and scorpions, and over all the power of the enemy: and nothing shall by any means hurt you. ( Luke 10:19 )

Shows

Here are some clips that cover Christianity and the snake shows:

What the dying really regret

 

Sharing without permission:

Dying regret body hate, by Kerry Egan
http://www.cnn.com/2014/10/16/health/dying-regret-body-hate/

“I know I’m supposed to hate my body,” the patient said in her soothing Southern drawl.

She pushed away her lunch, a brown lump and pile of orange. Her son spent a lot of money to have low-fat, no-sodium, no-sugar, low-calorie meals delivered to the house while he was at work and she was home alone.

They looked like piles of wet rocks.

“I really could die happy if I was allowed just one more bite of caramel cake,” she said with a sigh. The woman was dying of cancer, and I was her chaplain. “I don’t suppose you have any?”

“No, sorry. But why are you supposed to hate your body?”

“Well, Kerry,” she looked incredulous that I even asked and laughed. “Because I’m fat!”

She ran her soft hands over her ponderous breasts and her mounding, cancer-ridden belly. She spilled over the sides of her recliner. “I’ve known that since I was little.” She examined the crocheted blanket on her lap.

“Everyone told me — my family, my school, my church. When I got older, magazines and salesgirls and boyfriends (told me), even if they didn’t say so out loud. The world’s been telling me for 75 years that my body is bad. First for being female, then for being fat and then for being sick.”

She looked up and this time tears trembled along her bottom eyelids.

“But the one thing I never did understand is, why does everyone else want me to hate my body? What does it matter to them?”

There are many regrets and unfulfilled wishes that patients have shared with me in the months before they die. But the stories about the time they waste hating their bodies, abusing it or letting it be abused — the years people spend not appreciating their body until they are close to leaving it — are some of the saddest.

Because unlike the foolish or best-intentioned mishaps, the terrible accidents, the slip-ups that irrevocably change a life, this regret is not a tragic mistake. It’s intentional. It’s something other people teach them to feel about their bodies; it’s something other people want them to believe.

Sometimes, it’s based on their allegedly unattractive physical features. They might be ashamed of their weight, their body hair, their thin lips or droopy eyes.

But this body hatred can also come from a religious belief about the sinfulness of their bodies. It isn’t always the media and peer pressure that create this shame; sometimes it comes from a pastor or Sunday school teacher, or lessons at home that begin at birth and seep in along with mother’s milk. Some women grow up thinking that their very existence in a body that might be sexually attractive to someone else is cause for shame — that their bodies make bad things happen just by existing.

Either way, the result of the messages is the same: They lived their lives thinking their bodies were something to tolerate at best, something to criticize, to despise, at worst — a problem they could never correct.

Too often, it’s only as a patient realizes that he or she will lose their body that they finally appreciate how truly wonderful it is.

“I am going to miss this body so much,” a different patient, many decades younger, told me.

She held her hands up in the dim light that seeped through the sunshade on the window. She stared at them as though she had never seen them before.

“I’d never admit it to my husband and kids, but more than anything else, it’s my own body I’ll miss most of all. This body that danced and ate and swam and had sex and made babies. It’s amazing to think about it. This body actually made my children. It carried me through this world.”

She put her hands down.

“And I’m going to have to leave it. I don’t have a choice. And to think I spent all those years criticizing how it looked and never noticing how good it felt — until now when it never feels good.”

It isn’t just health that they wish they had appreciated. It’s the very experience of being in a body, something you likely take for granted until faced with the reality that you won’t have a body soon. No matter what you believe happens after death, be it an afterlife, reincarnation or nothing at all, the fact remains: You will no longer be able to experience this world in this body, ever again.

People who are dying face that reality every day.

So they talk about their favorite memories of their bodies. About how the apples they stole from the orchard on the way home from school tasted, and how their legs and lungs burned as they ran away. The feel of the water the first time they went skinny-dipping. The smell of their babies’ heads. The breeze on their skin the first time they made love outside.

And dancing. I’ve heard so many stories about dancing: USO dances during World War II; shagging at South Carolina beach houses; long, exuberant nights dancing at roadhouses and discos and barns. I can’t count the number of times people — more men than women — have closed their eyes and said, “If I had only known, I would have danced more.”

While these wishes and regrets are sad for each individual, they raise questions about how we all live our lives.

What does it mean that so many voices out there insist that the body is something to despise because it is too fat, sinful, ugly, sexual, old or brown? That we teach each other, in thousands of blatant and quiet ways, to think we are shameful? That our bodies are something to be overcome, beaten into submission or to be despised?

How do these voices telling us that we are supposed to hate our bodies affect our notions of how we care for the sick, disabled, elderly, children, mothers, soldiers, workers, immigrants, men and women? What we believe about our bodies affects how we treat other bodies, and how we treat each other’s bodies is how we treat each other.

“You know what, Kerry?” my cake-loving patient asked as she ran the sleeve of her nightgown across her eyes. “Even though I was fat, even though I got pregnant when I was wasn’t married, even though I’ve had this cancer for 20 years, and I haven’t had any hair in years … I don’t hate my body. They were wrong, and they always have been.

“I thought I was going to die for so long, I figured it out. And that’s why I’ve been happy anyway. I just need to figure out how to get some caramel cake into the house.”

Listening

Live like you are dying
https://www.youtube.com/watch?v=_9TShlMkQnc

Outlook – Add In – Exception – Add-In Conflicts and that “Conscious Uncoupling” thing

Background

One of our users in the Far East is experiencing all kinds of warts using Outlook to book meetings.

Error Message

Textual

CondecoAddinV5 has fired an exception.  Click the ‘Details” button to see the detailed information about the error.

Image

CondecoAddInV5HasFiredAnexception-Long

Other errors popped up:

Such as “File Download – Security Warning”.

FileDownloadSecurityWarning_v3

Diagnosis

In our case, we had a plethora of Outlook Add-Ins and they were not playing nice with each other.

Here is the list of Add-Ins:

AddInOptions

Click the Go button ( to the right of COM Add-ins )

ComAddIns

Uncheck “Microsoft Outlook Social Connector”.

ComAddIns (After)

And, that fixed it.

Crediting

Goto File->Options->Add-Ins, at the right bottom of the screen, you will see Manage -> COM Add-ins, click on Go, from the list of options uncheck this option: ‘Microsoft Outlook Social Connector’, click on OK. Restart Outlook and see if it fixes the issue” — Manoj Agarwal

Listening

Listening to Mike & The Mechanics – The living Years ( https://www.youtube.com/watch?v=uGDA0Hecw1k ).

SQL Server Reporting Services – Globals!ReportServerURL returning http://localhost

Background

We will like a bit more flexibility in our Reporting Services Dashboard.

As such to avoid hardcoding links to child reports, we are trying to programmatically inquire for the current Report Server URL.

 

Global Variable

As always in the Microsoft world, there is a way to do so:

We simply access one of the Global Variables.  The name of the Global variable, in this case, is Globals!ReportServerUrl

 

Use Case Scenario

So in our Text box / Action, we specify :

  1. Enables an action :- Go To URL
  2. URL :- ( And here is the code we have for our URL ):

 

Here is the code :

="javascript:void(window.open('" + Globals!ReportServerUrl + Microsoft.VisualBasic.Strings.ltrim(Fields!url.Value) + "','_blank'))"

 

Error Message

No earth shattering error message, but no go!

The child reports  do not come up as the system prefixes them with http://localhost and not the actual SQL Instance URL.

 

Resolution

Access the instance instance specific rsreportserver.config file.

The relative folder path and file name is ReportingServices\Reportserver\rsreportserver.config

Original

Here is the original entry

<UI>
<ReportServerUrl>
</ReportServerUrl>
</UI>

Corrected:

And, here is the revised:

<UI>
<ReportServerUrl>
http://rsreportserver:8080/ReportServer/
</ReportServerUrl>
</UI>

Explanation:

So our problem is that somehow our ReportServerURL was empty, and the system was defaulting to localhost.

 

Other Interesting parameters

You also should keep an eye on a couple of other set of URLs.

Those are:

  1. URLReservations\Application\ReportServerWebService\URL
  2. URLReservations\Application\ReportServerManager\URL

 

URLReservations

Outlook – Add In Options – Error Message – “The end date you entered occurs before the start date”

Background:

Back pulling down Remedy Tickets and found a nice and easy one.

Error Message

Textual:

The end date you entered occurs before the start date.

Image:

TheDateYouEnteredOccursBeforeTheStartDate

What Happened?

I am thinking to myself, I did  not enter any dates.  All I did was:

  1. Launched Outlook
  2. Via Outlook menu, access File \ Options
  3. The Outlook Options window appears
  4. In the “Outlook Options” window
    • From the left panel, click the “Add-Ins” option
    • On the right panel, click the “Add-In Options” button

Resolution

  1. Accessed Control Panel, date and time applet
  2. Changed time zone to something else
    • Click the “Change time zone” button
    • Choose a new Timezone
  3. Exit Outlook and restart
    • Make sure things work
  4. Revert time zone to your actual time zone

Screen Shots

Control Panel \ Date and Time

ChangeTimeZoneBefore

Registry

Btw, before making changes you might want to take a backup of the registry branch that covers TimeZone Information.

The registry branch is :HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation

RegistrationEntry

Summary

Why the error message “The end date you entered occurs before the start date” in the first place?

Well in some cases the MS Windows Registry section for timezones get corrupted.  Corruption might be data or permission related.

One of the more surer ways to fix is to change the current timezone to something else, check outlook, and revert back to what it should be.

Reporting Services – Chart – Parameter Driving Vertical Axis – Maximum Value

Background

As we delved a bit more into Charting in Reporting Services, I thought it best to allow the user to choose which specific column the Y-Axis should be charted on.

Values

Guide

Code

SQL Server Stored Procedure

In Transact SQL code, we pass in a variable.

In our case, we pass in @columnValue and return @attributeValue based on the contents of @columnValue.


    select
               itvfB.*

            , [attributeValue]
                = case (@columnValue)

                    when 'NumberofItems' then itvfB.[TotalBookings]

                    when 'ScheduledHours' then itvfB.[ScheduledHours]
                    when 'ScheduledPercentile' then itvfB.[ScheduledPercentile]

                    when 'UsedHours' then itvfB.[UsedHours]
                    when 'UsedPercentile' then itvfb.UsedPercentile

                    else itvfb.UsedPercentile

                end 

    from   [report].[itvf_Trend]
                (
                     @dateStart
                   , @dateEnd
                   , @cityID
                   , @tvpBuilding
                   , @tvpDate
                   , @interval
                ) itvfB

Chart

Chart Data

In the Chart Data Property Sheet, we chose the “attributeValue” as the column to use for Values.

ChartDataValues

Vertical Axis Properties

In the Vertical Axis Properties sheet, we set the “Maximum” attribute based on whether we are charting based on Percent or not.

If we are charting on Percent, we want it top out at 100%.

On the other hand, if we are not charting on Percent, we will set at Nothing, and let the system adjust accordingly.

Expression:


=iif(instr(Parameters!reportTrendColumnValue.Value,"Percent")> 0,100, Nothing)

Image:

VerticalAxisMaxium

Output

Output – Chart on Hours

Here we are charting on Hours, and thus allow the system to choose the maximum Y axis.

NumberofItems

Output – Chart on Hours

When we chart on percent, the system sets 100%.

percentile

Summary

I am really impressed that SSRS gracefully handles setting Y Axis via such a simple expression.

Transact SQL – sp_MSforeachtable – Error Trapping

Background

As part of a data loading script, I disabled the foreign keys and now need to re-enable them.

 

Code

Simple Code

One simple straight forward way is to  use sp_MSforeachtable.

Here is the sample script.


declare @sql varchar(4000)

declare @command varchar(255)

set @command = ' PRINT ''?''; ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL; '

EXEC sp_MSforeachtable
@command1 = @command

 

Error Image:
error

Error Text:


[dbo].[tblToken]
[dbo].[tblBookingItem]
Msg 547, Level 16, State 0, Line 5
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblBookingItem_tblBooking". The conflict occurred in database "DBSchedule", table "dbo.tblBooking", column 'pkBookingID'.

The simple code has a problem in that it stops abruptly whenever data is missing from the referenced table.

Add Error Handling

To properly handle our error, let us add exception handle via BEGIN TRY / BEGIN CATCH.


declare @sql varchar(4000)
declare @sqlErrorTrapped varchar(4000)

declare @command varchar(255)

set @command = ' PRINT ''?''; ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL; '

/*
EXEC sp_MSforeachtable
        @command1 = @command

*/
set @sql = @command

set @sqlErrorTrapped
             = 'BEGIN TRY'
            + @command
            + ' END TRY '
            + ' BEGIN CATCH '
            +  'print char(9) + ''======================================================================================''; '
            +  'print char(9) + ''Failing Step: - Failed on ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL '' '
            +  'print char(9) + ''Error Message: - '' + ERROR_MESSAGE()  '
            +  'print char(9) + ''======================================================================================''; '
            + ' END CATCH '

EXEC sp_MSforeachtable
        @command1 = @sqlErrorTrapped

 

Output:

Image:

errorGraceful

 

Textual:


[dbo].[tblBookingItem]
	======================================================================================
	Failing Step: - Failed on ALTER TABLE [dbo].[tblBookingItem] WITH CHECK CHECK CONSTRAINT ALL 
	Error Message: - The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblBookingItem_tblBooking". The conflict occurred in database "CondecoR", table "dbo.tblBooking", column 'pkBookingID'.
	======================================================================================
[dbo].[tblOutlookPostDataBookingLink]
[dbo].[tblCateringMap]
[Event].[tblContact]

 

Now, even though we failed on one of the tables, the logic moves on to the next table.