The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone get the right access. DBAs generally need not become experts in Azure networks, but it helps to understand the concepts and language. If you are running a SQL Server Virtual Machine in Azure, then VNets, Subnets, Network Security Groups, VNet peering and VPN gateways are all worth knowing about in order to to keep SQL Servers running smoothly.

How to document multiple SQL Server databases using SQL Doc and PowerShell

by Additional Articles

Redgate

SQL Doc

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows both automation and flexibility.

Azure DWH part 9: Azure PHP and ASDW

by Daniel Calbimonte

SQLServerCentral.com

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.

Listening and Taking Action

by Steve Jones

SQLServerCentral.com

Editorial

Microsoft has changed SQL Server in response to the community. Read about some of the enhancements.

Security and Patching Struggles

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve looks at the WannaCry attacks and server security.

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

by Additional Articles

MSSQLTips.com

SQL Server 2016

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).

Webinar: Extending DevOps practices to SQL Server databases

by Press Release

Redgate

In this free demo webinar, Steve Jones and Arneh Eskandari will show how Redgate’s database DevOps solution works to improve your database development and deployment processes. With a focus on using Team Foundation Server (TFS) work items, the webinar will demonstrate how Redgate tools plug into TFS, TFS Build, and Microsoft Release Management. Register now.

Forecasting with SQL

by Mark Wojciechowicz

SQLServerCentral.com

T-SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.

Pseudonymisation

by Phil Factor

SQLServerCentral.com

Editorial

Pseudonymisation is a form of data masking, a technique that becomes more important to data professionals all the time.

Registration Now Open for SQL Cruise Alaska in August 2017

by Tim Ford

SQLServerCentral

Events

It’s been a while since SQL Cruise has been in Alaska, but come August 12 2017 we are returning in a big way for our 13th event since our founding in 2010, bringing one of the most sought-after minds in Microsoft SQL Server for a week of instruction, conversation, and insight: Bob Ward. The SQL […]

Azure Networking for SQL Server DBAs

How to document multiple SQL Server databases using SQL Doc and PowerShell

Azure DWH part 9: Azure PHP and ASDW

Listening and Taking Action

Security and Patching Struggles

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Webinar: Extending DevOps practices to SQL Server databases

Forecasting with SQL

Pseudonymisation

Registration Now Open for SQL Cruise Alaska in August 2017

Blogs

Automatic Index Compaction

Monday Monitor Tips: Virtual Machine Usage and Cost

Advice I Like: Respect

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

SQL Server Still Wins

DBCC CHECKDB Limits I

Question of the Day

DBCC CHECKDB Limits I