Tin Pan Alley BBS > Home ( DNN 3.3.5 )

The Trouble with Transactional Replication and large articles.

This article will show you one way to quickly restore SQL Server replication with huge tables.

5/18/2012 6:00:00 AM

SQL in the City the one day free SQL Server training event is back in London this July. Join fellow SQL Server professionals for 5 hours of technical presentations on key issues for SQL Server developers and DBAs delivered by top MVPs. The event also offers you the chance to network with users passionate about SQL Server and the chance to see the latest Red Gate tools and meet the developers who built them. Find out more and register today.

5/18/2012 6:00:00 AM

Implementing Foreach Looping Logic in SSIS

With SSIS, it is possible to implement looping logic into SSIS's control flow in order to define a repeating workflow in a package for each member of a collection of objects. Rob Sheldon explains how to use this valuable feature of SSIS.

New! SQL Monitor 3.0
Red Gate's multi-server performance monitoring
and alerting tool gets results from Day One.
Simple to install and easy to use –
download a free trial today.

5/18/2012 6:00:00 AM

Generating n-Tuples with SQL

An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc.

5/17/2012 6:00:00 AM

SQL Server Central Webinar Series #18 - Don’t Lose Your Data: Top Tips for Backup, Verification and Restore

Join us on May 22, 4:00GMT to learn how to include verification as a part of your backup and recovery strategy with Grant Fritchey.

5/17/2012 6:00:00 AM

Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass

A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.

5/17/2012 6:00:00 AM

The Real World: Implementing AWE

Describes the gains experienced in my environment by impleenting AWE.

5/16/2012 6:00:00 AM

Stop Asking and Start Making Decisions Today

You’re desperately trying to get things done but it’s just not happening for you. I’m going to let you in on a little secret, you’re doing it wrong!

5/16/2012 6:00:00 AM

SQL Relay 2012

This May brings SQL Server experts to your locality; full day seminars in Edinburgh, Manchester, Birmingham, Bristol and London. Overview sessions from Microsoft in the morning, Deep Dive sessions in the afternoon from SQL Server MVP's and evening community events.

5/16/2012 6:00:00 AM

How to Create an Indicator and Gauge Report in SSRS - SQL Server 2008 R2 - Part 1

Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.

5/16/2012 6:00:00 AM