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 20, 2018

Balancing Performance and Readability

Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.  Read more...
By Gary Pollock 2018/03/20 | Source: SQLServerCentral.com | Category: coding style
Rating: (not yet rated) |  Discuss |   Briefcase | 20 reads

Different Ways to Import JSON Files into SQL Server

Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.  Read more...
By Additional Articles 2018/03/20 | Source: MSSQLTips.com | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 236 reads

Investigating problems with ad-hoc queries using SQL Monitor

There is nothing wrong with the principle of using ad-hoc queries; one can use them occasionally and perfectly legitimately. However, when ad-hoc queries run as part of a processes that does database operations iteratively, row-by-agonizing-row, they can be one of the most unremitting ways of sapping the performance of a SQL Server instance.  Read more...
By 2018/03/20 | Source: Redgate | Category: ad hoc queries
Rating: (not yet rated)  Rate this |   Briefcase | 198 reads
Previous headlines

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,162 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,461 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,191 reads

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,151 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,445 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,461 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

From the SQLServerCentral Blogs

Migrate SSRS 2017 to Power BI Report Server

Recently I had the pleasure of migrating a SSRS 2017 instance to an instance of Power BI Report Server. I...  Read more...
By Koen Verbeeck 2018/03/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 644 reads

Power BI Custom Visuals Class (Module 93 – Mapbox Visual)

In this module you will learn how to use the Mapbox Visual. The Mapbox Visual allows you to visualize geographical...  Read more...
By Devin Knight 2018/03/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,000 reads
Question of the Day

Localized Install

By Steve Jones 2018/03/20 | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

What are the rules for installing Localized Versions of SQL Server alongside English versions of SQL Server

Top Members (last 30 days)
# Name Score Level
30 days All-time
35320 621185 SSC Guru  
Jeff Moden
32154 571535 SSC Guru  
Steve Jones - SSC Editor
19817 369081 SSC Guru  
Grant Fritchey
16527 252895 SSC Guru  
Lynn Pettis
13938 252183 SSC Guru  
Latest forum posts