stevienova.com

In SQL Server Integration Services (SSIS), pretty much every task or transformation lets you set “expressions” up. Expressions are basically ways to set property values programmatically. Here are two scenarios where you might use expressions (there are 100’s of uses, these are just two that are kind of related). Multiple Database Select – You have [...]

Finally getting around to doing some work on SQL 2008, and after about 3 minutes, I run into this error: “Saving Changes is not permitted.. blah blah blah” See screenshot below. This is different than SQL 2005. Microsoft maybe trying to save us from ourselves? The thing is, I never “enabled the option Prevent saving [...]

This weekend, I ran across this on CodePlex – OLAP PivotTable Extensions which got me thinking back to a post by the Excel blog about adding calculated measures and named sets in VBA (which is another blog post completely) From CodePlex: OLAP PivotTable Extensions is an Excel 2007 add-in which extends the functionality of PivotTables [...]

One feature of Excel 2007 that I think is really cool, and also a little hidden, is the “Offline OLAP” feature. If you insert a pivot table connected to an OLAP cube into Excel 2007, and go to the PivotTable Options Ribbon Menu, You will see the “OLAP Tools” Button. Click on that and then [...]

Here is a tip about a setting that I think should be on by default, but it isn’t. How many times are you writing T-SQL in SQL Server Management Studio (SSMS) and you need to just copy the results out, paste to Excel and either do more analysis or send off to someone. What happens [...]

So, you install SQL, and if you are in the US, you 99.9999% of the time install it with the default collation, or language, or whatever. US English, Codepage 1252, etc, etc Latin blah blah… Then, you are tasked with pulling data from somewhere else, but it happens to be a different language or collation [...]

Recently, Amazon released their Kindle application for the iPhone. Since I don’t have a Kindle (but I want one!) I figured this would be the next best thing. They have this technology in the app called WhisperSync which sync’s up the page you are reading, so if you do have a Kindle, you can switch [...]