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/12/20 to 2012/12/27

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 4,504 reads

Database Deployment: The Bits - Database Version Drift

When you are about to deploy a new version of a database by updating the current version, one of the essential pre-deployment checks is to make sure that the version in production is exactly what it should be. If changes have somehow slipped in, you'll need to understand them and deal with them before you can deploy.  Read more...
By Additional Articles 2012/12/27 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,413 reads

Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...
By Sebastian Meine 2012/12/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 25,427 reads

How to create and use Temp tables in SSIS

Creating temp tables in SSIS seems like a straight-forward process using the Execute SQL Task, however there are a couple of properties that must be changed. In this tip, we’ll walk through creating a simple temp table in SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,835 reads

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.  Read more...
By Press Release 2012/12/25 (first published: 2012/10/30) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 17,480 reads

SQLServerCentral Best Practices Clinic: Part 1

We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.  Read more...
By Brad McGehee 2012/12/25 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 22,610 reads

Happy Holidays 2012

Merry Christmas and Happy Holidays from SQLServerCentral  Read more...
By Steve Jones 2012/12/25 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 903 reads

Rudolph The Red-Nosed Tester and Other Festive Arrangements

A Christmas poem and a contest from Simple Talk.  Read more...
By Additional Articles 2012/12/24 | Source: SimpleTalk | Category: contests
Rating:  Rate this |   Briefcase | 1,896 reads

Can a Table Really Have a Clustered Index?

A table doesn't so much "have" a clustered index as a table "is" a clustered index.  Read more...
By Hakim Ali 2012/12/24 | Source: SQLServerCentral.com | Category: bookmark lookup
Rating: |  Discuss |   Briefcase | 8,194 reads

Making the Case for a SQL Server Platform Refresh

With the release of Windows Server 2012, SQL Server 2012, and the new generation of Sandy Bridge Xeon processors, your organization is likely to get many tangible benefits from upgrading your current database infrastructure with a complete platform refresh.  Read more...
By Additional Articles 2012/12/24 | Source: SimpleTalk | Category: platform refresh
Rating:  Rate this |   Briefcase | 2,303 reads

Some tips for working with big data models

The main goal of this article is to present some tips to help professionals that need to work with complex, big, and hard to understand database models that anyone may came across some day.  Read more...
By MauroPichiliani 2012/12/21 (first published: 2011/03/03) | Source: SQLServerCentral.com | Category: model
Rating: |  Discuss |   Briefcase | 28,519 reads

Setting up a Data Science Laboratory

There is no better way of understanding new data processing, retrieval, analysis or visualising techniques than actually trying things out. In order to do this, it is best to use a server that acts as data science lab, with all the basic tools and sample data in place. Buck Woody discusses his system, and the configuration he chose.  Read more...
By Additional Articles 2012/12/21 | Source: SimpleTalk | Category: data science
Rating:  Rate this |   Briefcase | 2,969 reads

PASS Data Architecture VC presents James Serra on Introduction to Master Data Services

On Thursday August 20th 12PM noon Central, James Serra will discuss how companies can consolidate their enterprise data with the new feature of SQL Server 2012 Master Data Services.  Read more...
By Additional Articles 2012/12/20 (first published: 2012/12/18) | Source: PASS | Category: pass virtual chapters
Rating: (not yet rated)  Rate this |   Briefcase | 2,107 reads

Eleven Challenges in Unifying Reference Data

Unifying the reference data across an enterprise can be a bigger job than expected. This article describes one approach to doing so.  Read more...
By David Poole 2012/12/20 | Source: SQLServerCentral.com | Category: reference data
Rating: |  Discuss |   Briefcase | 3,434 reads

SQL Server 2012 Cluster with TempDB on Local Disk

With the introduction of SQL Server 2012 Microsoft officially supports local disk TempDB in SQL Server cluster configurations. This tip will show you how to configure TempDB on a local disk when installing your SQL Server 2012 cluster.  Read more...
By Additional Articles 2012/12/20 | Source: MSSQLTips.com | Category: tempdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,549 reads