XPSMTP provides a SMTP based SQL Mail solution for sending MIME based email over SMTP, implemented as an Extended Stored Procedure.

It does not require any software to be installed, just a SMTP email server that can handle the outgoing mail request. XPSMTP is using TCP/IP sockets to communicate to port 25. XPSMTP does not spawn additional threads, the xp_smtp_sendmail request is handled on the same thread as it is being called on by SQL Server. Each call to xp_smtp_sendmail establishes a connection to the SMTP server and disconnects when done sending the email. The connection is created using asynchronous communication and aborts based on a timeout value (@timeout which by default is 10000 milliseconds, so 10 seconds).

Visit http://sqldev.net/xp/xpsmtp.htm#Installation for more details

 Check these two great websites/tools for URL decoding and encoding.

http://meyerweb.com/eric/tools/dencoder/

http://www.blooberry.com/indexdot/html/topics/urlencoding.htm

Expert SQL Server 2005 Integration Services

http://www.amazon.co.uk/Expert-Server-Integration-Services-Programmer/dp/0470134119/ref=sr_1_2?ie=UTF8&qid=1231840718&sr=8-2

Find out how to download and import data and files from a website (http) using SQL Server SSIS Package

More details on:

http://blogs.conchango.com/jamiethomson/archive/2006/05/31/4009.aspx

and

http://www.sqlservercentral.com/Forums/Topic500009-148-1.aspx

and

http://sqljunkies.com/WebLog/ashvinis/archive/2005/05/25/15653.aspx

Analyze Performance Code...

Use script below to analyse performance counters.

If your msdb database grows huge - it is because of sysxmitqueue table.

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/109/postid/183314/scope/posts/Default.aspx

New Order - computer security and networking portal SQL related tools

• Utilities
• audit.sql - Quick little script to check all of your user accounts for weak passwords if you have created a dictionary file somewhere on your server.
• Connecting to MySQL databases with C
• Crack SA Password(BruteForce)with Public Role - Crack SA Password (Brute Force) with Public Role FindSApublic is a brute-force password cracker that requires only public role. Possibilities returns how many different passwords are possible with 1 up to c characters from a universe of n different characters. Usage: FindSApublic n N is an integer which is the maximum length of the password to attempt cracking.

How to list all months and years (last three years inlcuding current year pus next three in this case) years?

Microsoft SQL Server Default instance listens on TCP port 1433. Named instances of the SQL Server Database Engine and SQL Server Mobile are configured for dynamic ports, which means they select an available port when the SQL Server service is started. When connecting to a named instance through a firewall, configure the Database Engine to listen on a specific port, so that the appropriate port can be opened in the firewall.

The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:

• Browsing a list of available servers
• Connecting to the correct server instance
• Connecting to dedicated administrator connection (DAC) endpoints

Microsoft SQL Server 2005 performs dynamic memory management based on the memory requirements of the current load and activities on the system. On a Windows Server 2003-based system, SQL Server 2005 can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API. On a Microsoft Windows 2000 Server-based system, SQL Server 2005 periodically calculates the free physical memory on the system by using the native Windows API. Based on this information from the QueryMemoryResourceNotification Windows API or from the memory calculation, SQL Server 2005 responds to the current memory situation on a specific system. This provides the following benefits:

• The system does not page out the working set of the SQL Server 2005 process.
• The necessary database pages are available in memory to reduce physical I/O needs.

For more information, see the "Dynamic memory management" topic and the "Server memory options" topic in SQL Server 2005 Books Online.

 Using DotNetNuke Request Filter 

http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/118/using-dotnetnuke-request-filter.aspx

Using DotNetNuke Request Filter 

 DotNetNuke introduced a request filter option starting with DotNetNuke 4.5.3 that can allow you to take action on a user based on various request parameters. In this article I will walk you through how to setup the request filter to filter out requests from a specific IP address and will discuss in general what the settings are. In this example we will be placing a filter to block all traffic from a user with an IP of 13.12.15.45 and we will redirect them to google.com.

Solution:

So immediately  i knew something was and the last thing that came up my mind was to go directly to the ReportViewer.aspx  itself and add the Culture setting like this below


<%@ Page Language="C#" AutoEventWireup="true" Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage" Culture="en-UK"%>
as we can do that on every page

You can find the page here: C:\program files\microsoft SQL Server\MSQL.3\Reporting Services\ReportServer\Pages
But it depends on where you installed it.

Tip:
If you want to find the path to the page go to your IIS under Default website select ReportServer or Reports Folder > right click Properties...

Hope that helps

Check this link for more details:

http://geekswithblogs.net/naijacoder/archive/2008/06/26/123422.aspx

Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.

SSMSE cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, SQL Server Agent, or SQL Server 2005 Mobile Edition.

http://www.famundo.com/

http://sholtan.famundo.com/

There are several tools on the Internet that can help you to analyze your site. Below are some links which will help you analyze your site.

Is this the best way to get only the date part of a date/time stamp in SQL Server without time part?

Select CAST(FLOOR( CAST( GETDATE() AS FLOAT ) )AS DATETIME)

When a stored procedure is first executed (and it does not have the WITH RECOMPILE option), it is optimized and a query plan is compiled and cached in SQL Server's buffer. If the same stored procedure is called again from the same connection, the server will use the cached query plan instead of creating a new one, saving time and boosting performance.

Displays information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions, if any, within the specified database. Results are displayed only if there is an active transaction or if the database contains replication information. An informational message is displayed if there are no active transactions.

Use the Select Report Model Generation Rules page to select the rules that are used to generate the metadata from the data source. It is recommended that you use the default selections.

Data Design and Data Modeling with Quest Toad Data Modeler Software

Quest Software's Toad® Data Modeler is powerful data modeling and design tool that is built for the individual developer, DBA and data architect, at a cost organizations can afford.

Toad Data Modeler makes the following database design and modeling chores fast and easy:

How to determine which SQL Server Service Pack version is running on your server?

There are three main methods to identify SQL Server Service Pack version.