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,436 DBAs, developers and SQL Server users

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,557 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,704 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 | 2,486 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 | 878 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,698 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,169 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2016/10/19 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 77,709 reads

Join Redgate at PASS Summit 2016

This year Redgate have a breakout session featuring SQL Clone, as well as a booth in the exhibit hall. They'll be giving away all sorts of prizes including SQL-themed playing cards, flying sheep, and a year's worth of the world's strongest coffee! To find out the details of what they'll be up to between October 25 - 28, and to find out how you can attend the exclusive #RedgateRocks party, read this blog post.  Read more...
By 2016/10/19 | Source: Redgate | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 1,139 reads

PowerShell Just Enough Administration

A major difficulty for a System Administrator who wishes to provide access for auditors, Helpdesk staff, developers and other IT people is that adminstrator roles give users more access than they need. It is too easy to make mistakes, or to make more changes than those that were signed-off. With JEA, it is possible to create role-based access control (RBAC) endpoints that define precisely what actions you’ll let your users carry out without needing a elevated, privileged administrator credentials, and which log and report all operations.  Read more...
By Additional Articles 2016/10/19 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,777 reads
Ask SQL Server Central

Question of the Day


By Henrico Bekker 2016/10/21 | Category: compress()
Rating: (not yet rated) |  Discuss |   Briefcase | 495 reads

Which algorithm and return type does COMPRESS() return in SQL 2016
Top Members (last 30 days)
# Name Score Level
30 days All-time
337 905 SSC Eights!  
212 644 SSChasing Mays  
GP Van Eron
208 2431 SSCrazy  
Jeff Moden
204 41617 SSC-Forever  
Phil Parkin
182 7721 SSCertifiable  
Latest forum posts