SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/10/12 to 2012/10/19

Exporting Master Data from Master Data Services

This white paper describes how to export master data from Microsoft SQL Server Master Data Services (MDS) using a subscription view, and how to import the master data into an external system using SQL Server Integration Services (SSIS). The white paper provides a step-by-step sample for creating a subscription view and an SSIS package.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,283 reads

How to Monitor for High CPU utilization in SQL Server

This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.  Read more...
By Geoff Albin 2012/10/19 (first published: 2010/11/17) | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 25,752 reads

The Technical Nuances of Technical Writing

A helpful guide to writing technical papers by focusing on the non-technical elements.  Read more...
By Jamie Scharbrough 2012/10/18 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 4,341 reads

Exploring Semantic Search Key Term Relevance

SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come up with a system to rival the industry-leaders, one that could extract the contextual meaning of terms in text, or automatically categorise the subject matter of text? On first inspection, it seems unlikely.  Read more...
By Additional Articles 2012/10/18 | Source: SimpleTalk | Category: semantic search
Rating: (not yet rated)  Rate this |   Briefcase | 2,967 reads

Report Builder 3.0: Adding Charts to Your Report

Charts are one of the commonest ways of visualizing reports from data. Report Builder provides a way of generating charts and reports that will be intuitive to anyone who has done the same in Excel. Robert Sheldon provides a simple explanation of how to get the best from charts using Report Builder.  Read more...
By Additional Articles 2012/10/17 | Source: SimpleTalk | Category: report builder
Rating:  Rate this |   Briefcase | 3,621 reads

Stairway to XML: Level 6 - Inserting Data into an XML Instance

The modify method lets you manipulate XML data using XML DML. It can insert, alter or delete data. In this level, Robert shows how to use the method to insert a node into an XML instance.   Read more...
By Rob Sheldon 2012/10/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,574 reads

SQL Southwest, Thursday 18th Oct - User Group Meetup and Virtual Meetup

October's meeting on Thursday 18th will be a virtual meeting which means anyone in the world can attend if they have access to a PC with an internet connection. We are pleased to announce that Grant Fritchey will be giving us 2 sessions.   Read more...
By Additional Articles 2012/10/16 | Source: SQL Community | Category: user groups
Rating: (not yet rated)  Rate this |   Briefcase | 2,342 reads

SQL in the City - Seattle 2012

Start the week in Seattle off with a free day of training on Nov 5, 2012 with SQL in the City. Grant Fritchey, Steve Jones and more will be talking SQL Server in the Pacific Northwest. Join us and debate and discuss SQL Server the Red Gate Way.  Read more...
By Press Release 2012/10/16 (first published: 2012/09/13) | Source: SQLServerCentral.com | Category: sql in the city
Rating:  Rate this |   Briefcase | 5,662 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,410 reads

Stairway to XML: Level 5 - The XML exist() and nodes() Methods

The XML exist() method is used, often in a WHERE clause, to check the existence of an element within an XML document or fragment. The nodes() method lets you shred an XML instance and return the information as relational data.   Read more...
By Rob Sheldon 2012/10/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,259 reads

What is SSIS? Level 1 of the Stairway to Integration Services

Learn about the very basics of what Integration Services is and how it's used in SQL Server.  Read more...
By Andy Leonard 2013/05/27 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 72,690 reads

Designing & Maintaining SQL Server Transactional Replication Environments

Microsoft IT protects against unplanned Transactional Replication outages and issues by using best practices and proactive monitoring. This results in increased stability, simplified management and improved performance of transactional replication environments.  Read more...
By Additional Articles 2012/10/12 | Source: Microsoft MSDN | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 5,287 reads