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,741 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: |  Discuss |   Briefcase | 1,850 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 | 52,681 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 | 1,601 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: |  Discuss |   Briefcase | 659 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,318 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,225 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,781 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,596 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,900 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,804 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 | 1,475 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 | 576 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
322 905 SSC Eights!  
Jeff Moden
238 41674 SSC-Forever  
Phil Parkin
216 7763 SSCertifiable  
212 644 SSChasing Mays  
GP Van Eron
207 2431 SSCrazy  
Latest forum posts