Posts Tagged ‘HOWTO’
Import Wikipedia articles into SQL Server with SSIS
In: SQL Server|SSIS
26 Jan 2009Import the XML dump of Wikipedia data into SQL Server through SSIS. Full walkthrough with pictures and pre-configured SSIS package provided.
- (7) Comments
- Tags: HOWTO, SQL Server, SSIS
Windows 7 in VirtualBox: Shared Folders workaround
In: Linux|VirtualBox|Windows
15 Jan 2009You’ve installed VirtualBox Guest Additions in Windows 7, but Shared Folders don’t yet work. There is a simple workaround that can provide basic functionality.
- (20) Comments
- Tags: HOWTO, VirtualBox, Windows 7
Connecting to Oracle from SQL Server
In: SQL Server
5 Jan 2009Unfortunately, setting up a linked server to Oracle is not as easy as it should be. In fact, you’ll have to install some software on your server to make things work. I’ve put together a short guide on connecting to Oracle from SQL Server.
- (30) Comments
- Tags: Database, HOWTO, Oracle, Software, SQL Server
Configuring SQL Server Agent Operators
In: SQL Server
5 Jan 2009SQL Server provides a great notification system for alerts and jobs. There are many options to be set and multiple dialog boxes to step through, but once finished, you’ll always be the first to know when a problem is immanent. Below is a detailed reference to get this running on a new server.
- (8) Comments
- Tags: HOWTO, Software, SQL Server
Installing Windows 7 Beta 1 in VirtualBox 2.1.0
In: VirtualBox|Windows
31 Dec 2008If you’ve snagged yourself a copy of Windows 7 Beta 1 and are anxious to give it a whirl, installing it in a virtualized environment is a great way to go. It’s no secret that VirtualBox is my favorite VM application, so I wanted to mention a bit of advice for getting it working properly.
- (32) Comments
- Tags: HOWTO, VirtualBox, Windows 7
- 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. [...]
