Surf 11 » Archives for August, 2007
SQL Server Transaction Log Space Usage
Need to find out the amount of free space in your transaction log file on Microsoft SQL Server? Run the following command:
DBCC SQLPERF ( LOGSPACE )
It will tell you the percentage of transaction log space used, and the size of the transaction log file, which you then use to calculate the amount of free space in the transaction log or the amount of space in use.
The Result of the DBCC SQLPERF (LOGSPACE) query is the following columns Database Name, Log Size (MB), Log Space Used, Status. If there is a lot of FREE space in the transaction log, and you the file is too big you can shrink the size of the transaction log by running:
DBCC SHRINKFILE ( DBFILENAME_Log )
Cannot shrink log file because all logical log files are in use
If you are getting the following error message in Microsoft SQL Server when you try to run DBCC SHRINKFILE (DBNAME_Log):
Cannot shrink log file 2 (DBNAME_Log) because all logical log files are in use.
Make sure that there are no running transactions, by running the command on the database in question:
DBCC OPENTRAN
It is possible to shrink the transaction log file while the SQL Server database is online, however if transactions are taking place while the operation is running you may experience this error.
Try running it in off hours the DBCC SHRINKFILE command in off hours, or shut down access to the database from other apps.
Animated Gif Progress / Loading / Status Bar Icons
Several Animated GIf's for showing progress or downloads in AJAX or javascript web applications. All of the icons are licensed under Creative Commons.
Assured Information Security
AIS - Security company located in rome ny on griffis air force base.
Prototip - Popup Tooltips for prototype
Prototip allows you to easily create both simple and complex tooltips using the Prototype javascript framework. If you also use Scriptaculous you can even add some nice effects to them.
iChat Lost Connection With AIM
I just setup my new mac pro, but was unable to connect to AOL Instant Messenger via Apple iChat. I kept getting this error message:
ichat lost connection with aim
I had no other internet connectivity problems...
The solution is to go into the iChat Preferences, click on Accounts, and then select your AIM account. Click Server Settings and change the port to 443.
That did the trick for me, AOL AIM is working great now.
jQuery Tutorial for JavaScript programmers
An introduction to jQuery for programmers who understand javascript already.
New Functions and Tags in ColdFusion 8
Here's a list of the New Functions in ColdFusion 8 (89 in Total)
AjaxLink AjaxOnLoad ArrayIsDefined DeserializeJSON DotNetToCFType FileClose FileCopy FileDelete FileIsEOF FileMove FileOpen FileRead FileReadBinary FileReadLine FileSetAccessMode FileSetAttribute FileSetLastModified FileWrite GetComponentMetaData GetFileInfo GetPrinterInfo GetReadableImageFormats GetUserRoles GetWriteableImageFormats ImageAddBorder ImageBlur ImageClearRect ImageCopy ImageCrop ImageDrawArc ImageDrawBeveledRect ImageDrawCubicCurve ImageDrawPoint ImageDrawLine ImageDrawLines ImageDrawOval ImageDrawQuadraticCurve ImageDrawRect ImageDrawRoundRect ImageDrawText ImageFlip ImageGetBlob ImageGetBufferedImage ImageGetEXIFMetadata ImageGetExifTag ImageGetHeight ImageGetIPTCMetadata ImageGetIPTCTag ImageGetWidth ImageGrayscale ImageInfo ImageNegative ImageNew ImageOverlay ImagePaste ImageRead ImageReadBase64 ImageResize ImageRotate ImageRotateDrawingAxis ImageScaleToFit ImageSetAntialiasing ImageSetBackgroundColor ImageSetDrawingColor ImageSetDrawingStroke ImageSetDrawingTransparency ImageSharpen ImageShear ImageShearDrawingAxis ImageTranslate ImageTranslateDrawingAxis ImageWrite ImageWriteBase64 ImageXORDrawingMode IsDDX IsImage IsImageFile IsInstanceOf IsJSON IsPDFFile IsPDFObject IsUserInAnyRole QueryConvertForGrid PrecisionEvaluate ReMatch ReMatchNoCase SerializeJSON Sleep VerifyClient
Here's a list of the New Tags in ColdFusion 8
cfajaximport cfajaxproxy cfdbinfo cfdiv cfexchangecalendar cfexchangeconnection cfexchangecontact cfexchangefilter cfexchangemail cfexchangetask cffeed cfimage cfinterface cflayout cflayoutarea cfmenu cfmenuitem cfpdf cfpdfform cfpdfformparam cfpdfparam cfpdfsubform cfpod cfpresentation cfpresentationslide cfpresenter cfprint cfsprydataset cfthread cftooltip cfwindow cfzip cfzipparam
Photoshop Tutorials for Beginners
Here's a list of easy Adobe Photoshop Tutorials for Beginners:
- Basic Concepts
- Photoshop Text Tool Tutorial
- Photoshop CS2 Essential Training from Lynda.com - You have to pay to see them all, but a good number of them are free. Video Tutorials
- Photoshop 101: Basics Learn about the Tools Palette
- Colorizing a Grayscale Image Tutorial
- Custom Shapes - Video Tutorial
- Photoshop CS2 Essential Skills
- Web 2.0 Jaggedy Background
- Photo Reflection Effect - like in iTunes
- Replacing Color
- Russell Brown's Photoshop CS2 Tips & Techniques
- Photoshop CS2 Channels & Masks
Some tutorials on color theory, you might find this interesting, and you might be able to apply the terms they use to things you see in photoshop, especially in the color picker...
Some websites you can use to find more photoshop tutorials:
XML