SQL Server Security Part 3
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
Mini ASP based SQL Server admin tool
myLittleAdmin For SQL Server is a web-based SQL Server Database administration tool. It is intended to handle the administration of SQL Server databases over the WWW using ASP. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.
SQL Server 2000 Performance Tuning
A series of web presenatations from Microsoft about tuning SQL Server 2000.
Adding a Column using SQL_DMO
One of our readers needed some help with altering a table with DMO, so Andy has a code sample and some comments in general about how to add objects using DMO. It's good code and a very quick introduction to how objects work. Worth reading!
Speed of Partitioned Views
There has been some talk about the use of partitioned views in SQL Server 2000 to gain performance improvements for scale-out of applications. In this article by Neil Jacobson, he discusses his findings in respect of the speed of partitioned views.
When to Use Dynamic SQL
Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.
SQL Server Beta Programs!
SQL Server is releasing two Beta products this month, a 64-bit version of SQL Server 2000 and service pack 4 for SQL Server 7.0! Note: Liberty requires that customers have access to 64-bit machines. Participating in a SQL Server Beta program can be a lot of fun, with contests, promotions, newsgroup support with members of the SQL team at Microsoft, etc. Come sign up today!
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
Diagnosing and Troubleshooting Slow Partitioned Merge Processes
Direct from Microsoft, learn how to achieve scalable, high-performance merge replication applications.
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers