Archive for the ‘Microsoft’ Category
Handling Embedded Text Qualifiers
In: SQL Server|SSIS
12 Nov 2008SSIS breaks when processing embedded text qualifiers in flat file sources. Tutorial on how to configure a script component to manually split on delimiters.
- (16) Comments
- Tags: C#, HOWTO, SQL Server, SSIS
Query Active Directory from SQL Server (again)
In: SQL Server
4 Nov 2008Unlike 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.
- No Comments
- Tags: Active Directory, AD, CLR, HOWTO, SQL Server, UDF
Using Powershell to generate build scripts
In: Windows
31 Oct 2008Explanation on how to use PowerShell to automate generating a build file. Code and walkthrough included.
- No Comments
- Tags: HOWTO, PowerShell, Software, SQL Server
Testing Object Permissions with Impersonation
In: SQL Server
28 Oct 2008Tutorial on how to test and verify account permissions with impersonation in SQL Server.
- No Comments
- Tags: HOWTO, impersonation, security
Converting between Gregorian and Julian Dates
In: SQL Server
23 Oct 2008T-SQL functions for converting between Gregorian and Julian dates.
- No Comments
- Tags: calendar, date conversion, dateadd, DATEDIFF, DATETIME, gregorian, HOWTO, julian, UDF
- HOWTO: Sync Google Calendar on iPhone OS 3.0
- HOWTO: Setup SQL Server Linked Server to MySQL
- Connecting to Oracle from SQL Server
- Windows 7 in VirtualBox: Shared Folders workaround
- Fixing "passwd: Authentication token manipulation error" when changing passwords
- Installing Windows 7 Beta 1 in VirtualBox 2.1.0
- HOWTO: Synchronize Dropbox and ZumoDrive on Windows
- Updating SSH known hosts fingerprints (WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)
- HOWTO: Connect to MySQL in SSIS
- Efficiently query the DATE in DATETIME
- Stop SOPA
- Access system date in SSIS without a Script Task
- Connecting to Oracle with SSIS 2008
- Set Permissions Across SQL Server Database Instances
- SQL Server Principals & Roles Permission Audit
- New Office Outlook 2010 Data File Menu Item
- Why RAM Matters Less with OS X Lion
- Cache multiple values in a Map Container for fast in-memory lookup
- Ubuntu VirtualBox Server Redux Addendum
- Default column value to identity of different column
- KALImaR:Im having the same 11.10 problem with this irritating disaster...Solutions please [...]
- Balkan:Hi All, I have similar problem as Dwarakesh, I set the automatic login on, and after that my passwo [...]
- Creating an automated database backup by means of SQL Server Agent Job « Placko's SQL KB:[...] Configuring SQL Server Agent Operators by Taylor Gerring [...] [...]
- Dwarakesh:yeah even I'm getting the same error on my sony e series laptop!!!! I am currently running ubuntu 1 [...]
- Phil:Thanks - this article was a great help. [...]
