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,788 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 R Dedhia 2013/06/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,236 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,118 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,383 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,747 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,430 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,034 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,450 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 | 3,005 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 | 685 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,997 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,072 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,389 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,319 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,235 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,600 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,621 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: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,860 reads