Stop SQL Injection Attacks Before They Stop You
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.
2007-07-09
4,547 reads
Articles
Pop Rivett and the Expanding Log
When your database transaction log is out of control, there is only one man who can tame it.
2007-07-06
2,611 reads
XML not boring! New workbench
Robyn Page and Phil Factor almost dispel the myth that XML is boring, with their radical new SQL Server XML workbench.
2007-07-06
3,684 reads
Certification Rumors and Tips
Should you get certified? How should you do it? Brandie Tarvin brings us some tips on what might work and dispels some of the myths and rumors about certification.
2007-07-05
9,823 reads
SQL Server 2000 SP3a Support is Ending
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
2007-07-05
3,411 reads
Debugging Stored Procedures in Visual Studio 2005
This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.
2007-07-05
4,532 reads
Maintain DTS packages in SQL Server 2005
Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.
2007-07-05
4,915 reads
Monitoring Changes to your Database Schema
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
2007-07-04
2,503 reads
Optimize disk configuration in SQL Server
Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance.
2007-07-04
3,635 reads
The SQLServerCentral.com 3000
Congratulations to two new members of the SQLServerCentral.com 3000 club: Jeff Moden and Noeld.
2007-07-03
1,436 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers