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

Headlines today   October 27, 2016

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,130 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: (not yet rated)  Rate this |   Briefcase | 1,119 reads
Previous headlines

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,122 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,960 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,876 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 | 703 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,426 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,261 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,884 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,730 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Installing SQL Server 2016 Language Reference Help from disk

A couple of years ago I blogged about Installing the SQL Server 2014 Language Reference Help from disk. With SQL Server 2016...  Read more...
By Gianluca Sartori 2016/10/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 474 reads

Notes on Designing an After Hours Event for the PASS Summit

This year we’re trying out two ideas on Thursday night, a networking dinner (of a sort) and game night. I...  Read more...
By Andy Warren 2016/10/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 160 reads
Question of the Day

Concatenate and conatenatex

By Steve Jones 2016/10/27 | Category: power bi
Rating: (not yet rated) |  Discuss |   Briefcase | 464 reads

If I am working in Power BI Desktop, I am trying to decide between CONCATENATE() and CONCATENATEX() in a measure. What items are true about these functions? (choose 2)

Top Members (last 30 days)
# Name Score Level
30 days All-time
318 905 SSC Eights!  
Jeff Moden
272 41708 SSC-Forever  
212 644 SSChasing Mays  
Phil Parkin
209 7766 SSCertifiable  
GP Van Eron
207 2431 SSCrazy  
Latest forum posts