October 2008 Archives

I was in Fry’s (a local electronics superstore) and asked the clerk (a young black man) if he was going to vote. He said “Why? They’re both the same. Nothing ever changes…” I was nearly speechless. I told him that he must be willing to let others decide how the world around him will work—or not. He said “It doesn’t matter—things never get any better.” I shook my head as I walked away. I’ll never forget his look of cynicism and hopelessness. I expect he, like many others has given up. It’s not surprising. I’ve lived long enough to witness and vote in many elections; however, I can’t say that I’ve ever seen an election that has so polarized the country. I saw polarization after each of the Bush elections—one that he lost and the second where the country lost—but not this bad. This time, people on both sides say that the world will end if their side loses. If this is true, American is really lost.

I challenge the new President to bring us together as a country—to restore our faith in the American form of government. This will take considerable work on the part of the President and the Congress but even more on our part to keep them all honest and keep their promises. If we don’t succeed, we’re all doomed to repeat the history of the Roman Empire and the representative forms of government that have failed in the past when the citizens lost faith in their elected leaders.

Dino Rossi Call

| No Comments | No TrackBacks

Dino has hired both a robo-call as well as a directed in-person call center. When I answered, they wanted to speak to me personally (by name). Next, the caller wanted me to vote for Rossi. I asked him "Why?". He said he didn't know--he was in florida and didn't know anything about the candidate or even where he was calling. I told him I would not be voting for someone who ran a dishonest campaign. He said fine...

I guess you get what you pay for.

McCain Supporters

| No Comments | No TrackBacks

Remember, a vote for McCain puts Sarah Palin a vote closer to the Presidency. Given McCain's age and medical history, history of stage IIA melanoma, kidney stones, high blood pressure and six pre-cancerous polyps in his colon, it makes me nervous that Ms. Palin's a heartbeat away from the most important job in our scandal-tainted government. Sure, these medical conditions are typical of a man his age but we expect the President to take on one of the most demanding jobs in the world. The fact that Senator McCain chose this incompetent for the Vice Presidency is another sign of his inability to think clearly under pressure and keep the country's best interests in mind. Sarah Palin is not Geena Davis; I expect that Geena has more sense of the importance and gravity of the office. If Sarah Palin had the least concern for the country, a real love of America and not a selfish motivation for self promotion she would not have accepted this nomination. Unfortunately, being elected governor while still promoting the seccession of the state says a lot about her love for the country. Sadly, she is too ignorant to know what it takes to be President. No, I don't think she's that smart--not smart enough nor experienced enough to know what she does not know. If God-forbid McCain is elected, all we can do is pray for him and the country.

Stuff I Learned Today...

| 1 Comment | No TrackBacks

How many times have you opened a directory in Vista only to discover it's being shown using the wrong display format? For example, you might want to just browse the files in "Details" format or see that set of pictures you took at Aunt Bessie's party in "icon" format. Well, did you know that if you hold down the Ctrl key and use the mouse wheel that the View changes? I didn't until today when I did it by accident. Of course, it might be nice if Vista would actually friggen remember the view I assigned on my last visit, but this is far better than having a random view show up and having to mouse around to select the right view...

I hope this helps.

Technorati Tags: ,,,

On the public newsgroups today, in response to a Visual Basic 6.0 (VB6) developer trying to morph an application to VB.NET (for an AS400) I responded:

George... you're going through the same issues millions of VB6 developers have faced over the years since VB.NET and ADO.NET were introduced.

MON2008-E.jpg I'll be giving my popular pre-con workshop and a couple of data access sessions. Be sure to register early as the workshop has sold out in the past.


I'm back at Developer Connections this fall with two new talks as well as my popular workshop. And there is something entirely new this time--a session to help folks get started as technical writers.

Reblog this post [with Zemanta]

VSLiveDallas.gifThey tell me that if you register with my promotion code (SPVAU), you'll get a $300 discount--that should pay your airfare from anywhere in the US but Cleveland.

Folks, we're at that rare point in time when the developer community can have some modicum of influence on how the next version of Visual Studio will work. I highly encourage everyone to get active and start pinging the development teams with your issues, bugs, wish-lists and gripes. No, you don't need to be negative, as VS has come a long way over the last decade but there are still many issues that are left unresolved over several versions so we (all) need to be persistent and vocal. I have outlined a few of these issues below. Do they sound familiar? Sure, these are the same issues we've been asking for since.... well, for a very long time.

