TheWindowsUpdate.com

Episode 73, April 24, 2019 – In the world of relational databases, structured query language, or SQL, has long been King of the Queries, primarily because of its ubiquity and unparalleled performance. But many users prefer a mix of imperative programming, along with declarative SQL, because its user-defined functions (or UDFs) allow for good software engineering practices like modularity, readability and re-usability. Sadly, these benefits have traditionally come with a huge performance penalty, rendering them impractical in most situations. That bothered Dr. Karthik Ramachandra, a Senior Applied Scientist at Microsoft Research India, so he’s spent a great deal of his career working on improving an imperative complement to SQL in database systems.

Today, Dr. Ramachandra gives us an overview of the historic trade-offs between declarative and imperative programming paradigms, tells us some fantastic stories, including The Tale of Two Engineers and The UDF Story, Parts 1 and 2, and introduces us to Froid – that’s F-R-O-I-D, not the Austrian psychoanalyst – which is an extensible, language-agnostic framework for optimizing imperative functions in databases, offering the benefits of UDFs without sacrificing performance.

The post Froid and the relational database query quandry with Dr. Karthik Ramachandra appeared first on Microsoft Research.

Continue reading Froid and the relational database query quandry with Dr. Karthik Ramachandra→

Engaging employees and empowering them with rich media tools and access has never been more important. With so many demands on the average worker daily it is vital that information be engaging and demonstrative. Gone are the days when employees would … Continue reading Mark Your Calendars for Microsoft Stream/Live Events Days – HLS Modern Workplace Events Series→

SharePoint news helps you enhance communications and engagement with employees and stakeholders.  Here are our latest enhancements for pages and news in SharePoint:

Audience targeting [starting April 2019]
Email notification for engagement with n… Continue reading April 2019 Updates to SharePoint News→

The Office cloud policy service allows administrators to define policies for Office 365 ProPlus and assign these policies to users via Azure Active Directory security groups.  Once defined, policies are automatically enforced as users sign in and … Continue reading The new cloud-based policy management service for Office 365 ProPlus has been released!→

Today we are pleased to announce the preview of Security Policy Advisor, a new service that can help enterprises improve the security of Office 365 ProPlus clients in their organization.
 
Office provides a rich set of security policies that allow… Continue reading Announcing Security Policy Advisor Preview for Office 365 ProPlus→

The following application provides an example of using Azure AD Service Principal (SP) to authenticate and connect to Azure SQL database. This application measures the time it takes to obtain an access token, total time it takes to establish a connecti… Continue reading Azure AD Service Principal authentication to SQL DB – Code Sample→

In the present, ever-evolving threat landscape, many organizations find their biggest challenges in digital transformation to be ensuring security, privacy, and compliance. With the number of cybersecurity attacks on the rise, tighter local and gl… Continue reading Don’t miss the Compliance & Security Virtual Conference on May 14→

In our first and second posts about troubleshooting the TLS / SSL problems, we worked to fix a “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel” error message.
&n… Continue reading Troubleshooting TLS / SSL communication problems when making HTTP web request in ASP.NET Part 3→