Auditing in SQL Server 2008
This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.
2009-04-23
2,372 reads
Additional Articles
Using The File System Task in SQL Server 2008 Integration Services
This article examines the File System Task which can perform numerous operations on files and directories such as create, move, delete, and also to set the attributes of files and folders.
2009-04-23
2,718 reads
Getting the SSIS package store to work with a SQL Server named instance
We have a named SQL instance and I am able to connect to the instance, but when I try to view the SSIS packages stored in the MSDB database I get an error. This does not happen with our default instances. Is there an additional setting that must be changed to get this to work?
2009-04-22
2,714 reads
SQL Server Data Mining: Plug-In Algorithms
Describes how SQL Server 2005 Data Mining allows aggregation directly at the algorithm level. Although this restricts what the third-party algorithm developer can support in terms of language and data types, it frees the developer from having to implement data handling, parsing, meta data management, session, and rowset production code on top of the core data mining algorithm implementation.
2009-04-22
1,606 reads
Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
2009-04-21
1,993 reads
Installing Data Protection Manager 2007 as a VM in a lab environment
This article describes how to install DPM 2007 as a virtual machine in a lab environment. Here are the gotchas to look out for and an explanation of the benefits you can realise.
2009-04-21
887 reads
Configuring the Maximum Degree of Parallelism
How to configure settings to limit the number of processors used in parallel query execution
2009-04-20
3,121 reads
Do SQL Server User Defined Datatypes (UDT) affect performance?
There is a legend among SQL Server developers and DBAs saying that UDTs may degrade performance. In this article I prove whether this believe is right or wrong.
2009-04-20
3,361 reads
Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.
2009-04-17
2,192 reads
How To Read A PayPal Notification Email
Learn how to read information from a PayPal Notification email by using Microsoft Access, Outlook and VBA.
2009-04-17
3,025 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