Become an Author!
Want to be an author and be admired by the SQL Server community? Find out more details about how to be a writer for SQLServerCentral.com, visit this page.
2002-06-19
32 reads
Articles
The Microsoft SQL Server™ Accelerator for BI Launched
The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics.
2002-06-19
4,470 reads
Review of COMCompare by Red Gate
Andy takes a look at the third product in the popular bundle from Red Gate that does comparisons of COM components. Looks like it's easy to use and a nice tool to have around!
2002-06-18
2,900 reads
Creating your own sp_MSforeach stored procedure
This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.
2002-06-17
16,299 reads
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
13 reads
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
46 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
50 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
13 reads
Maintenance Plans - Backups and Removing Old Files
Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!
2002-06-10
7,593 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
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
SSMS V20 encryption vs SQL Server SSL Encryption
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Enable a Disabled Index
Comments posted to this topic are about the item Enable a Disabled Index
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers