(sent Monday and Thursdays)
A community of more than 86,612 database professionals and growing!
(You can login to SQLServerCentral.com with the user name of ambientnet)
SQL LiteSpeed - SQL Server Backups Just Don't Get Any
Better
 |
Software that gives control back to the DBA
Download Free Evaluation Copy |
|
“Our only regret is that we didn’t
find SQL LiteSpeed sooner"
“SQL LiteSpeed is something we would
not want to be without" |
 |
Please support us by visiting
our sponsors
Dependency
Walker
By:
Andy Warren
Dependency Walker has
been around for a while as part of Visual Studio. Have you tried it? Got
the latest version? Andy does a very quick run through of what the product
does, why you might need it, where to get the latest version, and why the
new version is better than the old one (isn't it always?).
Find out about free Trade Publications
By:
Articles Additional
This is a
great site that lists all the free trade publications in various
industries. You have to meet the criteria of course, but you should
definitely check out the offerings.
Test Your SQL Server Security Skills and Compete with Other DBAs!
Today, SQLServerCentral.com has launched its new Testing Center, where
you can take SQL Server related tests to see where your strengths and
weaknesses are. In this month's test, see how much you know about SQL
Server security. If you're one of the members to pass the test (72% score
or higher), you're entered into a contest to win a copy of AppDetective
and one year's worth of support (over $1500 value)! You can only take the
test question test once and it is not timed. After the test, you'll be
given the answers and detailed explainations about why one is
right.
The new Testing Center can be found in the site's main
menu. The test takes about 5-10 minutes.
Can you top these scores?
| Participants so far: 840 Can you beat the average score of 53.3%? Participants who have passed: 199 |
Participants with a perfect score: 9 Participants with score above 90%: 28 Participants with score above 80%: 88 |
Learn the SQL Server Performance Internals
Kalen Delaney's new book is now released! In this first
installment of the hands-on series, SQL Server guru Kalen Delaney walks
you through troubleshooting your SQL Server performance problems. In this
installment, she dives deep into locking and blocking: what causes them,
how to fix them when they are a problem, and how to look into the system
tables to troubleshoot problems. The hands-on series has lots of sample
code to get you started and debugging your own performance problems
quickly! Tech edited by Itzik Ben-Gan.
Get an exclusive SQLServerCentral.com 25% discount this month only at
http://www.netimpress.com/shop/product.asp?product_id=NI-HDO1-1.
Please support us by visiting
our sponsors
| Much
better way to "Get name of current database"
By: dbatodd - Posted: 05/27/2003 (Stand-Alone SQL) Use SQL's own method to get the current DBName, no function needed. ... List All Script By dbatodd |
| Find
Duplicate Indexes - Episode 1 (The Early SQL Versions)
By: lansley - Posted: 05/28/2003 (Stand-Alone SQL) The excellent script contributed by G.R. Preethiviraj Kulasingham (Preethi) Sri Lanka (contributed 2/20/03, modified 5/22/03) identifies duplicate indexes for the database on which the script is run. It requires User Defined Functions, a feature restrict... List All Script By lansley |
| Get
name of current database By: whoteegan - Posted: 05/22/2003 (Stored Procedure) Retrieve the name of the current database for use with bcp and other procedures that require database name. This will help increase the portability of code and less maintenance required when migrating code to new database/server. ... List All Script By whoteegan |
| EventClass
in Trace tables By: lehar - Posted: 05/25/2003 (Stand-Alone SQL) This script creates the table ProfilerEventClass and populates it with the EventClasses and EventNames.This table is useful when working with trace tables, to get the event names by joining the tables on EventClass. ... List All Script By lehar |
| Script
to determine if all chars are same in field
By: hneal_98 - Posted: 05/19/2003 (Stand-Alone SQL) This script is actually based on a script by epol29. That was titled 'Script to count the number of Yes/No in the string', which I found to be an awsome script.Anyway, this script uses the same logic to deterimine if all of the characters... List All Script By hneal_98 |