We were recently asked to export data from a MS SQL Server to another MS SQL database table. So I thought putting a quick reference for how to do this may help others to export their data. SELECT * INTO [database].[NewTable] FROM [localTable]
Why use a Virtual Machine(VM)? Let's start with the basics. What is a Virtual Machine (VM)? Well put simply a Virtual machine is a Operating System (like windows XP, Windows 7, or a Linux OS) that runs on top of another Operating System, but that you can use and interact with as though it is … Continue reading What is a Virtual Machine and How Do I Chose One?
Since 1999 when bluetooth was first introduced, you have probably used bluetooth for wireless keyboards, mice, headset, GPS and other peripherals cellular phones, PDAs, MP3 players, and some digital cameras. If so, you know how convenient the wireless connectivity can be. You've probably also connected many of those same devices up using a wired connection … Continue reading Bluetooth vs. Wireless USB
There is a lot of talk around about Cloud Computing, but very little talk about what Cloud Computing is. I know I’ve heard people talk about it as all kinds of things, some like a cloud service are right and some like grid computing are wrong. The term “Cloud” has been used to generically define … Continue reading What Cloud Computing is and how it relates to a Cloud Service.
What's the difference between a Hub, a Switch and a Router? Very simply it could be said to be "Intellegence." It has come to my attention that these are very easily confused by many people. When you walk into a BestBuy or other electronic store and look at the network connectivity aisle you'll find many … Continue reading Difference between Hub and Switch and Router
I was looking to do an automatic SQL Server 2005 backup using SQL Server Express. SQL Server Express 2005 does not offer a built in way to backup automatically. So after doing a fair amount of testing and searching I finally figured out how it could be set up. The solution I use first of … Continue reading Automatic SQL server 2005 backup (Express)
It's nothing new that data is crucial to business, and that's why we must keep regular backup files of data. What to backup? There are different philosophies on backup storage and what should be backed up. Well my philosophy on data backup files is simple, backup the data you need, not the installed software or … Continue reading A backup storage strategy to backup files daily