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
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers