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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,898,594 DBAs, developers and SQL Server users

Headlines today   March 19, 2018

Set-Based String Splitting table function

Describe and provide a set-based method that takes a multiple character split term and returns as a table  Read more...
By bevan ward 2018/03/19 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,153 reads

Masking Dates in a Non-Production Database

All too often there’s a reluctance to use masked data since it’s perceived to be just X’s and N’s and therefore not useable. That’s not the case if you use Redgate’s Data Masker tool.  Read more...
By 2018/03/19 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,414 reads

What is the State of My Transparent Data Encrypted Database?

When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,167 reads
Previous headlines

TEMPDB Enhancements in SQL Server 2016

TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.  Read more...
By Dharmendra Keshari 2018/03/16 (first published: 2016/04/13) | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 6,147 reads

Data Encryption Using Always Encrypted in SQL Server

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.  Read more...
By Additional Articles 2018/03/16 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,434 reads

Take the SQL Estate Data Mapping Survey and help shape Redgate’s products

Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you're planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete our short survey.  Read more...
By 2018/03/16 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 1,453 reads

SharePoint Disaster Recovery Plan

Hot standby disaster recovery process where SharePoint farm will become available in minutes  Read more...
By Deepak Kumeri 2018/03/15 | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |   Briefcase | 345 reads

SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python

In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data frame.  Read more...
By Additional Articles 2018/03/15 | Source: SimpleTalk | Category: python
Rating:  Rate this |   Briefcase | 2,290 reads

Extending DevOps to the database with Redgate: the role of automated testing

This webinar will show you how to use Redgate's SQL Test to include automated testing as part of a database DevOps workflow. There will be a walk-through of an automated build and deployment process with DLM Automation in VSTS, and plenty of time to ask questions.  Read more...
By 2018/03/15 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,272 reads

Stairway to U-SQL Level 20: Querying External Data with U-SQL

Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.  Read more...
By Mike McQuillan 2018/03/14 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 479 reads

From the SQLServerCentral Blogs

Book Review: SQL Server 2017 Machine Learning Services With R

Disclaimer: I’m one of the Technical Reviewers for this book. With the rising demand for cloud computing and wide adaptation of...  Read more...
By MarlonRibunal 2018/03/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,867 reads

Simply Debugging

Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...  Read more...
By Kenneth Fisher 2018/03/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,546 reads
Question of the Day

Side by Side Support

By 2018/03/19 | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 474 reads

I am installing a new instance of SQL Server 2017 on a host that has SQL Server installed. Which previous versions of SQL Server could already be on the host...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
35258 621017 SSC Guru  
Jeff Moden
32094 571383 SSC Guru  
Steve Jones - SSC Editor
19787 368997 SSC Guru  
Grant Fritchey
16517 252823 SSC Guru  
Lynn Pettis
13896 252117 SSC Guru  
Latest forum posts