SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2019/01/31 to 2019/02/07

Keeping sensitive Data secure outside of Production

Part of the complication of implementing DevOps into database development is the involvement of data. Microsoft MVP Grant Fritchey explores the use of dynamic data masking and the strategies that can protect the data when it moves into less secure environments like development and test.   Read more...
By 2019/02/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,462 reads

Microsoft SQL Server Utilities and Tools

Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities  Read more...
By Konstantin Taranov 2019/02/07 (first published: 2017/06/23) | Source: SQLServerCentral.com | Category: tools
Rating: |  Discuss |   Briefcase | 4,640 reads

Protecting SQL Server Data Using Static Data Masking

In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.  Read more...
By Additional Articles 2019/02/07 | Source: SimpleTalk | Category: static
Rating: (not yet rated)  Rate this |   Briefcase | 2,583 reads

How SQL Provision completes the Database DevOps story

Database DevOps is not without its challenges. When SQL Provision is introduced into the tool chain it can enable organizations to reduce the burden on network resources, minimize administrative tasks and accelerative database delivery updates. Tony Davis explains how..   Read more...
By 2019/02/06 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,549 reads

Stairway to Data, Level 1: The Basics

A great deal of the confusion that occurs when a database application is developed comes from a poor understanding of the basics of data. Here, Joe Celko gives a broad coverage of the difficulties you're likely to meet when handling data in databases  Read more...
By Joe Celko 2019/02/06 (first published: 2011/05/12) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 18,542 reads

Import data dynamically using R and Python in Power BI Desktop

Learn how to import data into Power BI using either R or Python scripts.  Read more...
By Additional Articles 2019/02/06 | Source: MSSQLTips.com | Category: importing data
Rating: (not yet rated)  Rate this |   Briefcase | 2,086 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2019/02/06 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 104,814 reads

A Tiny Trauma

Unexpected issue with a hidden calculation on TinyInt 
By Mike Tanner 2019/02/05 | Source: SQLServerCentral.com | Category: data type
Rating: |  Discuss |   Briefcase | 892 reads

Complimentary access to Gartner’s 2018 Market Guide for Data Masking from Redgate

According to Gartner, "security and risk management leaders should use data masking to desensitize or protect sensitive data to address threats and compliance requirements." Gartner further adds, "by 2021, the global enterprise use of data masking (DM) or similar de-identification techniques will increase to 40%, an increase from 15% in 2017." Redgate is acknowledged as a representative vendor for data masking. Redgate are offering complimentary access to the report.   Read more...
By 2019/02/05 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,894 reads

Better Code Reviews with GIT

As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.  Read more...
By Additional Articles 2019/02/05 | Source: SimpleTalk | Category: git
Rating: (not yet rated)  Rate this |   Briefcase | 3,143 reads

Getting Started with Database containers

A beginning look at containers in Windows. 
By Steve Jones 2019/02/11 (first published: 2019/02/04) | Source: SQLServerCentral.com | Category: containers
Rating: |  Discuss |   Briefcase | 1,517 reads

Creating Your First Stored Procedure

Learn how to get started writing code modules inside of your SQL Server database,  Read more...
By Steve Jones 2019/02/04 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 833 reads

Compliant Database DevOps for SQL Server using Redgate Tools

In this article Stephanie Herr looks at the Redgate tools that give you an end-to-end compliant Database DevOps Solution  Read more...
By 2019/02/04 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,874 reads

Robotics Process Automation: The New Digital Assistant

When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA and presents a case study.  Read more...
By Additional Articles 2019/02/04 | Source: SimpleTalk | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,092 reads

Database Continuous Integration with SQL Clone and SQL Change Automation

Uses SCA to build the database and SQL Clone to distribute the finished database to the various team-based servers who require the latest build.   Read more...
By 2019/02/01 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,185 reads

Installing R packages in SQL Server R Services

This article shows four ways you can use when installing missing R packages for Microsoft R Services.  Read more...
By Tomaž Kaštrun 2019/02/01 (first published: 2016/09/29) | Source: SQLServerCentral.com | Category: r package
Rating: |  Discuss |   Briefcase | 1,827 reads

The 2019 Data Professional Salary Survey Results

How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it looks like on average, y’all got raises this year.)  Read more...
By Additional Articles 2019/02/01 | Source: Brent Ozar Unlimited Blog | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,914 reads

SQL Server Management Studio add-ins

Complete list of useful and must have add-ins for SQL Server Management Studio - 34 SSMS add-ins  Read more...
By Konstantin Taranov 2019/01/31 (first published: 2017/07/21) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 5,109 reads

Build and fill a database using JSON and SQL Change Automation

Storing your data for development work as JSON confers several advantages. You can exchange data with any application or service that can consume JSON data, you can edit the data easily in a JSON editor, use lightning fast data masking that doesn’t leave a trace in the database, and you can very easily validate the data before you insert it.   Read more...
By 2019/01/31 | Source: Redgate | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,892 reads

Cyber Insecurity in Pakistan

Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.  Read more...
By Additional Articles 2019/01/31 | Source: SimpleTalk | Category: cybersecurity
Rating: (not yet rated)  Rate this |   Briefcase | 3,503 reads