Archive for the ‘Microsoft’ Category

SSIS breaks when processing embedded text qualifiers in flat file sources. Tutorial on how to configure a script component to manually split on delimiters.

Unlike my last post on the issue, instead of simply pointing to another blog for instructions on how to query Active Directory from SQL Server, I’ll provide some useful tips on getting things all working.

Explanation on how to use PowerShell to automate generating a build file. Code and walkthrough included.

Tutorial on how to test and verify account permissions with impersonation in SQL Server.

T-SQL functions for converting between Gregorian and Julian dates.


  • Graham Charles: I've been considering using this approach to forward individual users' e-mail, but I'm curious if th [...]
  • Paden: Ok another 15min all sorted. something between changing default account on iphone to the exchange go [...]
  • Paden: Thank you I'm sooo close! Same thing as Brandon & Krlrvr. How does one make Google calendar disp [...]
  • Yushe » Blog Archive » Conectar SQL Server con MySql: [...] Disclaimer: El árticulo arriba no es mio, es solo una traducción parcial del árticulo aqui [...]
  • Nick: Here is an extensive how to on sharing folders with Windows 7. http://www.ilertech.com/2010/09/shar [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.