Sign in
or
Join FriendFeed
FriendFeed
is the easiest way to share online.
Learn more »
Join FriendFeed
Jeremy Marx
› Comments
Subscribe
to Jeremy's comments
Jeremy Marx
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
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
Older items »
Other ways to read this feed: