This task is actually for Windows 7. However, while there's no guarantee to work in future Windows, it's still good for Windows 8.Right-click on the Taskbar, select Toolbars, then New toolbar...Type in:Click Select Folder … [Continue reading]
Move the Users Directory to a Different Drive in Windows 8
This is a method that's commonly used in a hybrid SSD-HDD solution, but it can be used in any settings for those who don't want to store their Users directory in their main C: drive. And I like this solution better as it's more straightforward than … [Continue reading]
Microsoft Camera Codec Pack for RAW Thumbnails
Just bought a new Canon 5D Mark III or Nikon D800 camera and surprised that your RAW files don't have any thumbnails? Fortunately, Microsoft has released its latest Camera Codec Pack for free. While there are a few good commercial products out there, … [Continue reading]
Setting Up Oracle Data Provider for Visual Studio
In one of my SSIS 2008 applications, I had to extract data from Oracle which would be processed and dumped to SQL Server. In order to do so, SSIS will need have access to an Oracle Provider for OLE DB. I also needed to do a few simple checks here and … [Continue reading]
Default Ports Used by SQL Server
The most often asked question when configuring a firewall for SQL Server access is what ports are used by SQL Server? If your SQL Server uses default port numbers, it's important to have TCP port 1343 & UDP port 1344 at the minimum opened. The … [Continue reading]