As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.

The Rights for Data

by Steve Jones

SQLServerCentral.com

Editorial - WMV

As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.

Mastering SQL Server Profiler - Part 3: Getting Started

by Brad McGehee

SQLServerCentral.com

Video

This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.

Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

by Lynn Pettis

SQLServerCentral.com

Blogs

While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...

Script a cube using Windows PowerShell and AMO

by Additional Articles

Database Journal

PowerShell

This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.

SQL Server Audit: Magic without a Wizard

by Additional Articles

SimpleTalk

Auditing

In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.