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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,905,833 DBAs, developers and SQL Server users

Rss
Headlines today   August 20, 2018

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1

In this article, 1st of 2-part series, we will look at 2 approaches to import JSON in SSIS using 2 methods: the new functionality of SQL Server 2016 and the Json.NET library.  Read more...
By Nikolai Basov 2018/08/20 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 413 reads

Creating Multiple Masked Databases with SQL Provision

Sometimes developer teams need access to a copy of the database containing live data. However, if that database contains sensitive or personal data, then it cannot be used for testing and development work, unless all appropriate security measures are in place. The data protection regulations make no distinction between development and production databases, in the event of a data breach. Chris Unwin discusses a way to tackle this problem using SQL Provision  Read more...
By 2018/08/20 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 875 reads

Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6

In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.  Read more...
By Additional Articles 2018/08/20 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 1,084 reads
Previous headlines

Using Code Snippets in SSMS

Snippets will allow you to code faster by inserting chunks of code with few key strokes.  Read more...
By Luis Cazares 2018/08/17 (first published: 2016/04/07) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 4,587 reads

How to Check Performance on a New SQL Server

Before you go live, test your backup and CHECKDB speeds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,036 reads

Forget GDPR. Think HIPAA, SOX, PCI, SHIELD and the CCPA.

Data protection legislation in the USA, however, has been around for a long time, and more is on the way, and for most types of business, the changes will move compliance from a minor issue to a big concern.   Read more...
By 2018/08/17 | Source: Redgate | Category: hipaa
Rating: (not yet rated)  Rate this |   Briefcase | 1,783 reads

Aggregate Data for the Last Day of the Month

On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.  Read more...
By Adam Aspin 2018/08/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 971 reads

Information Security in Practice

Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses the ways that data manages to migrate around the organisation and the challenges found in protecting that data.  Read more...
By Additional Articles 2018/08/16 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,131 reads

SQL Prompt code analysis: avoid non-standard column aliases

Phil Factor looks at SQL Prompt code analysis; column alias violations and the right way to alias  Read more...
By 2018/08/16 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,042 reads

Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux

In this first article of the Stairway to SQL Server on Linux, learn how to set up your host server.  Read more...
By Danilo Dominici 2018/08/15 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 390 reads
 

From the SQLServerCentral Blogs

The Mystery of the Exploding T-Log

There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error: -- Log Name:      ApplicationSource:        MSSQLSERVERDate:          5/24/2018...  Read more...
By Andy Galbraith 2018/08/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,603 reads

Granting CONTROL on a database–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2018/08/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,340 reads
Question of the Day

Using QUOTENAME()

By Steve Jones 2018/08/20 | Category: quotename()
Rating: (not yet rated) |  Discuss |   Briefcase | 413 reads

I have some input strings that I want to use to create SQL Server columns. I want to be sure these are valid identifier strings, so I decide to use...  Read more...
Latest forum posts