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

Headlines today   October 28, 2016

Learning SQL Server 2016

Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.  Read more...
By Site Owners 2016/10/28 (first published: 2015/06/22) | Source: | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 10,604 reads

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail  Read more...
By Theo Ekelmans 2016/10/28 (first published: 2015/07/28) | Source: | Category: agent jobs
Rating: |  Discuss |   Briefcase | 10,007 reads


Ahmad Yaseen explains how you can control the number of processors assigned to the SQL Server DBCC CHECKDB command in order to free-up the server's resources.  Read more...
By Additional Articles 2016/10/28 | Source: | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 869 reads
Previous headlines

Dummies Guide for a SQL Server Presentation

Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same  Read more...
By Nagaraj Venkatesan 2016/10/27 | Source: | Category: public speaking
Rating: |  Discuss |   Briefcase | 1,386 reads

SQL Database: How to Configure Active Geo-Replication

Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.  Read more...
By Additional Articles 2016/10/27 | Source: SimpleTalk | Category: azure sql database
Rating:  Rate this |   Briefcase | 1,505 reads

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 | 2,252 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 | 53,101 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 | 2,023 reads

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 | 727 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,568 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Power BI with Narrative Science: Look Who's Talking (Part 2: Predicting the Future)

[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well...  Read more...
By Rayis Imayev 2016/10/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 682 reads

SQL Cruise as a Speaker and Sponsor

SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, severaltimes, about...  Read more...
By Grant Fritchey 2016/10/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 362 reads
Question of the Day

Dropping Audit Sessions

By Steve Jones 2016/10/28 | Category: sql audit
Rating: (not yet rated) |  Discuss |   Briefcase | 299 reads

I have a SQL Audit set up and running on SQL Server 2016. This audit has a single server audit specification enabled and running with it.

I find that the... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
318 905 SSC Eights!  
Jeff Moden
287 41723 SSC-Forever  
212 644 SSChasing Mays  
GP Van Eron
207 2431 SSCrazy  
Phil Parkin
199 7769 SSCertifiable  
Latest forum posts