HOWTO: Setup SQL Server Linked Server to MySQL
In: SQL Server
Written by: Taylor Gerring
Despite being completely proprietary, one of the nice connectivity features offered in SQL Server is the ability to query other servers through a Linked Server. Essentially, a linked server is a method of directly querying another RDBMS; this often happens through the use of an ODBC driver installed on the server. Fortunately, many popular databases provide this ODBC driver, giving SQL Server the ability to connect to a wide range of other systems. I’ve already written about how to connect Oracle and SQL Server. In this post, I’m going to go through the steps necessary to connect SQL Server and MySQL.
Read the rest of this entry »
Efficiently query the DATE in DATETIME
In: SQL Server
Written by: Taylor Gerring
The DATETIME data type is often misunderstood and used inefficiently. This article focuses on the date component of DATETIME, how it is handled internally and how it can be used effectively for querying. The DATETIME type is internally stored as two separate 4-byte integers: one of those integers stores the date portion, and the other the time. When the date portion has a value of 0, the date is 1900-01-01. Because the date is internally stored as an INT, casting and converting directly between the types is natural:
Read the rest of this entry »
- (3) Comments
- Tags: SQL Server, T-SQL
Top 10 Cross-Platform Open Source Apps
10 Feb 2009Open source applications have a natural inclination to be compiled for multiple operating systems. Although many OS‘s and tools are converging in functionality, it’s nice to have a homogeneous environment of favorite programs to make the transition from machine to machine more seamless. I use Windows and work and Linux at home, but that doesn’t mean I have to give up anything in the process. Below are – in no particular order – some of my favorite cross-platform open source applications.
Read the rest of this entry »
All About Linux Swap Part 3: Analysis
In: Linux
Written by: Taylor Gerring
After familiarizing yourself with swap, you might have a few questions. How much swap space? What do I set swappiness to? Do I even need swap anymore?
Note: This article is the third in a multipart series introducing the Linux swap. Part 1 is intended to familiarize the reader with the concept of swapping, why it exists, and what it’s used for. Part 2 highlighted basic analysis and management techniques for handling swap space. Part 3 appears below and discusses the current state of swap usage and present opinions about its implementation today.
Read the rest of this entry »
- (3) Comments
- Tags: Analysis, Linux, swap
Handling Embedded Text Qualifiers in SSIS 2005
In: SQL Server|SSIS
Written by: Taylor Gerring
Just a quick note advising that I’ve updated my Handling Embedded Text Qualifiers post to also include a Visual Basic example, making the information also relevant to SQL Server 2005.
- No Comments
- Tags: HOWTO, SQL Server, SSIS, VB.NET
- 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. [...]
