Technology Musings
Using the MySQL ADO.NET provider, SQL Server Integration Services can natively query MySQL databases, providing an easy method to transfer data between systems.
In: SQL Server
25 Feb 2009An illustrated, step-by-step guide for connecting MySQL and SQL Server via Linked Servers utilizing the MySQL ODBC Connector driver.
In: SQL Server
4 Dec 2008I’m sure there are more posts like these to come, but I just wanted to get this out there. It’s been a small annoyance of mine that carried over from my MySQL days, but why aren’t there unsigned numerics in SQL Server?
Why do I have to waste a whole bit on the sign in IDENTITY [...]