SSRS 2008 - Adding SSL After Installation

If you can't get it to work, try doing everything in this thread:

http://prologika.com/CS/forums/t/946.aspx

And everything here:

http://technet.microsoft.com/en-us/library/ms345223(SQL.100).aspx


Also, SSRS 2008 does not support wildcard certificates, ie *.yourdomain.com. Obtain a special dedicated SSL cert YourServerName.yourdomain.com, then apply it on the SSRS 2008 server. This is what worked for us at a client, after calling PSS. This is a known issue at Microsoft and they are working on a better solution.

Slides and Code from Code Camp Presentation

T-SQL A Primer

T-SQL Slides and Scripts

Cool Control Panel View

This went around a few months ago, but in case you missed it, create a folder on your desktop and rename it to this: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

This will create a new control panel icon on your desktop with a ton of cool options.

Looks like this:

Data Explosion - Great Story

I got this story from Scott Cameron of Hitachi Consulting, although I've heard it before:

The story of the man who invented chess can help illustrate the problem of data explosion.

The man lived in India, and according to legend his name was Sessa. The king of India was very impressed with the game of chess and asked Sessa to name his reward. Sessa's request was so modest that it offended the king: He asked simply for one grain of rice for the first square of his chess board, two grains for the second square, four grains for the third, and so forth, doubling the number of grains of rice for each of the 64 squares of the board. Of course, by the time the king's magicians calculated the total amount of rice needed to pay the reward, they realized that it would require a warehouse 3 meters by 5 meters by twice the distance to the sun to pay the reward.

The king gave Sessa a sack, pointed him to the warehouse and told him to go count out his reward - no rush.

When numbers increase geometrically (like they do in a data warehouse), they get large very quickly.

Business Intelligence Quote

"You can spend millions building the data warehouse, but if you don't have the back office under control, you are wasting your money."
Mike Costa
Corporate Director of Quality Process & Architecture
The Dow Chemical Company

Feedback Loops - Donella Meadows

"Examples of compelling feedback is not hard to find. Suppose taxpayers got to specify on their return forms what government services their tax payments must be spent on....Suppose any town or company that puts a water intake pipe in a river had to put it immediately downstream from its own wastewater outflow pipe. Suppose any public or private official who made the decision to invest in a nuclear power plant got the waste from that facility stored on his or her lawn...Suppose the politicians who declare war were required to spend that war in the front lines.

There is a systematic tendency on the part of human beings to avoid accountability for their own decisions. That's why there are so many missing feedback loops."

She goes on to relate a story about Amsterdam:



"Near Amsterdam, there is a suburb of single-family houses all built at the same time, all alike. For some unknown reasons it happened that some of the houses were built with the electric meter down in the basement. In other houses, the electric meter was installed in the front hall.

It was discovered that the houses with the electric meter in the hall used 1/3 less energy."

She explains that this is because the feedback loop was available for all to see.

This is the main purpose of business intelligence. To provide a feedback loop that provides accountability at all levels of an organization.

Donella H. Meadows Quote

"Purposes are deduced from behavior, not from rhetoric or stated goals."
Donella H. Meadows
Thinking in Systems

"An important function of almost every system is to ensure its own perpetuation."
Same as above

Donella is not speaking of software systems, but rather behavior systems. She's speaking about the war on drugs, welfare, health care, national security, the environment, or any other societal or natural system.

"Keeping sub-purposes and overall system purposes in harmony is an essential function of successful systems."
Same as above

"We misperceive risk, assuming that some things are much more dangerous than they really are and others much less. We live in an exaggerated present - we pay too much attention to recent experience and too little attention to the past, focusing on current events rather than long-term behavior"
Donella H. Meadows
Thinking in Systems

"Usually the greater the discrepancy between the goal and the actual situation, the more emphatic the action will be."
Same as above

"The most damaging example of the systems archetype called "drift to low performance" is the process by which modern industrial culture has eroded the goal of morality. The workings of the trap have been classic, and awful to behold."
Same as above

"We know what to do about drift to low performance. Don't weigh the bad news more heavily than the good. And keep standards absolute."
Same as above