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

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,496 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,541 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 | 1,988 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,766 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,761 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,034 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,503 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 | 828 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,862 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,077 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,175 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,819 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,898 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,106 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,879 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,491 reads

Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps

This article explains how to set up a SQL Server source control and database continuous integration (CI) process from scratch, using Azure DevOps, Git, PowerShell and Redgate tools, in three steps  Read more...
By 2019/01/30 | Source: Redgate | Category: sql toolbelt
Rating: (not yet rated)  Rate this |   Briefcase | 1,901 reads

Cleanup SQL Server Query Store Data After Database Restore

In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.  Read more...
By Additional Articles 2019/01/30 | Source: MSSQLTips.com | Category: cleanup
Rating:  Rate this |   Briefcase | 1,969 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2019/01/30 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 55,374 reads