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

Headlines today   October 26, 2016

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.  Read more...
By Daniel Calbimonte 2016/10/26 | Source: | Category: export
Rating: (not yet rated) |  Discuss |   Briefcase | 153 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2016/10/26 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 51,730 reads

Real-time Operational Analytics in SQL Server 2016 - Part 2

Arshad Ali discusses the different design considerations for leveraging the Real-time Operational Analytics feature of SQL Server 2016, covering the different scenarios where it fits or does not fit, and how to get started with it for disk based tables.  Read more...
By Additional Articles 2016/10/26 | Source: Database Journal | Category: operational analytics
Rating: (not yet rated)  Rate this |   Briefcase | 177 reads
Previous headlines

Managing Registered servers with SQL Powershell

Learn how to generate Registered Servers with PowerShell in this article.  Read more...
By Arco Scheepen 2016/10/25 | Source: | Category: registered servers
Rating: (not yet rated) |  Discuss |   Briefcase | 587 reads

Master Data Services – The Basics

Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained, gives organisations a powerful alternative to increasingly having to centralize databases as a way of preventing data from getting out sync or become inconsistent, and a reliable way of managing the flow of data through corporate IT systems. It makes microservice architectures realistic. Hari Yadav shows you how to get up and running with MDS.  Read more...
By Additional Articles 2016/10/25 | Source: SimpleTalk | Category: master data services (mds)
Rating: (not yet rated)  Rate this |   Briefcase | 2,102 reads

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 | 1,181 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:  Rate this |   Briefcase | 1,687 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 | 1,455 reads

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,852 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,791 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Read this before using SQL 2016 Temporal Tables

I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...  Read more...
By Daniel Janik 2016/10/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 304 reads
Question of the Day

The default temporal history table

By Steve Jones 2016/10/26 | Category: temporal tables
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

I decide to create a new table for tracking Orders and want to have this be a Temporal table. I use this syntax:

CREATE TABLE [dbo].[Orders](
... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
327 905 SSC Eights!  
Jeff Moden
234 41663 SSC-Forever  
212 644 SSChasing Mays  
Phil Parkin
210 7753 SSCertifiable  
GP Van Eron
207 2431 SSCrazy  
Latest forum posts