SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,894,028 DBAs, developers and SQL Server users

Headlines today   November 24, 2017

Bones of SQL - The Calendar Table

This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.  Read more...
By Bob Hovious 2017/11/24 (first published: 2016/09/08) | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 5,729 reads

How advanced is database DevOps in financial services?

Whether you’re exploring the advantages of DevOps or already fully immersed in the journey, including the database brings additional advantages. But how are you performing compared to the competition? What could you do better? What’s the benchmark you should be aiming for?  Read more...
By 2017/11/24 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 206 reads

Implied Predicate and Partition Elimination

Erik Darling's delighted to see that SQL Server does some creative partition elimination.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 169 reads
Previous headlines

Databases in Azure… Where to begin? Create a Database and log in!

Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.  Read more...
By Michael Morin 2017/11/23 (first published: 2016/06/16) | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 2,243 reads

Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS

In this demo heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS.  Read more...
By 2017/11/23 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,341 reads

SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs

By being able to run R from SQL Server, you have available to you not just a convenient way of performing analysis on data but also a wide range of more specialized graphical facilities. Rob Sheldon illustrates the point by demonstrating how you can create sparklines that can then be embedded in reports.  Read more...
By 2017/11/23 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 1,146 reads

Stairway to MDX - Level 3: The Order() Function

The Order() function provides the 'hierarchized' sorts you need for reports and applications using MDX. In this Step, Business Intelligence Architect Bill Pearson explores using the versatile Order() function for providing dataset sorts that respect dimensional hierarchies.  Read more...
By Bill Pearson 2017/11/22 (first published: 2011/05/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,892 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/11/22 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 69,485 reads

SQL Source Control v6 now supports SQL Server 2017, SQL Graph, and TFS 2018

SQL Server 2017 went on general release a couple of weeks ago and the latest version of SQL Source Control offers full support, as well as support for Team Foundation Server (TFS) 2018. This brings a whole host of benefits and opens up cross-platform workflows, encompassing both on-premises and cloud, through connections to SQL Server instances on Linux and Azure Active Directory authentication.  Read more...
By 2017/11/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,288 reads

Dynamic Data Masking on Azure SQL Database

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application.  Read more...
By Additional Articles 2017/11/22 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 839 reads

From the SQLServerCentral Blogs

Login failed for 'NTAUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet

Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups. If you've ever received the message "login failed...  Read more...
By Don Halloran 2017/11/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 404 reads

SQL Puzzle 4: The Beale Papers

I’ve not done a SQL puzzle for a while so thought it was getting overdue… I set this one for my...  Read more...
By Matthew McGiffen 2017/11/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 209 reads
Question of the Day

Index operations with max degree of parallelism value

Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

SQL Server will consider parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population. You can override the max degree of parallelism value...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
51530 471514 SSC Guru  
Jeff Moden
48888 434663 SSC Guru  
Steve Jones - SSC Editor
31075 283805 SSC Guru  
Grant Fritchey
21814 187636 SSC Guru  
Lynn Pettis
20790 190878 SSC Guru  
Latest forum posts