Folks, if you aren't paying attention you might wake up on November 5th to discover that the election does not reflect your or your neighbor's votes. I think it's a monumental scandal how we as technologists have permitted our states to get into this situation. Take some time and see if you can help or influence your local precinct/county/state election boards to get these issues fixed. I also suggest you keep abreast of the ever-evolving situation by subscribing to the Daily Voting News newsgroup.

For some reason, I have been unable to create new SSMS 2008 projects or open existing projects without getting a "Class Not Registered" exception or simply an empty project/solution window. I did see a response from a fellow MVP that suggested I need to apply SQL Server 2008 Customer Update 1 (CU1) but not before I had attempted to "repair" my existing installation. Unfortunately, this triggered a number of other issues as discussed below:

This short entry is simply a discussion of what happens when you attach a populated database to a different SQL Server. I do this all the time when I build demo systems or move test databases into production.

Sears Service--A Dissapointment

| No Comments

My wife woke me from a sound sleep at 1AM when she discovered that the cold-water feed hose to the washer had burst. We cleaned up the water as best we could and called Sears as the washer was supposedly covered by a maintenance agreement. The washer (and dryer) were purchased at Sears in 2002 to replace machines purchased from Sears when we moved into the house many years earlier. All of these machines were under Sears Master Service maintenance agreements. Sears removed the old units and installed them--I assumed that they had replaced the water hoses that connect to the house--apparently they did not replace the cold water line (which ultimately failed).

What I Believe...

| 1 Comment

