Last week reading (2018-05-28)

Last week reading (2018-05-28)

Good day SQL folks!

Monday morning is always tough to start working on serious tasks. I think it is a perfect time to read something interesting before you really go into tons of tasks. Now let me give you some things to read for the rest of the day.

Microsoft SQL Server channel on YouTube

Announced by Bob Ward and I think I will be a frequent guest there. You should also rememeber that there is also a great channel about the Power BI as well.

Set up Azure Cosmos DB global distribution using the SQL API

In this article you will see how to use the Azure portal to setup Azure Cosmos DB global distribution and then connect using the SQL API. There are two main things described – how to configure global distribution using the Azure portal and how to configure global distribution using the SQL APIs.

Modernize and extend your ETL/ELT workflows with SSIS activities in ADF pipelines

As we continue our march towards General Availability (GA) of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), we are excited to announce the release of Execute SSIS Package activity as the most direct and code-free method to invoke SSIS package executions within ADF pipelines.

HOW A SSIS LOOKUP WORKS DIFFERENT FROM A T-SQL JOIN (SSIS SERIES)

With a Lookup in a dataflow in a SSIS Package you can achieve a similar result as with a T-SQL Join clause in a SELECT statement: you can check if a row exists in a different dataset, based on one or more (business / natural / surrogate) key columns. However there are a number of differences.

Announcing SQL Advanced Threat Protection (ATP) and SQL Vulnerability Assessment general availability

SQL Vulnerability Assessment (VA) provides you a one-stop-shop to discover, track and remediate potential database vulnerabilities. It helps give you visibility into your security state, and includes actionable steps to investigate, manage and resolve security issues, and enhance your database fortifications. VA is available for Azure SQL Database customers as well as for on-premises SQL Server customers via SSMS.

 

Cheers,

Damian

Previous Last week reading (2018-05-20)
Next ASF 010: Dejan Sarka interview

About author

You might also like

Last Week Reading 0 Comments

Last week reading (2018-03-11)

SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea How dangerous IMPLICIT_TRANSACTIONS might be What is a Managed Instance (preview)? Yaay! Microsoft has just introduced Managed Instance which allows

Knowledge 0 Comments

Last week reading (2018-04-15)

Good day SQL folks! Spring is everywhere all around us! You might not necessarily see this Monday morning at work… I hope you will have an easy start of the

Last Week Reading 0 Comments

Last week reading (2018-03-04)

Good day SQL folks! Thanks for visiting our blog again!  It’s March already and we are looking for the Spring to come.   Columnstore Indexes – part 120 (“Merge Replication 2016-2017”)

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

− 1 = 7

Protected with IP Blacklist CloudIP Blacklist Cloud