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/14 to 2012/12/21

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

How do you develop software?

We’d like to learn more about software development at your company. Complete our 5 minute survey and get a chance at winning a $50 Amazon gift certificate.  Read more...
By Additional Articles 2012/12/19 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,321 reads

SSRS In a Flash - Level 1 in the Stairway to Reporting Services

Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.  Read more...
By Jessica M. Moss 2014/07/04 (first published: 2010/04/06) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 44,939 reads

Report Builder 3.0: Adding Matrices to Your Reports

It is easy to create a basic matrix in Report Builder. However, it takes some practice in order to format and dispay the matrix exactly how you want it. There are a large number of options available to enhance the matrix and Robert Sheldon provides enough information to get you the point where you can experiment easily.  Read more...
By Additional Articles 2012/12/19 | Source: SimpleTalk | Category: report builder
Rating:  Rate this |   Briefcase | 2,693 reads

MDX Guide for SQL Folks: Part II - Hierarchies and Functions

Learn everything about MDX by drawing only on your SQL knowledge.   Read more...
By Frank A. Banin 2012/12/18 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 7,059 reads

Checking SQL Server Services Owner

Not only is the DBA responsible for the running status of the Services, they are responsible that the Service is running with a proper owner.  Read more...
By Additional Articles 2012/12/18 | Source: MSSQLTips.com | Category: service owner
Rating: (not yet rated)  Rate this |   Briefcase | 2,281 reads

Win a Collection of SQL and .NET Books. And a Bookshelf

After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.  Read more...
By Press Release 2012/12/18 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 6,873 reads

QlikView for Beginners - An Introduction to QlikView

A brief introduction to getting started with QlikView.  Read more...
By Mark O'Donovan 2012/12/17 | Source: SQLServerCentral.com | Category: qlikview
Rating: |  Discuss |   Briefcase | 3,114 reads

Parent Package Variable Configuration and Logging

In SSIS, when we use 'parent package variable configuration' the order of event execution is quite different than the normal execution order. In this article we will see what the impact on execution order when we use 'parent package variable configuration'.  Read more...
By Ajit Ghule 2012/12/17 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 2,284 reads

Coping with Infrastructure Upgrades

A common topic for questions on SQL Server forums is how to plan and implement upgrades to SQL Server. Moving from old to new hardware or moving from one version of SQL Server to another. There are other circumstances where upgrades of other systems affect SQL Server DBAs.  Read more...
By Additional Articles 2012/12/17 | Source: SimpleTalk | Category: infrastructure
Rating:  Rate this |   Briefcase | 1,628 reads

Planning for Disaster

There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare in advance to protect their organisation's data assets in the event of an unexpected crisis, and return them to normal operating conditions. To minimise downtime in such circumstances should be the aim of every effective DBA. To plan for recovery, It pays to have the mindset of a pessimist.   Read more...
By Additional Articles 2012/12/14 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 1,547 reads

Disaster Recovery Week

This week we highlight the practice of being prepared for disasters at SQLServerCentral.  Read more...
By Steve Jones 2012/12/14 (first published: 2012/12/10) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,514 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,499 reads

Database Deployment Cribsheet

As part of Simple-Talk's long-running Cribsheet series, they asked William Brewer to write a guide to deployment that described in general terms what is involved in the deployment of a database application, and the sort of issues you're likely to come up against.  Read more...
By Additional Articles 2012/12/14 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 1,938 reads