Yukon Resource Center Launhced
This week, SQLServerCentral.com launched its Resource Center all about getting a sneak peak on Yukon. All links are user contributed.
2002-06-14
15 reads
Additional Articles
SQLServerCentral.com Launches SQL Server Security Analzyer
SQLServerCentral.com launched its first online free software, which can evaluate your SQL Server remotely and look for SQL Server security vulnerabilities. This free service looks for weak or no passwords and does a basic penetration test online.
2002-06-13
50 reads
Updated Freeware Product SQLExecMS Released
Oleg Dantchenko has updated his very successful freeware product, SQLExecMS to release 1.5. The new release has a new look, more features and is perfect for rapid development and quick DBA work.
2002-06-12
53 reads
2002 SQL Server Best of Breed Product Nominations
Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.
2002-06-10
16 reads
Query Recompilation in SQL Server 2000
Recompilation yields superior performance in some situations, although excessive recompilation can be detrimental. This article will discuss some of these costs and benefits, and will draw on contrasts between different versions of SQL Server to provide further context for understanding recompilation.
2002-06-07
1,291 reads
Simple email with CDONTS
Here is a strait forward script that allows you to use CDONTS to send email. Note that the Subject, From, CC and BCC are all optional parameters. Because it uses a fully qualified path, this procedure can live in any database on the server. CDONTS will need to be installed on the server.
2002-06-06
693 reads
Red-Gate Survey!
Our friends at Redgate asked us to pass this URL on to our readers. It's a very quick survey, help one our great supports by following the link!
2002-06-06
649 reads
SQL Server Licensing Resources Resource Center
SQLServerCentral.com has now launched it's third Resource Center. This one focuses on giving the reader everything they need to know about licensing SQL Server. All links in this area are user contributed.
2002-06-05
69 reads
Auto-Audit 2.0 Release Announcement
LockwoodTech announces release of Auto-Audit 2.0, an entirely redesigned upgrade to it's popular SQL Auditing tool. Version 2.0 supports plug-in, customized audit architectures, scriptable trigger templates, a trigger and data management module, real data reports, and online analysis of audit data with grouping analysis.
2002-06-04
3,524 reads
DTS Resource Center Launched
SQLServerCentral.com this week launched its second Resource Centers. This time, focusing on DTS. The DTS Resource Center focuses on tracking bugs, articles and books from throughout the Internet.
2002-05-29
55 reads
Blogs
A Basic Update Trigger: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Apply for a 2025 PASS Summit Scholarship
By Brian Kelley
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...
SQL Server TempDB: The Most Overlooked Bottleneck
By Kevin3NF
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...
Forums
Best/easiest way to import an SSIS package...
Folks, Looking for advice on the best way to import a package. I hope...
Measure duplicating its value when non-conformed dimension attribute is included
Hi, I have two fact tables (say FactA, and FactB), that are joined/shared...
balancing numa nodes
Can anybody advise on how i go about balancing threads to each node. As...
Question of the Day
How Many Nested Triggers?
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers