Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/08/19 to 2012/08/26

SQL in Boston -- Red Gate Style

Adam Machanic is speaking at SQL in the City - Boston on Oct 8, 2012.  Read more...
By Additional Articles 2012/08/24 | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,309 reads

Solving the SQL Server Multiple Cascade Path Issue with a Trigger

This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.  Read more...
By Additional Articles 2012/08/24 | Source: MSSQLTips.com | Category: multiple cascade
Rating: (not yet rated)  Rate this |   Briefcase | 1,941 reads

Stairway to MDX - Level 2: The Ordinal Function

Business Intelligence Architect Bill Pearson introduces the MDX Ordinal Function, as a means for generating lists and for conditionally presenting calculations. He also demonstrates the use of the function in creating datasets to support report parameter picklists.  Read more...
By Bill Pearson 2012/08/24 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 13,735 reads

SQL in the City - New York 2012

Come join Grant Fritchey, Steve Jones and others for a free day of training in New York City on Sept 28, 2012.  Read more...
By Press Release 2012/09/17 (first published: 2012/08/23) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,774 reads

Provisioning a New SQL Server Instance – Part Two

So how should you install and configure SQL Server 2012 properly? Glenn Berry completes his two-part series by explaining the steps needed to complete the preparation and do the actual installation.  Read more...
By Additional Articles 2012/08/23 | Source: SimpleTalk | Category: hardware
Rating: (not yet rated)  Rate this |   Briefcase | 2,402 reads

Working with SQL Agent Durations

SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.  Read more...
By Kyle Neier 2012/08/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,789 reads

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.  Read more...
By Gregory Larsen 2012/08/22 | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,774 reads

SQLSaturday #160 - Kalamazoo

SQL Saturday comes back to Michigan. Come see Jeff Moden and others talk SQL Server on Sept 22, 2012.  Read more...
By Press Release 2012/09/12 (first published: 2012/08/22) | Source: SQLServerCentral.com | Category: sql saturday
Rating:  Rate this |   Briefcase | 1,910 reads

Row Number Transformation

The Row Number Transformation calculates a row number for each row, and adds this as a new output column to the data flow. The column number is a sequential number, based on a seed value. Each row receives the next number in the sequence, based on the defined increment value.  Read more...
By Additional Articles 2012/08/22 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 3,648 reads

Red Gate Software announces speaker line up for US SQL in the City tour

SQL in the City is a free, full day training and networking event for database professionals. After the success of last year’s event, Red Gate has expanded the event to cover six cities from sea to shining sea, including: New York, Austin, San Francisco, Chicago, Boston, and Seattle.  Read more...
By Press Release 2012/09/14 (first published: 2012/08/21) | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 1,570 reads

How To Support Multiple SQL Server Package Configurations in SSIS

I have several applications that use SSIS packages and I want to be able to store all the configurations together in a single table when I deploy. When a package executes I need a way of specifying the "application" and having SSIS automatically handle the package configuration based on the application.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,378 reads

Hierarchies in SQL, Part II, the Sequel

In a followup to his first article on Hierarchies, Gus Gwynn takes a look at the performance of a few different methods of querying a hierarchy. Learn how the HierarchyID stacks up.  Read more...
By GSquared 2012/08/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,150 reads

SQL Saturday #169 - Denver

Come join Steve Jones, Glenn Berry, and other Denver area MVPs and speakers for a free day of training in Denver on Sept 22, 2012.  Read more...
By Press Release 2012/09/11 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,942 reads

SSIS Basics: Introducing Variables

In the third of her SSIS Basics articles, Annette Allen shows you how to use Variables in your SSIS Packages, and explains the functions of the system-defined variables.  Read more...
By Additional Articles 2012/08/20 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,790 reads

The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit

The 2012 SQLServerCentral party at the PASS Summit is on and will once again include the awards ceremony for the Exceptional DBA of 2012. Get your tickets now.  Read more...
By Press Release 2012/08/20 (first published: 2012/08/02) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 1,256 reads

Enforce business rules with indexed views and a two-row table

Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.  Read more...
By Dan Ryan 2012/08/20 | Source: SQLServerCentral.com | Category: business rules
Rating: |  Discuss |   Briefcase | 7,745 reads

SQL Saturday #155 - Lima

SQL Saturday is exploding in South America, and Lima hosts it's event on Sept 22, 2012. Come join fellow data professionals and learn about SQL Server.  Read more...
By Press Release 2012/09/10 (first published: 2012/08/20) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,723 reads