Home Blog Page 371

SQL Server 2005: Enforce Password Policy and Expiration

0

Utilizing password policy and expiration can better secure your server and better protect the valuable data in your database. To enforce password policy and expiration for a login, follow these steps…

SQL Server 2005: How To Perform a Full Backup of a Database

0

A full backup includes database files and locations as well as parts of the transaction log. A full backup is necessary, regardless of the backup strategy that is implemented, because all other backup types (differential and transaction log) depend on the having a full backup. To perform a full backup of your database, follow these steps:

SQL Server 2005: How To Restore a Database from a Backup

0

Your database is down, your users are in a panic, what do you do?. If you have been performing routine backups of your database, you can restore it to the point of the most recent backup. To restore your database, follow these steps:

SQL Server 2005: The Copy Database Wizard

0

The Copy Database Wizard is a very valuable asset when you are wanting to copy or move a database and its objects to another server. To utilize this functionality…

MySQL: Increment an exisitng value

This slick MySQL syntax allows you to increment or decrement an existing number in a table without first having to read the value. This is a nice way to increment an access counter.

Microsoft SQL Server: How to Find the Foreign Keys in a Database

0

A foreign key is a column or columns that are used to enforce a link between data in two tables. While SQL Server gives you no quick and easy way to view all foreign keys in a database, this quick query will give you that information. It comes in handy when trying to troubleshoot Foreign Key Constraint errors.

SQL Server 2005/2008: Disable Management Studio’s Splash Screen

0

If you have grown tired of having to view the splash screen each and every time you open the SQL Server Management Studio, you can use a simple command line switch in your shortcut to bypass the annoyance.

IE9: Open a blank page when a new tab is opened

0

By default, when you open a new tab in IE9, a new about:tabs page which displays your most popular sites will appear. If you do not like to see it everytime, you can configure IE9 to open a blank page for you.

Mail.app: Resend an Email Message

0

Sometimes you need to resend a message either because the recipient never received it or because they accidentally deleted it. To do this just follow these directions. This is the method used in the newer Mail Version 5.x as well.

OS X Lion: How to Make Web Apps with Automator

0

Instead of using third party applications to make web apps for your computer, you can use Lion’s Automator to create them. These can be desktop or iPhone versions of websites so you can use them for testing your site as well. By making them an application, these web apps will appear in Launchpad.

Google: How to Find User Manuals and Operating Instructions for Your Devices

0

Google can be a great resource for finding a PDF copy of the user’s manual, user’s guide, or operating instructions when you’ve lost or misplaced the original. Instead of stressing where you put the instructions for your device, simply fire up your web browser and get a new copy. This can also be useful if you picked up an item through eBay or a garage sale.

Office 365: How to Enable Blind Carbon Copy (Bcc) in Outlook

0

If you are sending an email out to a few people or a mailing list, you probably are wanting to hide the list of addresses from each recipient. You do this by using the blind carbon copy field in the message you are creating. The Outlook web app has this field hidden by default, to unhide the field, follow these steps: