Saturday, 29 November 2014
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Resource Categories
SQL Server Stuff SQL Server resources
SQL Server Webcasts SQL Server Webcasts
Meeting Collateral PPT's & Scripts from User Group Meetings
Meeting Collateral - Sydney PPTs etc from Sydney Presentations
Meeting Collateral - Melbourne PPTs etc from Melbourne Presentations
Meeting Collateral - Adelaide PPTs etc from Adelaide Presentations
Meeting Collateral - Canberra PPTs etc from Canberra Presentations

Resources
All Resources

22/10/2004 5:59:39 PM Author: philcart
Code To Delete All Triggers in SQL Server 2000
A common problem people face when they attached a database which was in a replication before. All the tables
have DEL / INS / UPD triggers.

They often ask how can I delete all those triggers at once? and make the database usable for single mode use?

The following code will solve their problem.

Author: abhinav kumar Created on: Thursday, 21 October 2004
4/11/2004 1:30:14 PM Author: davele
Yukon DTS presentations Aug - Nov 04
PPT of the SQL 2005 DTS Talk given D. Lean thru Aug - Nov 04. The meeting is mostly demo so very few of these slides will be displayed. I trust the PPT will serve as a reminder of the main points covered & help those unable to make it.
8/11/2004 1:40:52 PM Author: philcart
Capture sp_who output to table
This script will capture the output from sp_who2 to a table. This allows you to,
a) perform trend analysis on server usage
b) easily track down heavy database users and processes for troubleshooting.
c) the script captures all output columns, but with a few simple modifications, you can specify which columns you view. eg: just the spid, dbname, DiskIO and CPUTime.
d) If you want to display activity in a web page, running the output to a table removes the overhead of executing sp_who on the ASP page. The sp_who2 procedure creates it's own temp table and does a lot of reformatting on the results. Reading from your own table is a very simple select statement.

NOTE: Before running this script ensure you have
1) Add your database and server name where indicated by << >>.
2) Make sure you have the server listed as a linked server not a remote server. By default each server should be its own linked server. This is important as the OPENQUERY statement only works for linked servers.

This script has three distinct parts,
Part 1 is a table to hold the output from sp_who2. The table is just a mirror of the sp_who2 output with an identity field added for the PK.

Part 2 is the stored procedure that updates the table. The stored procedure uses the OPENQUERY statement. This means that you don't need to worry about creating and dropping temp tables. It's also an easy way to query select columns in the stored procedure output. The use of 'SET FMTONLY OFF' was suggested by one of the guru's on www.sqlservercentral.com, can't recall who now. Also, before you get carried away, you can't use variables or parameters.

Part 3 is a scheduled job to run the procedure. Currently I have the job running every 7 mins from 2 mins past the hour. Running at this frequency means that the job will run at different times throughout the day. You can change the job to run more frequently, but be aware of the extra overhead on the server and adjust if necessary.
8/11/2004 4:13:27 PM Author: philcart
ASP page for checking database connectivity from Webserver
This page is used to check for database connectivity between the webserver and the database server. We use it in our monitoring package to make sure the database is accessible from the webserver.

It accepts two parameters via the query string. These are the Server and database name that you want to attempt to connect to. It then opens an ADO connection to the specified database and queries the sysobjects table of that database. It doesn't return anything from the table, it just uses it in the query as follows,
SELECT 'DATABASE CONNECTION OK' as chkMsg FROM dbo.sysobjects

Example Syntax:
http://webserver/check/chkdb.asp?srvr=DBServer&dbname=DBase

If the connection is successful, this will return a page with,
DBServer - DBase


DATABASE CONNECTION OK

To use, extract the files in the zip to a directory on your webserver.
Alter database connection string in global.asa to have the appropriate username and password to connect to your SQL Server.
Create a virtual directory on IIS pointing to the directory containing the extracted files.
Open web browser and enter URL with appropriate parameters as per example above.

As always, any questions or comments are welcome.
Phill
8/11/2004 4:19:35 PM Author: philcart
ASP page for checking Scheduled Job failures
This page is basically the same as the one for checking database connectivity. The big difference is that it calls a stored procedure to check for Scheduled job failures.

As with the database connectivity page the query string for the URL should contain two parameters. These are the Server and database name where the stored procedure is located. There is also an optional third parameter which the stored procedure accepts. This is the number of minutes for the failure window. The default value for the third parameter is 10 minutes, which will check for any failures within the last ten minutes.

To use, extract the files in the zip to a directory on a machine running IIS.
Connect to the SQL Server you want to check and run the Stored Procedure Creation script.
Alter database connection string in global.asa to have the appropriate username and password to connect to your SQL Server.
Create a virtual directory on IIS pointing to the directory containing the extracted files.
Open web browser and enter URL with appropriate parameters.

Example Syntax:
http://webserver/checker/chkjobs.asp?srvr=DBServer&dbname=DBase&mins=20

As always, any questions or comments are welcome.
Phill
28/01/2005 3:47:54 PM Author: Rowan
Sydney - Jan 2005 - SQL 2005 VLDB Support - Rowan Burke
Here are the slides from the second session
15/02/2005 9:19:58 PM Author: grego
MSDN Webcast: Introducing Full-Text Search in SQL Server 2005—Level 200
Want to learn more about the dramatic enhancements that have been made to the full-text search component in Microsoft® SQL Server™ 2005? This webcast will cover the fundamentals of full-text search in SQL Server 2005, including an examination of the new features and performance upgrades that have been introduced in SQL Server 2005 to support this new feature.


Presenter: Nimish Khanolkar, Development Lead, Microsoft Corporation
URL for Webcast
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032263299&CountryCode=US
15/02/2005 9:25:15 PM Author: grego
MSDN Webcast: Introducing Replication in SQL Server 2005—Level 200
In this webcast you will learn about the new features of replication available in Microsoft® SQL Server™ 2005. See how ease of use and monitoring has been greatly enhanced, along with the ability to synchronize subscriptions over the Internet. We'll also cover replicating new SQL Server 2005 data types and the many improvements in merge replication scalability.


Presenter: Li Zhang, Test Manager, Microsoft Corporation

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032263302&CountryCode=US
15/02/2005 9:26:35 PM Author: grego
MSDN Webcast: Introducing Notification Services in SQL Server 2005—Level 200
Notification Services was added to SQL Server 2000 in August of 2002 as a platform for developing and deploying highly scalable notification applications which utilized the power of SQL Server 2000 and the Microsoft .NET Framework. With the release of SQL Server 2005 there have been a number of enhancements made to Notification Services. In this web cast you will learn about notification applications and how Notification Services in SQL Server 2005 can make it easier for you to build and deploy these applications.

Presenter: Tete Mensa-Annan, Program Manager, Microsoft Corporation

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032263436&CountryCode=US
15/02/2005 9:27:36 PM Author: grego
MSDN Webcast: Introducing Reporting Services for SQL Server 2005—Level 200
Reporting Services for SQL Server 2000 was introduced at the beginning of 2004. It allowed users to easily build and deploy interactive server based reports throughout their organizations. With the release of SQL Server 2005 there are many enhancements to the functionality provided by Reporting Services. In this web cast you will be introduced to the new features of Reporting Services in SQL Server 2005 including the new Report controls for Visual Studio.


Presenter: Brian Welcker, Group Program Manager, Microsoft Corporation

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032263306&EventCategory=5&culture=en-US&CountryCode=US