SQL Server used to rely on SQL Mail to for email capabilities. This was a pain as it required you to install a MAPI mail client onto your server. SQL Server 2005 has done away with this and now uses Database mail which relies on using your SMTP server instead of a mail client to send out email. You can set up Database Mail by following these instructions…
The CONCAT function in MySQL allows SELECT statements to act like printf commands by mingling text and query results together.
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…
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:
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:
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…
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.
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.
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.
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.
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.
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.
1...367368369...525Page 368 of 525 error: Content is protected !!
