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 2013/06/17 to 2013/06/24

The Switch Workshop, by Red Gate and Re-Wired Group

Customers don’t just buy a product — they switch from something else. And customers don’t just leave a product — they switch to something else. It’s in these switching moments that the deepest customer insights can be found. On the 25th of July, a select group of 32 people will attend a unique, hands-on, full-day workshop at Red Gate to learn about “The Switch”.  Read more...
By Additional Articles 2013/06/24 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,786 reads

Change Data Capture - SQL Server 2008

Change Data Capture (CDC) records DML operations performed on SQL tables and makes records available with information regarding what changed and when the change happened in a simple way.  Read more...
By Nitesh Dedhia 2013/06/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,145 reads

SQL Server Reporting Services ReportItems Collection

What is SQL Server Reporting Services 2012 (SSRS) ReportItems collection and how do I use it? Are there any restrictions on its use? Check out this tip to learn more.  Read more...
By Additional Articles 2013/06/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 5,030 reads

Maximizing Throughput with TVPs

TVPs offer several performance optimization possibilities that other bulk operations do not allow, and these operations may allow for TVP performance to exceed other bulk operations by an order of magnitude, especially for a pattern where subsets of the data are frequently updated.  Read more...
By Additional Articles 2013/06/21 | Source: SQLCAT | Category: tvp
Rating:  Rate this |   Briefcase | 4,373 reads

SQL Saturday #226 - South Florida

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 29 2013 in Davie, FL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.  Read more...
By Press Release 2013/06/21 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,742 reads

Understanding T-SQL Expression Short-Circuiting

Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.   Read more...
By Gianluca Sartori 2013/06/21 (first published: 2010/12/30) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,399 reads

Avoiding Parameter Sniffing in SQL Server

Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,020 reads

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2013/06/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,212 reads

Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell

Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.   Read more...
By Additional Articles 2013/06/19 | Source: MSSQLTips.com | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 2,990 reads

Review: Stellar Phoenix SQL Database Recovery

Stellar Phoenix SQL Database Recovery Software Review  Read more...
By Prett Sons 2013/06/19 | Source: SQLServerCentral.com | Category: reviews
Rating: |  Discuss |   Briefcase | 680 reads

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services

In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.  Read more...
Rating: |  Discuss |   Briefcase | 8,648 reads

Attention users running SQL Server 2008 & 2008 R2!

Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.  Read more...
By Press Release 2013/06/18 | Source: SQL Blog | Category: cumulative updates (cu)
Rating: (not yet rated)  Rate this |   Briefcase | 10,024 reads

PASS Data Architecture Virtual Chapter presents Steve Simon

On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.  Read more...
By Press Release 2013/06/18 | Source: PASS | Category: pass virtual chapters
Rating: (not yet rated)  Rate this |   Briefcase | 3,353 reads

Usage of CTE - Trick with Dates

This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.  Read more...
By Suresh Maganti 2013/06/18 | Source: SQLServerCentral.com | Category: cursor vs recursive cte
Rating: |  Discuss |   Briefcase | 16,278 reads

Managing Slowly Changing Dimension with MERGE Statement in SQL Server

Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,213 reads

SQL Saturday #229 - Dublin

SQL Saturday Dublin is hosting a two-day training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development. The free training event will be Saturday June 22 2013, and three preconference sessions (not free) will take place the 21st.  Read more...
By Press Release 2013/06/17 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 3,595 reads

PowerShell vs GUI Availability Group Rebuild

Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands   Read more...
By Paul Brewer 2013/06/17 | Source: SQLServerCentral.com | Category: windows cluster
Rating: |  Discuss |   Briefcase | 2,608 reads

Getting Started with the SSAS Tabular Model

SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful way of providing self-service BI to client applications such as Microsoft Excel and Microsoft Power View. You’ve deployed SSAS in tabular mode, and deployed Adventureworks into it. What next? Rob Sheldon explains all.  Read more...
By Additional Articles 2013/06/17 | Source: SimpleTalk | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,826 reads