Finding myself in a strange time zone (Tulsa, OK) this week and not able to sleep, I passed the time surfing the hotel's 20-some-odd TV channels. My God, there are a lot of nuts, bigots and radicals out there. I had no idea that there were so many people that think they have the answers to the country's (and world's) problems but who clearly have no clue. Yes, some seemed quite sane, but for too many of the others, I wonder where they got their education and why CNN gives them airtime. Cynically, I expect that giving airtime to these radicals sells soap. My biggest issue is with a CNN newscaster who was fear mongering like the water had risen in Atlanta to the point where it was splashing around her chin. She frothed that people all over the country were panicking as their 401Ks, retirement funds, kid's school money and life savings were dissolving before their eyes... Ah, it's no wonder ordinary people are panicked. I guess I forgot that too many people get their education from watching late-night movies. Unless the Republicans privatize Social Security, it's still paying benefits and will do so for some time--most entitlement programs are totally unaffected by the financial crisis. Yes, your 401K, SEP or IRA might have lost value, but it might also have a cash component that's drawing a low interest rate. It's time to HOLD those stocks, not sell them. Those that sell DO lose value. It's too late to sell. As far as that spare cash earning a low rate of return, it's wise (in my opinion) to move it INTO stocks that have a good long-term future. Today is not a replay of "It's a Wonderful Life" where banks were not insured.

On "entitlement" programs. Ah folks, being near retirement and having paid into Social Security since 1965 when I entered the workforce (that's 43 years), take umbrage at those that think of Social Security as some sort of welfare. Yes, (unlike government workers like Congressmen and Senators and their staff) I was forced to put part of my wages aside in anticipation of drawing the principle back out now that I'm of age. Yes, if I had invested the money myself or the government had put it in private hands I would have very little at this point and the country would be more panicky than it is. 

What I also found in the USA Today dropped at my doorstep was a full-page ad placed by the NRA that all but fomented outright hatred of the Democratic ticket and might, just might, push some ignorant nut over the edge to take his "hunting" assault rife and kill someone. I hope to God that it doesn't. IMHO, the NRA should stick to making America safer for everyone--that does not mean putting weapons in the hands of every school kid, college student, teacher, lawyer, ignoramus or Supreme Court justice who feel its their right to shoot first when threatened--or when they even think they are threatened.

I also saw some very frightened people on TV who have been convinced by the passionate Republican rhetoric that Senator Obama is fundamentally evil and not to be trusted any more than some 60's radical terrorist. Some elderly woman in a Republican town hall revival got up, and in a trembling voice said Senator Obama was "...a ... an Arab!". Yes, Senator McCain said, "No, he's an honorable man", but he did not deny that Senator Obama was an Arab. He went back to his speech to further vilify Senator Obama. But what if Senator Obama is an Arab? He's not, but what if he were? What possible difference would it make? These same people think Jesus was white and probably from somewhere in Ohio. Clearly, the "heartland" of the country is still infected with the cancer of racism, ignorance and outright stupidity. Perhaps an Arab would know how to deal with the crisis in the mid-east better than one raised under the guidance of a Navy Admiral that was rarely home. No, the Republican apparatchik running the McCain campaign are not stupid or ignorant but they do know how to whip up the fears of these folks who were convinced to vote for the worst President in the history of the United States because he was on "God's side" or he had better morals than Senator Carey or Senator Gore. They're trying to do it again. Their powerful friends that circle Washington like so many remora know this too.

Personally, I object to the term "Red State" or "Blue State". If you plot the distribution of Democrats and Republicans from the last Presidential election on a precinct basis, you'll see a very different picture. It makes it clear to me that too many Republican supporters are from states where education is slipping, or slanted. Several sites have re-plotted this data to better represent the data visually--to give one a clearer idea of the distribution of the voters and how really close the last election was. http://www-personal.umich.edu/~mejn/election/ is an example. IMHO, it shows that in rural areas, the Republicans do better. Closer to cities, universities and other places where more educated people live (and vote), the Democrats win. CNN is still using this either/or (Red or Blue) approach for some of their maps but have changed some presentations to show shades of blue and red. Too bad their commentators are so radically biased--toward insanity and hyperbole.

The biggest problem as I see it, is if either Senator is elected, the country will be more divided than ever--thanks to the filth, carefully couched bigotry, lies and manipulations of the truth excreted past the sphincter muscles of both parties. I really worry that either candidate might be assassinated even before they took office given the inflammatory rhetoric. And if McCain is assassinated we would be faced with the first President who speaks in tongues, but barely knows the names of the Supreme Court justices--a person who would be ideal for the same Republican apparatchik manipulating the campaign and who have manipulated the Presidency for eight years.

I think that we as a country need to regain the moral high ground. This is not to say we as individuals or as a country are better than others but we live by our faith in God--Moslem and Christian, Jew and Buddhist, and all the rest. Frankly, we're not--not enough of us at least. It's ignorant and blasphemous to insist we're the "best" country. We're not. We might have been, but that age has long since gone. We don't learn from history, but that's a common failing. We no longer manufacture much of what we wear, the electronics we use, and too little of what we eat. Does that makes us better? Does consuming more than any other country (more than some entire continents), being more obese, wasting more, polluting more, imprisoning more make us better? Does killing and wounding tens of thousands a year with guns make us better? Does spending billions on wars but a tiny fraction of that on peace make us better? Is a country where impaired drivers kill more than 40,000 people a year and where we lose more young people to drugs make us a better country? Does having an ever-growing teenage pregnancy rate, or being are responsible for eliminating more species than any country, or having the biggest corruption scandals make us better? Does electing the worst President in history (twice) make the United States best? Our workers kill themselves trying to be productive--and they are, but Congress has moved millions of their jobs overseas--does that make us the best or the most exploited by the wealthy? Our elected government has permitted China to get a death-grip on our economy by opening the doors wide to their often shoddy, unsafe and contaminated imports built in factories where the workers are paid like slaves (or are slaves pulled from their prisons). Does this make the US better? Does electing a Congress that makes anti-corruption and anti pork rules only to ignore them to benefit their political supporters and lobbyists make us a better country? Hardly. We as a country, torture, imprison and extradite anyone we want to off to who knows where; places where US laws can't protect them. Until extraordinary rendition and torture is stopped and those who perpetrated these crimes are themselves sent to Guantanamo or to one of the gulags the CIA has created, we cannot call ourselves a moral country.

It's tough (very tough) to be proud of a country that can't seem to understand that it's not a good idea to elect men and women based on the color of their skin when their heart is black. No one is perfect. Clearly, no one expects an elected official to be pure. We do expect them to be honest--more honest than me. I expect them to be smart--smarter than me. I also expect them to be a better leader than me. Electing a good-ole' boy because he or she grew up in a small town and was confronted with small-town or small state problems is not enough. Electing someone like me, like many of us, is neither wise nor a way back to solid moral leadership.

As I see it the problem might just boil down to a failed education system. Today, thanks to "No child left behind" our schools are corrupted with lesson plans purged of the curriculum that teaches our young people to think for themselves, how to tolerate each other and live in peace. Nowhere does the curriculum teach them to know the difference between the truth and a lie or the gray area in between. As a result, our uninformed adults are easily swayed by politicians and TV ads. Too many sit around coffee shops and beer halls spouting off ignorant racial slurs and bemoan the state of the country but continue to elect the same people that put the country where it is.

We see too many of our kids and young adults are programmed by the media for immediate gratification, to consume, to yearn for goods they can't afford so they go into debt or rebel as they try to fit into this hedonistic consumer society. Some revert to crime and others rack up monstrous debt and the banks and payday loan companies prey on their ignorance and sloth--and the government lets them. High school graduates (and some college graduates) are too ignorant to know how to balance a checkbook, fix a faucet or change a tire or keep themselves healthy without quack medicines--and the drug companies prey on their ignorance--and the government lets them. Kids are encouraged in every magazine and film to have sex but our schools, and parents don't help them learn how to keep from getting pregnant. At the same time, churches and "moralists" are promoting abstinence while the schools are too frightened of the churches to teach birth control. The result is more ignorant kids having ignorant kids.

To me, the moral high ground means that we as a country make it possible for everyone who wants an education gets one--an education free of religiously or politically-guided dictums, at least a practical education that teaches life skills. How to study, how to read a contract, how to negotiate, how to save and how to spend wisely, how to build credit, how to give a good day's work, how to get and keep a job, how to use basic hand-tools, how to fix and maintain the stuff we buy, how we as citizens got to this point in time, what mistakes we made in the past, how to share, how to build and tear down, how to be a friend or partner or lover, how to conserve, how to clean and be clean, how to play fairly, how to keep our bodies strong and healthy, how and what to eat, how to read, write and review critically, how to listen and speak intelligently, how to understand and tolerate other points of view, how to lead and how to follow, how to love and treat others with compassion, how to be generous, how to be wealthy and what to do if you're poor. We also need to teach our citizens what they need to do to makes a good, moral, strong and safe country and how the US can be that country once again. Along the way we need to teach math, science, literature, art and philosophy as well as help kids learn sports and teamwork--even those too unskilled or physically unable to play.

We also need to learn how to tolerate, accommodate and live alongside others that are different. In my opinion, our nation's diversity is a great strength and one of our greatest challenges. We need to learn that being straight or gay or lesbian, a man, a woman or something in-between does not have to mean anything in particular. It does not mean that individual or couple does not value the sanctity of a personal union or the devotion to naturally born or adopted children. It does not make them unfit for service or any particular job. I also does not give one the right to inflict their point of view on others who might not agree with their point of view. Yes, it's hard to tolerate someone that's different but we've fought too many wars and lost too many lives over intolerance. 

Yes, I also believe religious education, proselytizing and indoctrination should be performed at a place of worship or in the home, not in the public schools, on the floor of Congress or in the workplace. Wanting to achieve the moral high ground means we don't imprison or persecute  people for addictions, or being poor, not agreeing with our point of view or not being educated. I think we should treat the addicted, ban addictive products (or at least stop subsidizing them), discussing our differences and providing basic education to the ignorant. It also means we as a nation don't torture or kill those we imprison--regardless of the crime or how much information we think they know or how evil their crime. It means we make the nation's courts available to everyone. It means we figure out how to accept those that want to visit our country to work without criminalizing them. It means we treat everyone fairly regardless of their sex, sexual orientation,race, creed, color or the country where they were born. It means that we attempt to accept that every religion thinks it's the only true faith and they have a right to think so. Ironically, most of the world religions worship the same God but I believe those that don't are also children of God and should be tolerated as such. No one should force their beliefs on another--not even if the belief is "democracy". It means we don't permit individuals or companies to promote, sell or distribute products that are harmful to our citizens or the citizens of any country. It means we don't impose our addictions, hatred, greed or intolerance on others. It means we tell the truth. It means we don't distort the truth or hide the facts when we're caught. It means we plead guilty when we are and innocent when we are.

The moral high ground also means we treat our planet with the same deference we treat our own bed. It means we don't foul its air, water or pillage its resources. It means we leave room for the plants and animals that God place here and placed in our stewardship. It means we do everything we can to leave the Earth as God gave it to use so those that inherit it (our own children) have a safe, clean, healthy place to live--and don't curse us for the filth we left behind.

I truly believe that if we don't come together as a country and address these problems, we are doomed to repeat history and follow one great civilization after another that have slipped into anarchy and destruction. The ignorant, unwashed masses are at the innocent pawns and soldiers of those who would pillage the country, sucking out it's blood to feed their greed, lust and avarice. The educated and caring are carried up into the conflagration as often they're too lazy, complacent or ineffectual to do anything about it until it's too late.

Stuff I Learned this Week

| No Comments

INETA sent me to Tulsa Oklahoma this week for the Tulsa Techfest. My experiences with the newly renovated Crown Plaza hotel notwithstanding, it was a nice trip. It seems that the hotel decided to put me on the newly renovated top floor--where the thermostats were miss-wired--all they cold do is cool... and cool...and cool.

I sat through Brad McGehee's SQL DBA talks and learned (or was reminded of) a few tip that I thought I would share. Some of these tips are pretty obvious but it seems not universally applied.

  • If your SQL Server Connection is throwing exceptions, check the NIC. As I had suspected for some time those strange "network exceptions" that occur from time to time on isolated machines might very well be due to having the NIC set to "Auto Detect". If a down-wire component (switch, hub, router) is not set to the right (LAN global) speed, the NIC retries can bring down the connection but not deterministically--just often enough to keep you from getting any sleep.
  • Remember to defrag your hard drive before installing a new database and pre-allocate the .MDB and .LDB files used by the master and user databases and tempdb.  This means the file system won't have to churn while fetching data.
  • Put the user, system and tempdb databases on separate physical volumes.
  • Set the Autosize option to stretch the database in fixed amounts, not a percentage (the default). This means 20% of a 5 GB database won't bring your file system to its knees.
  • Disable AutoShrink. This helps performance by not constantly checking to see if the DB can be shrunk. Note this might make sense for SQL Express where user filespace is at a premium. However, I recommend (even for SQL Express) that you plan to install a dedicated (albeit cheap) server so this is not an issue.
  • Don't use UPDATESTATISTICS and INDEX REBUILD/REORG--they're redundant and could actually hurt performance.
  • Never use SA for applications. Create a special account for system administrator work and protect the password(s).


Handling Multi-Select Parameters in Reporting Services Reports

Before I left for my trip to Tulsa, I finished another article for SQL Server mag (or whoever will buy it) on handling multiple selection parameters for Reporting Services. This is a feature implemented late in the RS 2005 cycle and rebuilt for SQL Server 2008 (or it seems so as it works). The way the Report Processor accomplishes this is through use of a WHERE clause IN expression. However, it seems that you're supposed to figure this out on your own. Basically (and there's a lot more detail in the article),

  • Create your SELECT query with a WHERE clause IN expression as shown below:

SELECT Col, Col2, Col3
FROM MyTable
WHERE myCriteriaCol IN (@InputListOfValues)

No, this won't work in TSQL as the IN expression does not take a parameter. However, the Report Processor knows what to do. You should also avoid use of the named parameter elsewhere in the WHERE clause. Note that the "choose all" option is handled by the Report Processor-generated UI.

  • Next, using the new Report Designer's Report Data window, configure the Parameter to accept multiple selections from the user.
  • Program the parameter "Acceptable Values" to be populated with fixed values or values drawn from another query.
  • Set the default (if you want to). I don't recommend setting a default value for all parameters as it causes the report to be executed before the user gets to choose what they want to see in the report. No, you can't use <Null> as a default with a multi-select parameter.
  • Test the report

When the Report Processor takes off an interprets the report RDL, it substitutes a delimited string ( 'Red', 'Yellow', 'Blue') into the parameter placeholder in the TSQL query. This means everywhere the @InputListOfValues is referenced in my query the parameter value will be inserted. This is not how "normal" parameters are managed in TSQL (which eliminates the possibility of SQL Injection attacks) so there might be a concern for this type of attack. However, consider that the user is not permitted to enter a parameter here--simply chose one, many or all of the options provided.


Powered by Movable Type 4.21-en

About this Archive

This page is an archive of entries from October 2008 listed from newest to oldest.

September 2008 is the previous archive.

November 2008 is the next archive.

Find recent content on the main index or look in the archives to find all content.