Jeremy Marx › Comments

The past few days I've read several blurbs from folks expressing why they don't blog. The reasons range from "I have nothing interesting to say" to "I don't know enough" to "Everything I want to write about has been blogged already." - Jeremy Marx

I thought I'd share a couple datetime SSIS Expressions I use regularly to format dates. - Jeremy Marx

Developed a test program that uses WCF to communicate with the server to execute the package. - Jeremy Marx

Jet driver only evaluates first 8 rows by default. - Jeremy Marx

Need to look into this. - Jeremy Marx

To understand this, you need to understand Data Services: http://msdn.microsoft.com/en-us... - Jeremy Marx

@paschott clued me in on this, as he tweeted from Itzik Ben Gan's session at #sqlpass. Very cool. - Jeremy Marx

I run into this all the time. The data shows one thing, but those who make the decisions decide based on their experience. That's fine, and good, but sometimes things change. Cultures change. Generations think differently... - Jeremy Marx

Interview with Brent about data in the cloud, what it means and to whom. - Jeremy Marx

Talks about some of the gotchas using either TSQL or SSIS Data Flow to grab data, provides the questions you should ask when deciding. - Jeremy Marx

Could be used in a sproc to manually execute a given report schedule. - Jeremy Marx

"Design Script" button not working is fixed in SP1 and up. - Jeremy Marx

It allows you to direct records from the data flow to a working table in a SQL Server database, and then execute a SQL statement once all the rows have been loaded to the working table. This can be used as an UPDATE destination, for example, that avoids the row-by-row behavior of the OLE DB Command. - Jeremy Marx

Full suite of SSIS components for address data profile, cleansing, etc - Jeremy Marx

Compendium of SSIS components, addons, tools, etc. - Jeremy Marx

Last comment is the meat. - Jeremy Marx

Forum question. Answer boils down to commandline. Batch file may be useful for this, or perhaps a windows forms app. - Jeremy Marx

We are just getting started with SQL Server Analysis Services and trying to build our first cube. We have an existing relational data source to use as our starting point. There are a number of steps involved in building an SSAS cube. Can you guide us through the steps to build a cube and provide some explanations? - Jeremy Marx

Several VBA macros for exporting an Excel worksheet to CSV, including one with double-quote framing character. - Jeremy Marx

Extremely graphic, very difficult to watch. - Jeremy Marx

Can enforce double-quote framing character. Not free. - Jeremy Marx

The Enterprise Policy Managment Framework uses PowerShell to evaluate policies against your SQL Server Environment, shreds the XML for you, and then renders and delivers your policy history reports via Reporting Services. - Jeremy Marx

USPS reference for parsing address lines into component parts. - Jeremy Marx

Sample chapter by Ken Henderson detailing Waiting and Blocking Issues. - Jeremy Marx

Excellent article on how to prepare (longterm, 5-10+ years) for the affect cloud computing will have on the IT space and your skillset. - Jeremy Marx

Great article, not just for those interested in BPM, but for any software engineer who wants to understand the people that will be using their software. - Jeremy Marx

Migrate SSRS reports by scripting. - Jeremy Marx

This one looks robust, and makes sense. - Jeremy Marx

magento - Jeremy Marx

How to perform an ad hoc backup without interrupting the recovery sequence of the scheduled backup sets. - Jeremy Marx