Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,874,275 DBAs, developers and SQL Server users

Rss
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: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 142 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,102 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,775 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: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 697 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,877 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 | 1,927 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: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 9,372 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,736 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: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,564 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 | 316 reads
Question of the Day

STRING_ESCAPE

By Steve Jones 2016/12/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 186 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?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Eirikur Eiriksson
351 6554 SSCertifiable  
2.
Jeff Moden
240 42060 SSC-Forever  
3.
Ed Wagner
194 9935 SSCrazy Eights  
4.
Luis Cazares
148 8205 SSCrazy Eights  
5.
Phil Parkin
147 7960 SSCertifiable  
Latest forum posts