Tuesday, April 3, 2007
The .Net & SQL Server Mashup: SQL Server 2005 Books Online Live Search
The link below give us access to the entire SQL Server 2005 BOL. http://search.live.com/macros/sql_server_user_education/booksonlineIts also a very good example of 'Windows Live Search Macros' - custom tailored search engines which give results relevant to what you are interested in.
MS SQL Online - Tips, Tricks and Tutorials!: SQL Server 2005 Performance Dashboard Reports
The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later.Common performance problems that the dashboard reports may help to resolve include:- CPU bottlenecks (and what queries are consuming the most CPU)- IO bottlenecks (and what queries are performing the most IO).- Index recommendations generated by the query optimizer (missing indexes)- Blocking- Latch contentionThe SQL Server 2005 Performance Dashboard Reports only use Dynamic Management Views and Catalog Views. They do not poll performance counters from the OS, nor do they store a history of your server's performance over time. These are very light-weight reports that will help diagnose performance problems as they are occurring.
Commercial and freeware Sqlite tools list
Long list of sqlite database management applications. Listed software types: sqlite desktop, sqlite GUI, sqlite explorer, sqlite admin, sqlite browser, sqlite manager, sqlite frontend, sqlite navigator, sqlite web admin.
Manage database from Firefox - SQLite Manager Extension
March 17, 2007 at 10:46 pm
Firefox 2 got a Storage - database API baked by sqlite. It makes possible to operate any sqlite database from firefox programmatically. And finally someone created most exotic desktop SQLite Manager - XUL application, running in Firefox or XULRunner, needless to say it is crossplatform. Not that much features in current state (0.1.x), but does it really matter).
Monday, April 2, 2007
Sunday, April 1, 2007
WinHttpRequest.SetProxy
WinHttpRequest.SetProxy (msdn)
HTTPREQUEST_PROXYSETTING_DEFAULT
Default proxy setting. Equivalent to HTTPREQUEST_PROXYSETTING_PRECONFIG.
HTTPREQUEST_PROXYSETTING_PRECONFIG
Indicates that the proxy settings should be obtained from the registry. This assumes that Proxycfg.exe has been run. If Proxycfg.exe has not been run and HTTPREQUEST_PROXYSETTING_PRECONFIG is specified, then the behavior is equivalent to HTTPREQUEST_PROXYSETTING_DIRECT.
HTTPREQUEST_PROXYSETTING_DIRECT
Indicates that all HTTP and HTTPS servers should be accessed directly. Use this command if there is no proxy server.
HTTPREQUEST_PROXYSETTING_PROXY
When HTTPREQUEST_PROXYSETTING_PROXY is specified, varProxyServer should be set to a proxy server string and varBypassList should be set to a domain bypass list string. This proxy configuration applies only to the current instance of the WinHttpRequest object.
varProxyServer
[in, optional] A value of type VARIANT that is set to a proxy server string when ProxySetting equals HTTPREQUEST_PROXYSETTING_PROXY.
varBypassList
[in, optional] A value of type VARIANT that is set to a domain bypass list string when ProxySetting equals HTTPREQUEST_PROXYSETTING_PROXY.
Option Explicit
'WinHttpRequest proxy settings.
Const HTTPREQUEST_PROXYSETTING_DEFAULT = 0
Const HTTPREQUEST_PROXYSETTING_PRECONFIG = 0
Const HTTPREQUEST_PROXYSETTING_DIRECT = 1
Const HTTPREQUEST_PROXYSETTING_PROXY = 2
Private Sub Command1_Click()
Dim HttpReq As Object
' Create the WinHTTPRequest ActiveX Object.
Set HttpReq = New WinHttpRequest
' Switch the mouse pointer to an hourglass while busy.
MousePointer = vbHourglass
'Set proxy settings.
HttpReq.SetProxy HTTPREQUEST_PROXYSETTING_PROXY, _
"proxy_server:80", "*.microsoft.com"
' Open an HTTP connection.
HttpReq.Open "GET", "http://microsoft.com", False
' Send the HTTP Request.
HttpReq.Send
' Get all response text.
Text1.Text = HttpReq.ResponseText
' Switch the mouse pointer back to default.
MousePointer = vbDefault
End Sub
Charlie's Tidy Add-ons
Charlie's Tidy Add-Ons
By Charles ReitzelPlease send bug reports or comments to mailto:creitzel@rcn.com?Subject=Tidy%20Add-ons
This is a brief page showing a couple additions to Tidy I have written.
Latest: 20 February, 2003, Exposed TidyOutputBOM option to TidyATL (and thru to Tidy.NET) and speeded up syntax highlighting. Removed DLL build, which is now included in TidyLib proper.
3 February, 2003, Added required DLL to tidyui.zip
1 February, 2003, Removed stuff that you can now get from the Tidy Project Page. Added .NET wrapper and syntax highlighting and other goodies to Tidy UI.
Enjoy!
Table Of Contents
The following are current as of 20 February, 2003:
Tidy UI More Info
C++ Wrapper More Info
Perl Wrapper More Info
COM/ATL Wrapper More Info
.NET Wrapper More Info
Tidy UI
This is a windows executable that puts up a GUI for the HTML Tidy library.
COM/ATL
The latest is a simple COM/ATL wrapper for the library. The simple operations are supported: parse file, parse from memory, cleanup, diagnostics, save file and save to memory. You can also set options in the usual ways. I got just a bit fancy and supported the I/O and error handling callbacks. Also, TidyLib fixes for Unicode/UTF-16 are included.
20 February, 2003: Fixed TidyOptionId enum so that all the conditionally compiled options are included, especially TidyOutputBOM. Note, for XHTML/XML output, the BOM is required. However, if you set TidyOutputBOM false after the parse, then it will be respected.
1 February, 2003: Some IDL updates, but no interface/UUID changes. IDL changes are purely for the benefit of generating the .NET wrapper.
Previous fix for character conversion in ATL wrapper now works fine with UTF16 due to fixes in core library. Thanks to Moshe Plotkin for identifying problem and testing updates. Parse/Save String worked OK only if current code page and desired encoding match. Now, the "String" methods temporarily force the encoding to UTF16LE to work with COM/OLE Unicode strings. Didn't break the test on my Latin1 system. Feedback still appreciated on non-Western European systems/content.
There is an example of redirecting Tidy output to a static control in the VB test driver. Note, this is still a rough draft. If there is demand, it may flesh out a bit.
.NET
You can download a pre-generated .NET wrapper here.
20 February, 2003: Regenerated to use latest TidyATL.
I have also been examining how to call Tidy from .NET. So far, there are 3 different options. Which is best depends, as always, on your requirements.
Quick and Dirty
With a few simple declarations, you can call directly into a DLL build of TidyLib. See a simple example VB.NET program sent to me by Phil Weber.
FTP Status and Error Codes
During your FTP sessions, you'll receive various numbered codes from servers. CuteFTP displays these codes in the log window. Some codes represent errors. Most others simply communicate the status of the connection. Here are brief explanations for the most common status and error codes.
100 Series
200 Series
300 Series
400 Series
500 Series
10000 Series "
Oracle Berkeley DB Downloads
http://www.oracle.com/technology/software/products/berkeley-db/index.html
Latest Production Releases
Berkeley DB 4.5.20 Previous Releases
Requires log file format upgrade. change log - patches (2)
Berkeley DB 4.5.20 .tar.gz, with AES encryption (8.9M)
Berkeley DB 4.5.20 .zip, with AES encryption (11.6M)
Berkeley DB 4.5.20 .msi Windows installer, with AES encryption (13.4M)
Berkeley DB 4.5.20 .tar.gz for VxWorks, with AES encryption (47.8M)
Berkeley DB 4.5.20 NC.tar.gz , without encryption (8.8M)
Berkeley DB 4.5.20 .NC.zip, without encryption (11.6M)
Berkeley DB 4.5.20 VxWorks CD.NC.tar.gz, without encryption (47.5M)
Berkeley DB Java Edition 3.2.21 Previous Releases
change log - release notes
Berkeley DB Java Edition 3.2.21 .tar.gz (4.6M)
Berkeley DB Java Edition 3.2.21 .zip (5.9M)
Berkeley DB XML 2.3.10 Previous Releases
change log - release notes - patches (5)
Berkeley DB XML 2.3.10 .tar.gz (30.9M)
Berkeley DB XML 2.3.10 .zip (42.7M)
Berkeley DB XML 2.3.10 .msi Windows installer (52.7M) "
High Performance, Embeddable Database Engines
http://www.oracle.com/database/berkeley-db/index.html
Oracle Berkeley DB is a family of open source embeddable databases that allows developers to incorporate within their applications a fast, scalable, transactional database engine with industrial grade reliability and availability. As a result, customers and end-users will experience an application that simply works, reliably manages data, can scale under extreme load, but requires no ongoing database administration. As a developer, you can focus on your application and be confident that Oracle Berkeley DB will manage your persistence needs.
White paper: A Comparison of Oracle Berkeley DB and Relational Database Management Systems (PDF)
Technical resource: Visit the Berkeley DB Product Family page on the Oracle Technology Network
THE ORACLE BERKELEY DB FAMILY
Berkeley DB—The world's most popular embeddable database engine
Berkeley DB Java Edition—A pure Java version of Berkeley DB optimized for the Java environment
Berkeley DB XML—An embeddable XML database with XQuery-based access to documents stored in containers and indexed based on their content"
ClearSilver
Submitting To Search Crawlers: Google, Yahoo, Ask & Microsoft's Live Search
http://searchenginewatch.com/showPage.html?page=2167871
March 12, 2007
Part 4 of Essentials Of Search Engine Submission
Crawler-based search engines automatically visit Web pages to compile their listings. This means that, unlike directories, you are likely to have several, if not many, pages listed with them. This also means that by taking care in how you build your pages, you might rank well in crawler-produced results.
Optimizing pages for crawlers is covered in more detail in the Optimizing For Crawlers section of Search Engine Watch. If you have time, it is recommended that you read the pages in this section, especially the Search Engine Placement Tips page. However, by simply following the submission tips below, you can at least get your pages listed with crawlers, where they might naturally rank well for certain terms.
Submitting To Google
One of the most important crawler-based search engines is Google, because many people search there, plus it "powers" the main results of several other services (see the Search Engine Results Chart for an explanation of what "main" results are).
The absolute best way to get listed with Google is to get links to your Web site from other sites. Indeed, this is the best way to get listed for free with all the major crawlers listed on this page. Crawlers follow links, so if you have good links pointing at your Web site, the crawlers are more likely to find and include your pages in their databases.
Here's the good news: if you submitted your site to the major directories and got listed with one of them, then Google and other crawlers will almost certainly pick up the URL that was listed. This means you may not need to do additional work to get listed with crawlers.
Nevertheless, you may find it helpful to do some link building beyond the directories. Basic tips on building good links are covered on the Search Engine Placement Tips page. The Link Analysis & Link Building page available to Search Engine Watch members provides in-depth advice on building relevant links to your Web site. Consider reading what's covered on one or both of these pages.
The Submitting & Encouraging Crawlers page available to Search Engine Watch members also has advice on how your site architecture can be improved to naturally allow more of your pages to be added by crawlers.
Aside from link building, Google provides an Add URL page that lets you submit a URL directly to its crawler. However, there's no guarantee that Google will actually include a URL submitted to it this way. Despite this, it makes sense to submit your home page and perhaps one or two other URLs from "inside" your Web site via the Add URL page.
In addition to the ADD URL page, Google offers other options to submit a large list of URLs (a sitemap file) and verify ownership of your site within Google Webmaster Central for faster indexing, free of charge.
Once you have completed one of the options above, you really don't need to submit more than this. The only reason for submitting some of your inside pages is to give Google an alternate route into your site in case there is a problem reaching your home page. From whatever page it visits, Google will look for links to other pages within your site, perhaps including those in its index. This is true for other crawlers, as well.
If you have a brand new Web site, it will probably take about a month before Google lists your web pages naturally. Because of this, you might consider making use of its paid placement program Google AdWords, which is covered in the next part of this guide.
Finally, Search Engine Watch members have access to a detailed Guide to Google page that guides you even more through the process of submitting to the crawler and ranking well within its results. To learn more about becoming a member to access this information, visit the membership information page.
Submitting To Yahoo
Yahoo is an important crawler-based search engine because many people use the Yahoo search function, which provides the main results of several other services (see the Search Engine Results Chart for more about this).
As with Google, building links is the best way to get listed for free in Yahoo. Yahoo also offers a free URL submission form that you'll find listed on this page. Submit according to the same instructions as given for Google, above.
What if you aren't picked up for free? Yahoo has paid inclusion programs that guarantee to add the pages you submit quickly. The downside to these programs is that you'll be charged every time someone clicks on your listing. If you run out of money, potentially, your listing may be dropped. However, there's still a chance that even if you run out of money, you might continue to be listed for free.
Confused? You're to be forgiven, if so. The programs are so complex that we do not recommend beginners bother with them. Instead, there's a good chance that many pages in your site will just naturally get listed for free.
By the way, Yahoo's crawler incorporates technology from three different crawlers that it purchased in 2002 and 2003: Inktomi, AltaVista and FAST's AllTheWeb. However, any references you hear about those crawlers are superceded by the single Yahoo crawler.
Submitting To AskAsk.com search results have been powered by the Teoma ExpertRank algorithm since 2001 (see the Search Engine Results Chart).
Ask has no free Add URL page and no longer offers a paid site submission service. However, the Ask Jeeves/Teoma agent automatically crawls the Web, so if you have links pointing at your site from other sites, it will get included naturally.
Basic tips on building good links are covered on the Search Engine Placement Tips page, while the Link Analysis & Link Building page available to Search Engine Watch members provides in-depth advice on building relevant links to your Web site. Consider reading what's covered on one or both of these pages, to help yourself with Ask.
Submitting To Microsoft Live Search
Microsoft Live Search (formerly MSN Search) is an important crawler-based search engine used by many people. Formerly powered by Yahoo's crawler-based results, Live Search currently uses its own search technology, MSNBot, to automatically crawl the web looking for links within Web sites for indexing and ranking.
A review of Microsoft's search technology can be found in this article from Search Engine Watch: MSN Search Gets New Look; Microsoft Gets New Search Engine.