Great backup tool for SQL Server Express
SQL Server Express has no automated backup tool, you must do all backups manually or use scripts to automate nightly backups. (You do backup your production databases every night right?). SQL Backup and FTP SQL Backup and FTP is a program I’ve been using on my Production Server for the past month, allowing me to [...]
SQL Server + TSQL Deep Discussion on February 24th
On Thursday February 24th I’ll be presenting at CAUG, (CAUG.com) the following topic, if you’re in the Chicagoland area please join us or you can tune in via the web: SQL Server Express has been the best thing to ever happen to Access, the two make an unbeatable combination! But to maximize the relationship you [...]
Gain more space in your reports – Use a new date format
Dates on reports can be a pain, you have to leave enough space for the worst case scenario, usually 12/12/xxxx, if you have a lot of date columns all that space can add up. Instead of using Short Date in the format field of the report’s format tab, use mm/dd/yy instead. It will guarantee all months and [...]
