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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,896,026 DBAs, developers and SQL Server users

Headlines today   January 17, 2018

Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions

Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension   Read more...
By Bill Pearson 2018/01/17 (first published: 2011/09/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,987 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 2018/01/17 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 65,418 reads

Introduction to Agile with SQL Server

Working with SQL Server in Agile software development can be difficult. Ben Brumm provides an overview of Agile, specifically Scrum, and what to expect when SQL Server, or really any SQL platform, is involved.  Read more...
By 2018/01/17 | Source: SimpleTalk | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 1,647 reads
Previous headlines

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 676 reads

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.  Read more...
By 2018/01/16 | Source: SimpleTalk | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,629 reads

NEW – Create, protect and manage non-production databases with SQL Provision

Redgate's newest offering helps address data privacy and protection concerns by creating copies of SQL Server databases that mask all sensitive data. SQL Provision serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from one central location, without blocking the team’s development and release processes.  Read more...
By 2018/01/16 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,237 reads

Install Visual Studio 2015 in Server without Internet Connection

Install Visual Studio 2015 in Windows Server without Internet Connection  Read more...
By Vishnu Gupthan 2018/01/15 | Source: SQLServerCentral.com | Category: visual studio
Rating: |  Discuss |   Briefcase | 380 reads

SQL Server Machine Learning Services – Part 2: Python Data Frames

SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do so, you must understand how to work with the data frame object. Robert Sheldon explains how to get started using the data frame object, how to pass data from SQL Server to it, and how to manipulate it with Python and pandas commands.  Read more...
By 2018/01/15 | Source: SimpleTalk | Category: machine learning services (mls)
Rating: (not yet rated)  Rate this |   Briefcase | 2,453 reads

How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell

This article describes a strategy, using data masking, cloned databases, and PowerShell, which will allow you to sanitize data before it is copied or moved, for example from a production environment into testing or development environments.  Read more...
By 2018/01/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,716 reads

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...
By Sergey Benner 2018/01/12 (first published: 2008/08/28) | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 9,649 reads

From the SQLServerCentral Blogs

Changing Default Logs Directory – Back to Basics

Every now and then I find a topic that seems to fit perfectly into the mold of the theme of...  Read more...
By Jason Brimhall 2018/01/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 918 reads

Statistics Use, Extended Events and Execution Plans

Query tuning ain’t easy. Figuring out which index is getting used is one step, and generally simple, look at the execution...  Read more...
By Grant Fritchey 2018/01/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 943 reads
Question of the Day

Valid Objects

By Steve Jones 2018/01/17 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 383 reads

I've got this R class.

> setClass(
+ "NFLTeam",
+ representation(
+ name = "character",
+ City = "character",
+ conference = "character",
+ division = "character"
+ )
+ )
I want to ensure that any instance of this object only uses the values...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
42798 547505 SSC Guru  
Jeff Moden
39888 505505 SSC Guru  
Steve Jones - SSC Editor
24207 328153 SSC Guru  
Lynn Pettis
18168 223098 SSC Guru  
Grant Fritchey
17944 221034 SSC Guru  
Latest forum posts