A Quick Start to Running Python Code in SQL Server

• SQLServerCentral.com

• Machine Learning Services (MLS)
• Python

• by Emmitt Albright

With the addition of Python to Machine Learning Services in SQL Server 2017, you can now execute your Python code inside of SQL Server.

Scary Data Collection

• SQLServerCentral

• Data Privacy and Protection
• GDPR

• by Steve Jones

More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren’t always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.

Using the SQL Monitor Estate Pages

• Redgate

• SQL Monitor

• by Additional Articles

Kathi Kellenberger introduces the new Estate monitoring pages in SQL Monitor 9, and explains how they will help DBAs monitor and safeguard the security, stability and availability of all servers in their care.

Configuring Azure SQL Databases Using Azure Resource Manager Templates

• Database Journal

• by Additional Articles

Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.

Securing Code Early

• SQLServerCentral

• Secure Programming
• Security
• SQL PROMPT
• Static Code Analysis

• by Steve Jones

Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We’ve published the login so […]

Monitoring SQL Server Performance: What’s Required?

• Redgate

• SQL Monitor
• SQL Monitoring

• by Additional Articles

A monitoring tool must provide us with an understanding of the often-complex performance patterns that databases exhibit when under load, so that we can predict how they will cope with expansion or increase in scale. It must also helps us spot the symptoms of stress and act before they become problems that affect the service, and understand better what was happening within a database when an intermittent problem started.

Automating Builds from Source Control for the WideWorldImporters Database

• Redgate

• Automate

• by Additional Articles

Kendra Little shows how to get the WideWorldImporters database into version control, using SQL Source Control, and then set up an automated database build process, using Azure DevOps with SQL Change Automation.

Free eBook: SQL Server Transaction Log Management

• Redgate

• Transaction Log

• by Press Release

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.

Canine Corgi Completion Contest

• SQLServerCentral

• contests
• humor

• by Steve Jones

Steve is putting on a new contest for you with some fun prizes. Put on your creative hat and submit an entry. Contest ends April 21, 2019.

Stairway to AlwaysOn Level 6: Analyse and Deploy an AlwaysOn Availability Group

• SQLServerCentral.com

• by Perry Whittle

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.