Technology Musings
Neither SQL Server 2008 nor Office 2007 install Microsoft.ACE.OLEDB.12.0 providers. With a small tweak, we can enable connections to Excel and Access 2007.
In: Microsoft
16 Nov 2009The new Office 2010 Beta just dropped on MSDN and TechNet. The package is available in both 64-bit and 32-bit flavors; download details for both appear below.
In: SSIS
14 Oct 2009If you need to access a custom .NET Assembly from an SSIS Script Task, Microsoft doesn’t make things very easy – but it’s still possible with a little setup.
In: SQL Server
18 Aug 2009How to create a .NET user-defined function that exposes RegEx functionality to Microsoft SQL Server.
In: Windows
6 Aug 2009Full download details – including SHA1 hashes – for x64 and x86 editions of Windows 7 Ultimate, Enterprise, Professional, Home Premium, Home Basic, and Starter