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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,893,958 DBAs, developers and SQL Server users

Headlines today   November 22, 2017

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,669 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 | 68,549 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 | 177 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 | 144 reads
Previous headlines

DBAs and the ITIL Framework, Part II: Asset Management

See how the ITIL Framework's Asset Management standards make the DBA's job easier. Use the CMDB and DML to keep your data assets under tight control.  Read more...
By John F. Tamburo 2017/11/21 | Source: SQLServerCentral.com | Category: itil
Rating: |  Discuss |   Briefcase | 399 reads

Preparing your data platform for peak period sales

In the last few years, Black Friday and Cyber Monday have become synonymous with both getting a good bargain and causing retail pandemonium. So how can you prepare your data platform for the increase in traffic?  Read more...
By 2017/11/21 | Source: Redgate | Category: data platform
Rating: (not yet rated)  Rate this |   Briefcase | 962 reads

More SQL Server Features that Time Forgot

SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use caution about using some of them, such as AutoShrink or the Index Advisor. Others, like the database diagramming tool, almost seem to have been quietly abandoned. Robert Sheldon investigates.  Read more...
By Additional Articles 2017/11/21 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,398 reads

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
Rating: |  Discuss |   Briefcase | 142 reads

The real origins of the Agile Manifesto

Many people think the Agile Manifesto was born in in February 2001, when 17 people met at the Snowbird ski resort in Utah. But there’s a problem, a big problem - in fact, one about the size of the USA’s first ever jet fighter. In this blog post, Matt Hilbert looks back to 20th century aircraft design, and finds some very familiar ideas.  Read more...
By 2017/11/20 | Source: Redgate | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 785 reads

Importing Historical Stock Prices from Yahoo Finance into SQL Server

Rick Dobson demonstrate a clean end-to-end solution for importing historical stock ticker prices from Yahoo Finance into a SQL Server table using Python.  Read more...
By Additional Articles 2017/11/20 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 793 reads

From the SQLServerCentral Blogs

Using Plaster To Create a New PowerShell Module

Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week Tracey Boggiano T | B came along to our...  Read more...
By Rob Sewell 2017/11/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 218 reads

Finding Input Parameters in an Execution Plan

The query execution plan is a map of work which SQL Server is going to perform to execute a query....  Read more...
By Dharmendra Keshari 2017/11/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 307 reads
Question of the Day

Are these equal?

By Steve Jones 2017/11/22 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

I have this code, which creates two variables

a <- array(1:12, dim = c(3, 4))
b <- 1:12

This gives me a matrix and a vector, as seen here:

> a
[,1] [,2] [,3] [,4]
[1,] 1... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
50642 467912 SSC Guru  
Jeff Moden
48434 431203 SSC Guru  
Steve Jones - SSC Editor
30622 281424 SSC Guru  
Grant Fritchey
21786 186068 SSC Guru  
Lynn Pettis
20609 189476 SSC Guru  
Latest forum posts