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

Welcome to

A Microsoft SQL Server community of 1,870,523 DBAs, developers and SQL Server users

Headlines today   October 24, 2016

EzAdo - Part 1

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.  Read more...
By Alan Hyneman 2016/10/24 | Source: | Category:
Rating: |  Discuss |   Briefcase | 598 reads

The Sort that Spills to Level 15,000

Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.  Read more...
By Additional Articles 2016/10/24 | Source: | Category: sort
Rating: (not yet rated)  Rate this |   Briefcase | 791 reads

Redgate DLM Demo Webinar

Watch the recording of our latest DLM Demo webinar and learn how to improve your database change management process. See how Redgate DLM plugs into Git, Jenkins & Octopus Deploy so that you can automate your database changes alongside your application code.  Read more...
By 2016/10/24 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 617 reads
Previous headlines

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2016/10/21 (first published: 2015/08/31) | Source: | Category: json
Rating: |  Discuss |   Briefcase | 11,683 reads

SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU9 for SP1.  Read more...
By Steve Jones 2016/10/21 (first published: 2015/02/23) | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 5,738 reads

Memory/Storage Technology Hierarchy and SQL Server

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.  Read more...
By Additional Articles 2016/10/21 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 3,009 reads

Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.   Read more...
By Mala Mahadevan 2016/10/20 | Source: | Category: r programming
Rating: |  Discuss |   Briefcase | 920 reads

SQLServerCentral team in Seattle

The team behind will be in Seattle at the PASS Summit next week, and we’d like to hear from you. If you’re heading to the event, we’d love to get feedback on how you use the site, and hear about any changes you’d like to see. If you’d be willing to have a quick chat, please email us, and we’ll set up some time with Steve and the team.  Read more...
By 2016/10/20 | Source: | Category: pass summit
Rating: (not yet rated) |  Discuss |   Briefcase | 1,703 reads

Getting started with Query Store feature in SQL Server 2016 – Part 3

Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.  Read more...
By Additional Articles 2016/10/20 | Source: Database Journal | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 2,799 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Centralized Management Server 101

Registered Servers I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. :-) This is definitely not...  Read more...
By SqlBarbarian 2016/10/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 496 reads

The dark side of Fn_dump_dblog

I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...  Read more...
By Arun Sirpal 2016/10/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 425 reads
Question of the Day

Let the shell free

By Steve Jones 2016/10/24 | Category: xp_cmdshell
Rating: (not yet rated) |  Discuss |   Briefcase | 352 reads

How do I enable xp_cmdshell in SQL Server 2014?

Top Members (last 30 days)
# Name Score Level
30 days All-time
327 905 SSC Eights!  
212 644 SSChasing Mays  
Jeff Moden
208 41633 SSC-Forever  
GP Van Eron
207 2431 SSCrazy  
Phil Parkin
185 7727 SSCertifiable  
Latest forum posts