Sign in or Join FriendFeed
FriendFeed is the easiest way to share online. Learn more »

Jeremy Marx › Comments

Jeremy Marx
Andy Leonard : Blog (Durnit!) - http://sqlblog.com/blogs...
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
Jeremy Marx
Andy Leonard : T-SQL Tuesday - http://sqlblog.com/blogs...
I thought I'd share a couple datetime SSIS Expressions I use regularly to format dates. - Jeremy Marx
Jeremy Marx
Alberto Ferrari : Remote Execution of SSIS Packages - http://sqlblog.com/blogs...
Developed a test program that uses WCF to communicate with the server to execute the package. - Jeremy Marx
Jeremy Marx
Protean » Blog Archive » Excel & SSIS (Part 1) - http://www.proteanit.com/b...
Jet driver only evaluates first 8 rows by default. - Jeremy Marx
Jeremy Marx
SSIS Error using a stored proc as source « Random Technical Thoughts - http://chrisbarba.wordpress.com/2009...
Need to look into this. - Jeremy Marx
Jeremy Marx
Astoria, SSIS Adapters and BDD – Take 1 - Howard Dierking - CodeBetter.Com - Stuff you need to Code Better! - http://codebetter.com/blogs...
To understand this, you need to understand Data Services: http://msdn.microsoft.com/en-us... - Jeremy Marx
Jeremy Marx
Table Variable Name as Column Prefix - http://www.sqlmag.com/Article...
@paschott clued me in on this, as he tweeted from Itzik Ben Gan's session at #sqlpass. Very cool. - Jeremy Marx
Jeremy Marx
Seth's Blog: When data and decisions collide - http://sethgodin.typepad.com/seths_b...
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
Jeremy Marx
Q&A: Moving forward with SQL Server in the cloud - http://searchsqlserver.techtarget.com/news...
Interview with Brent about data in the cloud, what it means and to whom. - Jeremy Marx
Jeremy Marx
T-SQL in SSIS: The power and the weaknesses - http://searchsqlserver.techtarget.com/tip...
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
Jeremy Marx
How to easily identify a scheduled Reporting Services report - http://www.mssqltips.com/tip...
Could be used in a sproc to manually execute a given report schedule. - Jeremy Marx
Jeremy Marx
SSIS Script task design script problem - ASP.NET Forums - http://forums.asp.net/p...
"Design Script" button not working is fixed in SP1 and up. - Jeremy Marx
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
Jeremy Marx
Tasks and Components available from Melissa Data - http://ssisctc.codeplex.com/Wiki...
Full suite of SSIS components for address data profile, cleansing, etc - Jeremy Marx
Jeremy Marx
SSIS Community Tasks and Components - http://ssisctc.codeplex.com/
Compendium of SSIS components, addons, tools, etc. - Jeremy Marx
Jeremy Marx
Calling sp_start_job from a stored procedure - Server Fault - http://serverfault.com/questio...
Last comment is the meat. - Jeremy Marx
Jeremy Marx
How To Achieve User Input At Run-time with SSIS Package - http://www.sqlservercentral.com/Forums...
Forum question. Answer boils down to commandline. Batch file may be useful for this, or perhaps a windows forms app. - Jeremy Marx
Jeremy Marx
How To Build a Cube From an Existing Data Source Using SQL Server Analysis Services - http://www.mssqltips.com/tip...
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
Jeremy Marx
McGimpsey & Associates : Excel : Text Files - http://www.mcgimpsey.com/excel...
Several VBA macros for exporting an Excel worksheet to CSV, including one with double-quote framing character. - Jeremy Marx
Jeremy Marx
Facebook | Videos Posted by Mark Baker: Texting While Driving (Very Graphic) - http://www.facebook.com/video...
Extremely graphic, very difficult to watch. - Jeremy Marx
Jeremy Marx
CSV File Creator for Microsoft Excel - http://www.add-ins.com/csv_fil...
Can enforce double-quote framing character. Not free. - Jeremy Marx
Jeremy Marx
Enterprise Policy Management Framework - http://epmframework.codeplex.com/
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
Jeremy Marx
2 Postal Addressing Standards - http://pe.usps.gov/text...
USPS reference for parsing address lines into component parts. - Jeremy Marx
Jeremy Marx
InformIT: SQL Server 2005 Waiting and Blocking Issues > Resource Type Specifics - http://www.informit.com/article...
Sample chapter by Ken Henderson detailing Waiting and Blocking Issues. - Jeremy Marx
Jeremy Marx
The tech jobs that the cloud will eliminate | Adventures in IT - InfoWorld - http://www.infoworld.com/d...
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
Jeremy Marx
BPM is NOT Software Engineering - http://www.bpm.com/bpm-is-...
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
Jeremy Marx
Reporting Services Scripter - http://www.sqlmag.com/Article...
Migrate SSRS reports by scripting. - Jeremy Marx
Jeremy Marx
Automating tests for T-SQL code - SQLServerCentral - http://www.sqlservercentral.com/article...
This one looks robust, and makes sense. - Jeremy Marx
Jeremy Marx
Magento - Optimizing MySQL for Magento (getting better performance) - General Forum - eCommerce Software for Growth - http://www.magentocommerce.com/boards...
magento - Jeremy Marx
Jeremy Marx
Copy Only Backup for SQL 2005 and SQL 2008 - http://www.mssqltips.com/tip...
How to perform an ad hoc backup without interrupting the recovery sequence of the scheduled backup sets. - Jeremy Marx
Other ways to read this feed:Feed readerFacebook