Jeremy Marx - Comments

Pro Full-Text Search in SQL Server 2008 - Google Books - http://books.google.com/books...

November 11, 2010 from delicious - Comment - Like - Share

Pro Full-Text Search in SQL Server 2008 - Get this book - Jeremy Marx

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008 - http://support.microsoft.com/kb...

October 26, 2010 from delicious - Comment - Like - Share

EXEC sp_help_revlogin - Jeremy Marx

Jeremy Marx

How to choose a good index fill factor - http://www.sqlmag.com/blogs...

October 7, 2010 from delicious - Comment - Like - Share

By Paul Randal - Jeremy Marx

Jeremy Marx

Todd McDermid's Blog: Convert Several Columns in SSIS With Fewer Clicks and Confusion - http://toddmcdermid.blogspot.com/2010...

August 30, 2010 from delicious - Comment - Like - Share

Component to replace convert and/or mass-convert columns in SSIS. Asynchronous. - Jeremy Marx

Jeremy Marx

SAP DBACockpit and some related SQL Scripts (Part 2) - Running SAP Applications on SQL Server - Site Home - MSDN Blogs - http://blogs.msdn.com/b...

August 23, 2010 from delicious - Comment - Like - Share

Good info, not just for SAP. - Jeremy Marx

Jeremy Marx

15.1 Asymmetric Encryption Explained :: Chapter 15. Asymmetric Encryption :: Part III: .NET Cryptography :: .NET Programming security :: Programming :: eTutorials.org - http://etutorials.org/Program...

July 16, 2010 from delicious - Comment - Like - Share

Good basic illustration of asymmetric encryption. - Jeremy Marx

Jeremy Marx

15.1 Asymmetric Encryption Explained :: Chapter 15. Asymmetric Encryption :: Part III: .NET Cryptography :: .NET Programming security :: Programming :: eTutorials.org - http://etutorials.org/Program...

July 16, 2010 from delicious - Comment - Like - Share

Good basic illustration of asymmetric encryption. - Jeremy Marx

Jeremy Marx

SQLIS | OLE-DB Command Transformation - http://www.sqlis.com/sqlis...

June 29, 2010 from delicious - Comment - Like - Share

Basic HowTo for OLE-DB Command Transformation with parameters. No mention of output. - Jeremy Marx

Jeremy Marx

SSIS return value of Stored Procedure within an OLE DB Command - Stack Overflow - http://stackoverflow.com/questio...

June 29, 2010 from delicious - Comment - Like - Share

Provides simple solution to getting the RETURN_VALUE from a sproc when executing from OLE DB Command in SSIS. - Jeremy Marx

Jeremy Marx

how to call a stored procedure in SSIS - http://social.msdn.microsoft.com/Forums...

June 29, 2010 from delicious - Comment - Like - Share

Discussion on how to prep a sproc for use in SSIS' OLE DB Command. - Jeremy Marx

Jeremy Marx

SSIS return value of Stored Procedure within an OLE DB Command - Stack Overflow - http://stackoverflow.com/questio...

June 29, 2010 from delicious - Comment - Like - Share

Provides simple solution to getting the RETURN_VALUE from a sproc when executing from OLE DB Command in SSIS. - Jeremy Marx

Jeremy Marx

SQLIS | OLE-DB Command Transformation - http://www.sqlis.com/sqlis...

June 29, 2010 from delicious - Comment - Like - Share

Basic HowTo for OLE-DB Command Transformation with parameters. No mention of output. - Jeremy Marx

Jeremy Marx

how to call a stored procedure in SSIS - http://social.msdn.microsoft.com/Forums...

June 29, 2010 from delicious - Comment - Like - Share

Discussion on how to prep a sproc for use in SSIS' OLE DB Command. - Jeremy Marx

Jeremy Marx

Todd McDermid's Blog: Beware of OLE DB Commands, Data Types, and Calculations - http://toddmcdermid.blogspot.com/2010...

June 28, 2010 from delicious - Comment - Like - Share

Todd warns that OLEDB Command may reduce the precision of a datatype without warning. Check your results! - Jeremy Marx

