Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,878,201 DBAs, developers and SQL Server users

Rss
Headlines today   January 20, 2017

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2017/01/20 (first published: 2012/11/12) | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 50,871 reads

Development Delusions: That it is Enough to Build a Better Mousetrap

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.  Read more...
By Additional Articles 2017/01/20 | Source: SimpleTalk | Category: development
Rating: (not yet rated)  Rate this |   Briefcase | 816 reads
Previous headlines

Keeping Fact Tables Online while Loading via Partition Switching

Provides overview of steps that can be used to keep fact tables online during loading process.  Read more...
By Shubhankar Thatte 2017/01/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 788 reads

What's New in Reporting Services 2016 Service Pack 1

SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.  Read more...
By Additional Articles 2017/01/19 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 2,574 reads

Free Webinar: An Introduction to DevOps

Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is to get started. Redgate have invited James Betteley, Head of Education at the DevOpsGuys, to run through the basics in this free webinar. Register now.  Read more...
By 2017/01/19 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,109 reads

Put your Database under Source Control

This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.  Read more...
By Thomas Liddle 2017/01/18 | Source: SQLServerCentral.com | Category: db source control
Rating: |  Discuss |   Briefcase | 676 reads

Five Useful SQL Server Management Practices

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.  Read more...
By Kenneth Igiri 2017/01/18 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,296 reads

SQL Server v.Next : STRING_AGG() performance

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.  Read more...
By Additional Articles 2017/01/18 | Source: SQLPerformance.com | Category: sql server v.next
Rating: (not yet rated)  Rate this |   Briefcase | 2,002 reads

Using SQL Server and R Services for analyzing Sales data (Part 3)

Using R integration for analyzing sales data in WideWorldImporters database  Read more...
By Tomaž Kaštrun 2017/01/17 | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 925 reads

SQL Server in Azure Virtual Machines - Performance Optimizations

When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. This article explores a couple of these enhancements, with a particular focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).  Read more...
By Additional Articles 2017/01/17 | Source: Database Journal | Category: azure vm
Rating: (not yet rated)  Rate this |   Briefcase | 3,543 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Easy Database Space with dbatools

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is...  Read more...
By Steve Jones 2017/01/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 915 reads

The two types of IT worker

Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running...  Read more...
By Andrew Pruski 2017/01/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,059 reads
Question of the Day

Finding the name

By Steve Jones 2017/01/20 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 294 reads

I have this XML data in a variable:


DECLARE @Data XML
SET @Data ='
<Playoffs>
<AFC>
<TopSeedQuarter>
<Home>Patriots</Home>
<Away>Texans</Away>
</TopSeedQuarter>
<SecondSeedQuarter>
<Home>Chiefs</Home>
<Away>Steelers</Away>
</SecondSeedQuarter>
</AFC>
<NFC>
<TopSeedQuarter>
<Home>Cowboys</Home>
<Away>Packers</Away>
</TopSeedQuarter>
<SecondSeedQuarter>
<Home>Falcons</Home>
<Away>Seahawks</Away>
</SecondSeedQuarter>
</NFC>
</Playoffs>
'

...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
joseph breese
10040 10040 SSChampion  
2.
Jeff Moden
2964 45108 SSC-Forever  
3.
Steve Jones - SSC Editor
1740 36130 SSC-Dedicated  
4.
GilaMonster
1586 47255 SSC-Forever  
5.
SQLRNNR
992 21075 SSC-Insane  
Latest forum posts