Product Review: SQL Refactor
Danny Lesandrini reviews SQL Refactor, a SQL Server Add-In that works with the new SQL Server Management Studio.
2007-02-01
2,964 reads
Articles
SQL Server Spotlight on Bob Dorr
We continue with our look at the people behind SQL Server with a very interesting interview from one of the senior support
engineers, Bob Dorr.
2007-01-31
4,789 reads
SQL Server 2005 Command Line Tool "SQLCMD" – Part I
This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.
2007-01-31
2,990 reads
Introduction to message-based applications in SQL Server 2005
Tim Chapman discusses the concept of message-based applications, and the new foundation for building these applications included in SQL Server 2005.
2007-01-30
2,733 reads
Using Indexed Computed Columns to Improve Performance
I recently read a blog post on doing case-insensitive text searches on SQL Server 2005. The post said that an index on a computed column might be used even if the computed column itself wasn't used in the WHERE clause. I was curious to test that and see how far I might take it.
2007-01-29
3,398 reads
Maximum Capacity Specifications in SQL Server 2005
SQL Server 2005, the next evolution of SQL Server, should be growing the capacities as well as the capabilities of the product. With some research, Steve Jones brings you the best current information he could find about SQL Server 2005, comared with the SQL Server 7 and 2000 values.
2007-01-26 (first published: 2004-11-01)
41,907 reads
Regular Expression Based Token Replacement in ASP.NET
Damon Armstrong presents an extremely powerful and flexible token replacement mechanism for your ASP.NET applications. It is based on regular expressions so allows you to search for dynamic text, instead of just a static token, in a given string.
2007-01-26
2,182 reads
Building a Distributed Service Broker Application
Service Broker is one of the more interesting and useful new enhancements in SQL Server 2005, however many DBAs are not familiar with this subsystem. New author Santhi Indukuri brings us a practical example of how you can build a distributed application using Service Broker.
2007-01-25
18,945 reads
The Role of the DBA Related to Insider Threats and Regulatory Complian
This article deals specifically with insider threats to IT describing how IT professionals are implementing the necessary products, policies, and procedures to reduce insider threats and provide the necessary reporting for regulatory compliance.
2007-01-24
2,933 reads
CHAPTER FOUR: ORGANIZATIONALLY, WHERE DOES DATA GOVERNANCE FIT?
This is the fourth part of an ongoing series. The series is titled The Data Stewardship Approach to Data Governance. For information regarding future chapters, please use my contact information below. Previous articles were titled The Data Won't Govern Itself, Data Governance Is NOT a Methodology and The Tools of Data Governance.
2007-01-23
1,705 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