Welcome to SQL Server Central

Reporting Services: Adding extra columns / rows to a matrix

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described. Read more...

By Martin Cremer 2008/07/24 | Source: SQLServerCentral.com | Category: Reporting Services

Rating:

|

Discuss |

Briefcase | 2,885 reads

Develop Robust and Scalable Apps with SQL Server Data Services

Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces. Read more...

By Additional Articles 2008/07/24 | Source: Microsoft MSDN | Category: SQL Server Data Services

Rating: (not yet rated) Rate this |

Briefcase | 1,165 reads

Upgrading live applications to SQL Server 2005

Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication. Read more...

By Additional Articles 2008/07/24 | Source: SearchSQLServer | Category: Clustering

Rating: (not yet rated) Rate this |

Briefcase | 871 reads

Operations Manager and SQL Server

Longtime expert DBA Thomas Laorck brings us a short article about how he uses Operations Manager to watch the SQL Servers he is responsible for and ignore others. Read more...

By Thomas LaRock 2008/07/23 | Source: SQLServerCentral.com | Category: Operations Manager

Rating:

|

Discuss |

Briefcase | 2,892 reads

Kimball ETL Part 1 – Data Profiling via SSIS Data Flow

A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process. Read more...

By Ira Whiteside 2008/07/23 | Source: SQLServerCentral.com | Category: ETL

Rating:

|

Discuss |

Briefcase | 2,127 reads

SQLBits III - Registration Now Open!

Registration for SQLBits III, to be held at Hatfield in the UK on September 13th, is now open! SQLBits is the UK's finest SQL Server technical conference, and it's 100% free to attend! Read more...

By Additional Articles 2008/07/29 (first posted: 2008/07/23) | Source: SQLServerCentral.com | Category: User Groups

Rating: (not yet rated) Rate this |

Briefcase | 497 reads

Comparing SQL Server constraints and DML triggers

Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints. Read more...

By Additional Articles 2008/07/23 | Source: Builder.com | Category: Triggers

Rating:

Rate this |

Briefcase | 1,121 reads

How to use ranking functions in SQL Server 2005

With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions. Read more...

By Additional Articles 2008/07/22 | Source: SearchSQLServer | Category: Ranking Functions

Rating:

Rate this |

Briefcase | 3,181 reads

Disabling Indexes

Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index. Read more...

By Andy Warren 2008/07/22 | Source: SQLServerCentral.com | Category: Indexing

Rating:

|

Discuss |

Briefcase | 6,428 reads

SQL Server Audit in SQL Server 2008 – Part 2

Learn how to monitor database-level actions and write audit results to files. Read more...

By Additional Articles 2008/07/22 | Source: Database Journal | Category: Auditing

Rating: (not yet rated) Rate this |

Briefcase | 1,370 reads