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

Headlines today   December 6, 2016

Non-Numeric Measures in DAX

Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create text, date or Boolean measures.  Read more...
By James McGillivray 2016/12/06 | Source: | Category: dax
Rating: |  Discuss |   Briefcase | 269 reads

Azure SQL Database - Authenticating Application Access by Using Azure AD Tokens

Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications or services in a non-interactive manner, by relying on token-based authentication.  Read more...
By Additional Articles 2016/12/06 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,448 reads

Have you adopted database DevOps?

Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card.  Read more...
By 2016/12/06 (first published: 2016/12/02) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,992 reads
Previous headlines

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines  Read more...
By Ginger Keys 2016/12/05 | Source: | Category: always on
Rating: |  Discuss |   Briefcase | 711 reads

Representing Hierarchical Data for Mere Mortals

Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of doing it, more complete than JSON, but easier to read than XML. To try to convince you, he gives a set of flying demos, using PowerShell and his PSYaml module, to illustrate how YAML can let you work faster, and more accurately.  Read more...
By Additional Articles 2016/12/05 | Source: SimpleTalk | Category: hierarchical data
Rating: (not yet rated)  Rate this |   Briefcase | 1,904 reads

Use SSMS and Visual Studio?

Redgate is running a short survey to better understand the tools you're using for database development. There are eleven questions, and three $50 Amazon gift cards up for grabs as a thank you for responding.  Read more...
By 2016/12/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,018 reads

Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT

As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)  Read more...
By Frank A. Banin 2016/12/02 (first published: 2015/08/06) | Source: | Category: hadoop
Rating: |  Discuss |   Briefcase | 9,388 reads

4 Keys to a Clean Angular Implementation

Can there be true separation of concerns with MVC? Not entirely, especially when Angular's templates allow you to so much flexibility; but there is a great deal to be gained from following guidelines to ensure that all business logic is performed in the code-behind as directed by the controller or its delegate, and that all operations on the model are done in the controller: Michael Sorens explains the four essential guidelines for an easily-maintained system.  Read more...
By Additional Articles 2016/12/02 | Source: SimpleTalk | Category: angular
Rating: (not yet rated)  Rate this |   Briefcase | 3,770 reads

How to download a file from internet using SSIS

In this example, we will show how to download a file from internet using SSIS.  Read more...
By Daniel Calbimonte 2016/12/01 | Source: | Category: ssis
Rating: |  Discuss |   Briefcase | 1,576 reads
Redgate DevOps Survey

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 27 – Synoptic Panel)

In this module you will learn how to use the Synoptic Panel Power BI Custom Visual.  The Synoptic Panel is...  Read more...
By Devin Knight 2016/12/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 454 reads
Question of the Day


By Steve Jones 2016/12/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 341 reads

The new STRING_ESCAPE() function in SQL Server 2016 takes two parameters: a string to escape and a type of escaping rules. What are valid values for the type?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
352 6555 SSCertifiable  
Jeff Moden
240 42060 SSC-Forever  
Ed Wagner
198 9939 SSCrazy Eights  
Luis Cazares
148 8205 SSCrazy Eights  
Phil Parkin
147 7960 SSCertifiable  
Latest forum posts