Jeremy Marx

Removing Duplicates from a Table in SQL Server - http://www.simple-talk.com/sql...

June 26, 2010 from delicious - Comment - Like - Share

Uses combination of CTE and ROW_NUMBER to remove duplicates. One-statement solution. - Jeremy Marx

Jeremy Marx

SQL Server Profiler Templates - http://msdn.microsoft.com/en-us...

June 16, 2010 from delicious - Comment - Like - Share

Descriptions of each profiler template and common uses. - Jeremy Marx

Jeremy Marx

Excel Find the longest entry in a range of text entries - http://www.mrexcel.com/td0021...

June 3, 2010 from delicious - Comment - Like - Share

Excel formula that returns max length of a column. Very useful when setting up SSIS flat-file field properties. - Jeremy Marx

Jeremy Marx

Putting basic array formulas to work - Excel - Microsoft Office Online - http://office.microsoft.com/en-us...

June 3, 2010 from delicious - Comment - Like - Share

Near bottom is a formula that returns the longest string in a column. Very useful for finding problem data in a csv. - Jeremy Marx

Jeremy Marx

Installing MyODBC 3.51 on Windows 7 x64 - http://www.getdowntonight.co.uk/2009...

April 23, 2010 from delicious - Comment - Like - Share

Explains why you're not seeing that 32-bit driver in ODBC. - Jeremy Marx

Jeremy Marx

jrummell.ToString() | SQL Server Management Studio and TortoiseSVN - http://john.rummell.info/john...

April 14, 2010 from delicious - Comment - Like - Share

Gives some external tool configurations to get SSMS working with TortoiseSVN. - Jeremy Marx

Jeremy Marx

Package Ownership Issues - http://www.sqldts.com/212.aspx

April 6, 2010 from delicious - Comment - Like - Share

Changing ownership of DTS package. Helpful when a developer needs access to change a DTS package. - Jeremy Marx

Jeremy Marx

Mission Critical: Database Design - http://www.simple-talk.com/sql...

March 22, 2010 from delicious - Comment - Like - Share

Excellent database design task list with supporting links. Covers business and technical sides. - Jeremy Marx

Jeremy Marx

Kirk Haselden : SQL Task parameters (web.archive.org) - http://web.archive.org/web...

March 19, 2010 from delicious - Comment - Like - Share

Technet article now has the same content. - Jeremy Marx

Jeremy Marx

Database Hardener: Two Lines of Powershell = Random Passwords - http://ronalddameron.blogspot.com/2009...

March 18, 2010 from delicious - Comment - Like - Share

Tested, works quite well. - Jeremy Marx

Jeremy Marx

SSIS Junkie : SSIS: Package Naming Conventions - http://consultingblogs.emc.com/jamieth...

February 18, 2010 from delicious - Comment - Like - Share

Chosen naming convention. - Jeremy Marx

Jeremy Marx

Odd behaviour of derived table & CTE in SQL Server Programming - http://www.eggheadcafe.com/softwar...

February 10, 2010 from delicious - Comment - Like - Share

Predicate Push - Jeremy Marx

Jeremy Marx

Ion netbooks head-to-head: Atom, overcharged? -- Engadget - http://www.engadget.com/2009...

February 8, 2010 from delicious - Comment - Like - Share

i - Jeremy Marx

Jeremy Marx

Selecting points from a database by latitude/longitude within a bounding circle - http://www.movable-type.co.uk/scripts...

February 2, 2010 from delicious - Comment - Like - Share

This is the one Vidar has been wanting. - Jeremy Marx

Jeremy Marx

Description of _ISNULL Property of Rows in SSIS Script Task/Component - http://social.msdn.microsoft.com/forums...

January 15, 2010 from delicious - Comment - Like - Share

See Todd McDermid's answer. - Jeremy Marx

Jeremy Marx

Best practices for working with read only databases in SQL Server - http://www.mssqltips.com/tip...

January 14, 2010 from delicious - Comment - Like - Share

Steps for preparing a database for read-only. Performance and security considerations. - Jeremy Marx

Jeremy Marx › Comments