Articles tagged Microsoft

29 March 2021
29 March 2021

Data Platform: Links to Study and Learn

0
2
Last Friday I appeared in the middle of a Brazilian Twitch live made by a friend and while they were talking and studying, I provided some links full of content to them. Nowadays, there are a lot of free content on internet. Not only free content, but also content well organized in a good sequence … Read more
15 March 2021
15 March 2021

Count Distinct and Window Functions

0
3
Or: How to make magic tricks with T-SQL Starting our magic show, let’s first set the stage: Count Distinct doesn’t work with Window Partition Preparing the example In order to reach the conclusion above and solve it, let’s first build a scenario. Using Azure SQL Database, we can create a sample database called AdventureWorksLT, a … Read more
08 March 2021
08 March 2021

The Game Changed: Power BI Premium per User

0
4
Until now, one common knowledge about Power BI was how Power BI Premium subscription is expensive. We, regular mortals, could only dream with the full set of features offered by Power BI Premium. The new announcement is a complete game changing for the enterprise self-service BI technology: Power BI Premium per User will be available … Read more
15 February 2021
15 February 2021

Custom Binding for Azure Functions

0
4
Azure Functions are a great development tool, allowing us to create serverless software. However, one detail was bothering me when I create a function: The HTTP Trigger receives a HTTPRequest object and we need to extract the parameters from the request. This becomes kind of a low-level code mixed with our business code. It’s like going … Read more
01 February 2021
01 February 2021

Azure SQL and Managed Identity

0
7
Azure SQL has a close relationship with Azure Storage. Features like Polybase, backups, extended events and more make use of Azure Storage. On Azure SQL Database, probably the most common use is Extended Events. When we create a file target, we need to point to the Azure Storage URL where the file will be stored. … Read more
18 January 2021
18 January 2021

Power BI reading Parquet from a Data Lake

0
11
Data Lakes are becoming more usual every day and the need for tools to query them also increases. While writing about querying a data lake using Synapse, I stumbled upon a Power BI feature I didn’t know was there. When reading from a data lake, each folder is like a table. We store in the … Read more
01 February 2012
01 February 2012

Geek of the Week: Don Syme

With the arrival of F# 3.0 Microsoft announced a wide range of improvements such as type providers that made F# a viable alternative to their other .NET languages as a general purpose workhorse. So what exactly are type providers, and why are they a killer reason for using F#? Why should we be considering F# for data-rich applications? To find out, we caught up with Don Syme, F#'s creator, to ask him about the latest developments in F# 3.0 and canvas his views on functional programming in general.… Read more
26 November 2009
26 November 2009

Donald Knuth: Geek of the Week

Donald Knuth is an extraordinary man. As well as inventing 'Literate Programming' and writing the most important textbook on programming algorithms, he is also famous for designing and programming one of the most widely-used digital typesetting systems ever, even designing the fonts that went with it. He also pioneered the use of 'Open-source' software. Knuth is a man of engaging charm and enthusiasms who combines a knowledge of history, music, art and mathematics with a unique insight into the art of computer programming.… Read more
13 November 2009
13 November 2009

Simon Peyton Jones: Geek of the Week

Simon Peyton Jones is a Principal Researcher at Microsoft Research's lab in Cambridge. Although he is best known as the developer of the definitive Haskell Compiler, his influence on the development of the new generation of functional languages such as F# has been profound. He has also been in the forefront of the development of parallel programming using Software Transactional memory. We sent Richard Morris across the road to find out more.… Read more
01 June 2009
01 June 2009

Windows Server Virtualisation: Hyper-V, an Introduction

For SQL Server and Exchange Server, Windows Server Virtualization is going to be increasingly important as a way for the administrator to allocate hardware resources in the most efficient way, to offer more robust services, and for deploying services. Jaap Wesellius starts his new series on Hyper-V by explaining what Hyper-V is, how it relates to Windows Server 2008 and how it compares to ESX, Virtual Server and Virtual PC. .… Read more