Welcome to Megan’s Space at Far2Go.net. You’ll find a short introduction here.
Aside
What???
I came across two stories that seem eerily related.
Operating In the Dark (NY Times Op-Ed)
The Web site of Representative Daniel Webster, Republican of Florida, instructs visitors to click on a link for “Census data for the 8th district” to learn about the area’s economy, businesses, income, employment, homeownership and other important features. And yet, on Wednesday, Mr. Webster declared that the Census Bureau’sAmerican Community Survey — the source for much of that data — is an unconstitutional breach of privacy…
I use the ACS in my work. We use the data in our advocacy work. It is a vital tool.
Here’s the other article:
In Robert E. Gamer’s book “The Developing Nations” is a chapter called “Why Men Do Not Revolt.” In it Gamer notes that although the oppressed often do revolt, the object of their hostility is misplaced. They vent their fury on a political puppet, someone who masks colonial power, a despised racial or ethnic group or an apostate within their own political class…
What these articles have to do with each other is left as an exercise to the reader. Hint: try reading them.
Migrating to SQL Server 2012, a tale of trial and error, part 2
My migration to SQL Server 2012 has actually been going rather smoothly. The other issues apart from the one I discussed earlier have been relatively minor, although some were time consuming to work out and some were annoying. Here is what I have run into so far:
“Discrepancy” error from Visual Studio/TFS 2008/2010
I originally wrote about this issue in 2010, I continue to see it from time to time, after something “disturbs” Visual Studio. It starts with an alert something like this appearing upon opening Visual Studio or BIDS:
Migrating to SQL Server 2012, a tale of trial and error, part 1 – CLR assemblies
Moving to a new version of SQL Server is always interesting, and this version is proving to be no exception. It has been a lot of fun so far, and I hardly know where to start, but I will start with CLR assemblies.
SSIS Batch Geocoder now available on Codeplex
My SSIS Batch Geocoder for SSIS 2008 R2 is now available on Codeplex. It’s a free SSIS Data Flow component that converts address data to latitude and longitude. This can be very useful when using the Map features of SSRS 2008 R2.
Why the extra sets of scroll bars when using pre-VS 2010 ReportViewer controls?
When you begin to use the Visual Studio 2005/8 ReportViewer web control (to view SQL Server Reporting Services reports) you are likely to find that it presents an extra set of scroll bars within the web page, making it hard to use. This is normal and there are several ways to make them go away. You can read about the reasons for the control’s behavior here (it is good to know that it will be “fixed in the next version,” really), and you can find lots of advice on the web about what to do about it (until the next version is ready).
Megan’s SQL Server Blog
For years I have been relying upon the Web for quick answers about how to do things in SQL Server and ASP.NET (among other things), and it has saved me a huge amount of time not having to reinvent the wheel. This is my attempt to return the favor: I will be writing articles about unique or otherwise interesting problems (to someone facing them) that I have had to solve.
If you find any of this helpful, please let me know.
Megan
SQL Server 2008: “Reboot Required
Last week I began to prepare to migrate from SQL Server 2005 to 2008 (x64) by clearing off my staging server and installing SQL Server 2008. I didn’t get far. Based on what I saw, and what I have been reading on the MSDN forums, this is what happened:
Who Knew? — The Excel source in SSIS
This last week I wrote two SSIS packages (SQL Server 2005) that read data that was originally published using Excel .xls format and populated a staging table. The data is only published once a year, with perhaps one or two corrections following, but I thought I would save a little bit of trouble and use the Excel data source to read all of the worksheets that I needed from one source. After all, the import wizard uses it when it builds a package for you.
